http://dev.csdn.net/develop/article/71/71378.shtmvoid restoreButton_Click(object sender, System.EventArgs e)
两个什么参数?
及其一些内容都看不懂,请高手解答一下。----------------------------------------------------------------
void restoreButton_Click(object sender, System.EventArgs e)
{
string path = pathTextBox.Text;
string dbname = dbDropDownList.SelectedValue; string restoreSql = "use master;";
restoreSql += "restore database @dbname from disk = @path;";
string pai = "use master;ALTER DATABASE Wy SET OFFLINE WITH ROLLBACK IMMEDIATE;ALTER DATABASE Wy SET ONLINE WITH ROLLBACK IMMEDIATE";
SqlConnection conn = new SqlConnection(ConnStr);
SqlCommand com1 = new SqlCommand(pai, conn); SqlCommand myCommand = new SqlCommand(restoreSql, new SqlConnection(ConnStr)); myCommand.Parameters.Add("@dbname", SqlDbType.Char);
myCommand.Parameters["@dbname"].Value = dbname;
myCommand.Parameters.Add("@path", SqlDbType.Char);
myCommand.Parameters["@path"].Value = path;
try
{
conn.Open();
com1.ExecuteNonQuery();
conn.Close();
myCommand.Connection.Open();
myCommand.ExecuteNonQuery();
infoLabel.Text = "恢复成功!<br>已经把备份"+path+"恢复到数据库"; }
catch(Exception ex)
{
infoLabel.Text = "恢复失败!<br>出错信息如下:<br>" + ex.ToString();
}
finally
{
myCommand.Connection.Close(); }
}
两个什么参数?
及其一些内容都看不懂,请高手解答一下。----------------------------------------------------------------
void restoreButton_Click(object sender, System.EventArgs e)
{
string path = pathTextBox.Text;
string dbname = dbDropDownList.SelectedValue; string restoreSql = "use master;";
restoreSql += "restore database @dbname from disk = @path;";
string pai = "use master;ALTER DATABASE Wy SET OFFLINE WITH ROLLBACK IMMEDIATE;ALTER DATABASE Wy SET ONLINE WITH ROLLBACK IMMEDIATE";
SqlConnection conn = new SqlConnection(ConnStr);
SqlCommand com1 = new SqlCommand(pai, conn); SqlCommand myCommand = new SqlCommand(restoreSql, new SqlConnection(ConnStr)); myCommand.Parameters.Add("@dbname", SqlDbType.Char);
myCommand.Parameters["@dbname"].Value = dbname;
myCommand.Parameters.Add("@path", SqlDbType.Char);
myCommand.Parameters["@path"].Value = path;
try
{
conn.Open();
com1.ExecuteNonQuery();
conn.Close();
myCommand.Connection.Open();
myCommand.ExecuteNonQuery();
infoLabel.Text = "恢复成功!<br>已经把备份"+path+"恢复到数据库"; }
catch(Exception ex)
{
infoLabel.Text = "恢复失败!<br>出错信息如下:<br>" + ex.ToString();
}
finally
{
myCommand.Connection.Close(); }
}
e是个事件参数
下面给加上了注释
void restoreButton_Click(object sender, System.EventArgs e)
{
string path = pathTextBox.Text;
string dbname = dbDropDownList.SelectedValue; string restoreSql = "use master;";//use是sql里的关键字 详细使用见sql server帮助
restoreSql += "restore database @dbname from disk = @path;";
string pai = "use master;ALTER DATABASE Wy SET OFFLINE WITH ROLLBACK IMMEDIATE;ALTER DATABASE Wy SET ONLINE WITH ROLLBACK IMMEDIATE";
SqlConnection conn = new SqlConnection(ConnStr);
SqlCommand com1 = new SqlCommand(pai, conn);//构建sql语句 SqlCommand myCommand = new SqlCommand(restoreSql, new SqlConnection(ConnStr));//实例化SqlCommand myCommand.Parameters.Add("@dbname", SqlDbType.Char);
myCommand.Parameters["@dbname"].Value = dbname;
myCommand.Parameters.Add("@path", SqlDbType.Char);
myCommand.Parameters["@path"].Value = path;
//添加参数
try
{
conn.Open();//打开数据库
com1.ExecuteNonQuery();//执行无返回值的操作
conn.Close();//关闭
myCommand.Connection.Open();
myCommand.ExecuteNonQuery();
infoLabel.Text = "恢复成功!<br>已经把备份"+path+"恢复到数据库"; }
catch(Exception ex)
{
infoLabel.Text = "恢复失败!<br>出错信息如下:<br>" + ex.ToString();
}
finally
{
myCommand.Connection.Close(); }
}
恩,讲的很好啊。这个sender跟Delphi中的好像是一样的内涵:)