Question

怎样用C#代码实现Acess数据库备份和恢复？

我在用C#做毕业设计 ，想请问一下：怎样用C#代码实现Acess数据库备份和恢复？
我在网上没找到合适的。时间紧急，先谢谢各位的帮助了！

Answer 1

FileInfo file = new FileInfo(Application.StartupPath + @"\mydb.mdb");
SaveFileDialog saveFileDialog1 = new SaveFileDialog();
saveFileDialog1.DefaultExt = "mdb";
saveFileDialog1.FileName = "mydb";
saveFileDialog1.Title = "数据库文件备份";
saveFileDialog1.Filter = "Access files(*.mdb)|*.mdb";
saveFileDialog1.InitialDirectory = @"c:\";
saveFileDialog1.OverwritePrompt = true;
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
file.CopyTo(saveFileDialog1.FileName, true);
MessageBox.Show("数据库备份成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("找不到数据库文件，备份失败！", "警告", MessageBoxButtons.OK, MessageBoxIcon.Error);
}

2. OpenFileDialog MyDlg = new OpenFileDialog();
MyDlg.Title = "数据库文件还原";
MyDlg.Filter = "Access files(*.mdb)|*.mdb";
MyDlg.DefaultExt ="mdb";
MyDlg.FileName ="mydb";
MyDlg.InitialDirectory =@"c:\";
if (MyDlg.ShowDialog() == DialogResult.OK)
{
if (MessageBox.Show("此操作将会把原来的数据覆盖,是否继续？", "警告", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
FileInfo file = new FileInfo(MyDlg.FileName);
file.CopyTo(Application.StartupPath + @"\mydb.mdb", true);
MessageBox.Show("数据库还原成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}

Answer 2

引用Microsoft ActiveX data Objects 2.5 Library
Dim fso As New FileSystemObject
Dim a As File
Set a = fso.GetFile(App.Path & "\Note.mdb") '被备份的文件()
a.Copy ("E:\dds\Note Copy.mdb") '备份去的新文件
Set a = Nothing
Set fso = Nothing '释放对象

Answer 3

using System.IO;
//...最简单的一个例子
protected void Button1_Click()
{
File.Copy("C:\WINDOWS\system32\cmd.exe", "D:\a.txt") '把cmd程序复制到D盘下,名称为a.txt
}
//...