SqlConnection con = CPublic.ww();
con.Open();
string sql = "select spid from master..sysprocesses where dbid=db_id( 'DBSelectCourse')";
SqlDataAdapter sdr = new SqlDataAdapter(sql, con);
DataTable sa = new DataTable();
DataSet ds = new DataSet();
sdr.Fill(ds);
sa = ds.Tables[0];
SqlConnection conn = new SqlConnection("server=.\\sql2005;database=master;uid=sa;pwd=sa123");
conn.Open();
SqlCommand qw = new SqlCommand();
qw.CommandType = CommandType.Text;
qw.Connection = con;
qw.Parameters.Add(new SqlParameter("@dbname", "DBSelectCourse"));
for (int iRow = 0; iRow <= sa.Rows.Count - 1; iRow++)
{
qw.CommandText = "kill " + sa.Rows[iRow][0].ToString();
qw.ExecuteNonQuery();
}
string sql1 = "use master restore database DBSelectCourse from disk='" + restorePath + "'";
SqlCommand com1 = new SqlCommand(sql1, con);
com1.ExecuteNonQuery();
if (MessageBox.Show("数据库恢复成功", "提示", MessageBoxButtons.OK) == DialogResult.OK)
{
this.Close();
}
.
con.Open();
string sql = "select spid from master..sysprocesses where dbid=db_id( 'DBSelectCourse')";
SqlDataAdapter sdr = new SqlDataAdapter(sql, con);
DataTable sa = new DataTable();
DataSet ds = new DataSet();
sdr.Fill(ds);
sa = ds.Tables[0];
SqlConnection conn = new SqlConnection("server=.\\sql2005;database=master;uid=sa;pwd=sa123");
conn.Open();
SqlCommand qw = new SqlCommand();
qw.CommandType = CommandType.Text;
qw.Connection = con;
qw.Parameters.Add(new SqlParameter("@dbname", "DBSelectCourse"));
for (int iRow = 0; iRow <= sa.Rows.Count - 1; iRow++)
{
qw.CommandText = "kill " + sa.Rows[iRow][0].ToString();
qw.ExecuteNonQuery();
}
string sql1 = "use master restore database DBSelectCourse from disk='" + restorePath + "'";
SqlCommand com1 = new SqlCommand(sql1, con);
com1.ExecuteNonQuery();
if (MessageBox.Show("数据库恢复成功", "提示", MessageBoxButtons.OK) == DialogResult.OK)
{
this.Close();
}
.
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货