Hey all,
I was trying to write a C# function that would delete everything in the old database before doing anything new. The following is the code I tried to use for the deleting part. I tried "Killdatabase" but it doesn't seem to be working. Anyway, is there a way to reference the database in the server and send commands to it? The compiler gives me a error message saying that srv.Databases("Name") is wrong because I am using a property as a method.
p.s. Someone posted a similar question the other day and they solved it in visual basic by introducing a local variable. It didn't work for me on C#.
Many Thanks
Server srv = new Server(con);
srv.Databases("Name").Drop();
Database d = new Database(srv, "Name");
d.Create();
d.ExecuteNonQuery(command);
Ooops, I am sorry. I should have used [] instead of (). But I did have to use a local variable.
Thanks anyway.
