数据库备份

来源：互联网发布：跑鞋矩阵2017 编辑：程序博客网时间：2024/05/16 15:22

以前，只见别人做过数据库备份。自己也试着做了，没有想到一次成功！借此想把它拿出来。供以后参考。

说明：不包含窗体。

public string srcpath = Environment.CurrentDirectory + "//db//zulin.mdb"; //选择数据库 private void button4_Click(object sender, EventArgs e) { openFileDialog1.ShowDialog(); textBox2.Text = openFileDialog1.FileName.ToString(); } //选择目录备份 private void button1_Click(object sender, EventArgs e) { folderBrowserDialog1.ShowDialog(); textBox1.Text = folderBrowserDialog1.SelectedPath.ToString() + "//bak" + DateTime.Now.ToShortDateString() + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString() + ".mdb"; } //开始备份 private void button2_Click(object sender, EventArgs e) { string despath = textBox1.Text.Trim(); if (despath == string.Empty) { MessageBox.Show("请选择数据库备份位置！", "消息提示：", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } Backup(srcpath, despath);//调用备份的方法 } // 开始备份的方法 public static void Backup(string srcPath, string aimPath) { if (!File.Exists(srcPath)) { throw new Exception("源数据库不存在,无法备份"); } try { File.Copy(srcPath, aimPath, true); MessageBox.Show("备份数据库成功！", "消息提示：", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (IOException ixp) { throw new Exception(ixp.ToString()); } } //开始还原 private void button3_Click(object sender, EventArgs e) { string bakpath = textBox2.Text.Trim(); string despath = System.Windows.Forms.Application.StartupPath + "//db//zulin.mdb"; if (bakpath == string.Empty) { MessageBox.Show("请选择数据库位置！", "消息提示：", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } RecoverAccess(bakpath, despath); } public static void RecoverAccess(string bakPath, string dbPath) { if (!File.Exists(bakPath)) { throw new Exception("备份数据库不存在,无法还原"); } try { File.Copy(bakPath, dbPath, true); MessageBox.Show("还原数据库成功！", "消息提示：", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (IOException ixp) { throw new Exception(ixp.ToString()); } } public string srcpath = Environment.CurrentDirectory + "//db//zulin.mdb"; //选择数据库 private void button4_Click(object sender, EventArgs e) { openFileDialog1.ShowDialog(); textBox2.Text = openFileDialog1.FileName.ToString(); } //选择目录备份 private void button1_Click(object sender, EventArgs e) { folderBrowserDialog1.ShowDialog(); textBox1.Text = folderBrowserDialog1.SelectedPath.ToString() + "//bak" + DateTime.Now.ToShortDateString() + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString() + ".mdb"; } //开始备份 private void button2_Click(object sender, EventArgs e) { string despath = textBox1.Text.Trim(); if (despath == string.Empty) { MessageBox.Show("请选择数据库备份位置！", "消息提示：", MessageBoxButtons.OK, MessageBoxIcon.Error); return public string srcpath = Environment.CurrentDirectory + "//db//zulin.mdb"; //选择数据库 private void button4_Click(object sender, EventArgs e) { openFileDialog1.ShowDialog(); textBox2.Text = openFileDialog1.FileName.ToString(); } //选择目录备份 private void button1_Click(object sender, EventArgs e) { folderBrowserDialog1.ShowDialog(); textBox1.Text = folderBrowserDialog1.SelectedPath.ToString() + "//bak" + DateTime.Now.ToShortDateString() + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString() + ".mdb"; } //开始备份 private void button2_Click(object sender, EventArgs e) { string despath = textBox1.Text.Trim(); if (despath == string.Empty) { MessageBox.Show("请选择数据库备份位置！", "消息提示：", MessageBoxButtons.OK, MessageBoxIcon.Error); return