求ACCESS备份与还原的源码最好有实例

Question

RT。

Answer 1

数据备份if (folderBrowserDialog1.ShowDialog(this) == DialogResult.OK)
            {
                try
                {
                    File.Copy(AppDomain.CurrentDomain.BaseDirectory.ToString() + "eluo.accdb", folderBrowserDialog1.SelectedPath + "\\" + DateTime.Now.ToString("yyyy-MM-dd") + "备份.accdb", true);
                    MessageBox.Show("备份成功", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
                catch
                {
                    MessageBox.Show("备份失败,请关闭所有子窗体,以保证源数据库不被程序占用", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }数据恢复openFileDialog1.Multiselect = false;
            openFileDialog1.FileName = "";
            openFileDialog1.Filter = "数据库文件(*.accdb)|*.accdb|所有文件(*.*)|*.*";
            if (DialogResult.OK == openFileDialog1.ShowDialog(this))
            {
                try
                {
                    File.Copy(openFileDialog1.FileName, AppDomain.CurrentDomain.BaseDirectory.ToString() + "eluo.accdb", true);
                    MessageBox.Show("还原成功", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
                catch
                {
                    MessageBox.Show("还原数据库失败,请关闭所有子窗体,以保证当前数据库不被程序占用", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }