我使用这个代码通过C#删除数据库
- Int32 result = 0;
- try
- {
- String Connectionstring = CCMMUtility.CreateConnectionString(false,txt_DbDataSource.Text,"master","sa","happytimes",1000);
- sqlConnection con = new sqlConnection();
- con.ConnectionString = Connectionstring;
- String sqlCommandText = "DROP DATABASE [" + DbName + "]";
- if (con.State == ConnectionState.Closed)
- {
- con.Open();
- sqlConnection.ClearPool(con);
- con.ChangeDatabase("master");
- sqlCommand sqlCommand = new sqlCommand(sqlCommandText,con);
- sqlCommand.ExecuteNonQuery();
- }
- else
- {
- con.ChangeDatabase("master");
- sqlCommand sqlCommand = new sqlCommand(sqlCommandText,con);
- sqlCommand.ExecuteNonQuery();
- }
- con.Close();
- con.Dispose();
- result = 1;
- }
- catch (Exception ex)
- {
- result = 0;
- }
- return result;
但是我收到一个错误
Database currently in use
谁能帮忙？
解决方法
尝试这个：
- String sqlCommandText = @"
- ALTER DATABASE " + DbName + @" SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
- DROP DATABASE [" + DbName + "]";
还要确保您的连接字符串默认您为主数据库,或任何其他数据库,而不是您正在丢弃！
除此之外,你真的不需要所有关于你的查询的东西. ConnectionState将始终从“关闭”开始,因此您不需要检查它.同样,将连接封装在使用块中,无需明确地关闭或处理连接.你真正需要做的是：
- String Connectionstring = CCMMUtility.CreateConnectionString(false,1000);
- using(sqlConnection con = new sqlConnection(Connectionstring)) {
- con.Open();
- String sqlCommandText = @"
- ALTER DATABASE " + DbName + @" SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
- DROP DATABASE [" + DbName + "]";
- sqlCommand sqlCommand = new sqlCommand(sqlCommandText,con);
- sqlCommand.ExecuteNonQuery();
- }
- result = 1;
