I'd suggest you should use SQLDMO for database management like this. You can use SQLDMO straight from .NET and it has handy methods for dropping/creating/attaching etc databases and other sql server maintainance tasks.
FB > I am working on c# I need a help on Command obect. > I am creating one database ,adding a table adding a record > and I am trying to delete the database .Its always telling > that connection is opened. I can give you the code pls tell > me any wrong. I dont know how to destroy Command object > completely. I have used dispose,close . Heres the code >
