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(); } }