UC知道SQL+.NET高手进来帮俺看看这代码～
来源：百度知道 编辑：UC知道 时间：2024/05/22 01:09:19
{
///
///备份方法
///
SqlConnection conn = new SqlConnection("Server=.;Database=master;User ID=sa;Password=;");
SqlCommand sqlcom = new SqlCommand();
sqlcom.CommandType = CommandType.Text;
sqlcom.Connection = conn;
sqlcom.CommandText = @"backup database Archives to disk='D:\ba' with init";
try
{
conn.Open();
sqlcom.ExecuteNonQuery();
MessageBox.Show("备份成功！！！");
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
conn.Dispose();
}
}
///
///还原方法
///
private void button2_Click(object sender, System.EventArgs e)
{
SqlConnection conn = new SqlConnection("Server=.;Database=master;User ID=sa;Password=;Trusted_Connection=
private void button1_Click(object sender, System.EventArgs e)
{
///
///备份方法
///
SqlConnection conn = new SqlConnection("Server=.;Database=master;User ID=sa;Password=;"); //定义Connection连接对象
SqlCommand sqlcom = new SqlCommand();
sqlcom.CommandType = CommandType.Text; //定义CommandType格式
sqlcom.Connection = conn; //Connection连接对象绑定
sqlcom.CommandText = @"backup database Archives to disk='D:\ba' with init"; //此句是备份数据库语句,格式:backup database 数据库名 to disk='路径'
try //try 语名,如果try里面执行错误,则执得后面的catch语句
{
conn.Open(); //打开连接
sqlcom.ExecuteNonQuery();//执行SQL命令,正确执行则继续执行下一句,错误则跳出,执行catch语句
MessageBox.Show("备份成功！！！"); //弹出对话框
}
catch(Exception ex)//抛出错误执行,Exception 为异常类,即只要发生错误,程序就会抛出个Exception给catch执行
{
MessageBox.Show(ex.Message); //弹出对话框
}
finally //如try里面出错则不执行这一句.try执行成功则执行
{
conn.Close(); //关闭连接
conn.Dispose(); //释放出内存空间<