private void ok_Click(object sender, EventArgs e)//备份
{
if (this.filename.Text.Trim() != "")
{
SqlConnection connect = InitConnect.GetConnection();
connect.Open();
SqlCommand cmd = new SqlCommand("backup database " + InitConnect.GetDatabaseName() + " to disk='" + this.filename.Text.Trim() + "' with init", connect);
try
{
cmd.ExecuteNonQuery();
MessageBox.Show("您成功备份了数据库！", "恭喜", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1);
this.Close();
}
catch (Exception ee)
{
MessageBox.Show("备份失败！\n错误信息：" + ee.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
}
finally
{
connect.Close();
}
}
else
{
MessageBox.Show("请输入正确的路径及备份文件名称！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1);
}
}
private void ok_Click(object sender, EventArgs e)//还原数据库
{
this.UseOtherDatabase();
/////////////////////////////////
SqlConnection connect = new SqlConnection("Server=" + InitConnect.GetServer() + ";Database=master;User ID=" + InitConnect.GetUser() + ";Password="******"restore database " + InitConnect.GetDatabaseName() + " from disk='" + this.filename.Text.Trim() + "' with replace", connect);
cmd.ExecuteNonQuery();
MessageBox.Show("成功还原数据库\"" + InitConnect.GetDatabaseName() + "\"！", "恭喜", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1);
this.Close();
}
catch (Exception ee)
{
MessageBox.Show("还原数据库\"" + InitConnect.GetDatabaseName() + "\"失败！\n错误信息：" + ee.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
}
finally
{
connect.Close();
}
}
