网站中access数据库的备份和恢复

protected void Page_Load(object sender, EventArgs e)
   {
       if (!IsPostBack)
       {
           TextBox1.Text = "请输入备份文件名称";
           this.DataBindList();
       }
   }
   protected void Button1_Click(object sender, EventArgs e)
   {
       if (!File.Exists(Server.MapPath(@"~\bakDataBase\" + TextBox1.Text)))
       {
           File.Copy(Server.MapPath(@"~\App_Data\2013dengtong.mdb"), Server.MapPath(@"~\bakDataBase\" + TextBox1.Text+".mdb"));
           this.DataBindList();
           Response.Write("数据备份成功！");
       }
       else
       {
           Response.Write("备份文件已经存在，请重新命名！！！");
       }
   }
   protected void Button2_Click(object sender, EventArgs e)
   {
       File.Copy(Server.MapPath(@"~\bakDataBase\" + DropDownList1.SelectedItem.Text), Server.MapPath(@"~\App_Data\2013dengtong.mdb"), true);
       Response.Write("数据恢复成功！");
   }

   public void DataBindList()
   {
       DropDownList1.Items.Clear();
       DataTable dt = new DataTable();
       dt.Columns.Add(new DataColumn("fileName", typeof(string)));
       DirectoryInfo dir = new DirectoryInfo(Server.MapPath(@"~\bakDataBase\"));
       foreach (FileInfo file in dir.GetFiles())
       {
           DataRow dr = dt.NewRow();
           dr[0] = file;
           dt.Rows.Add(dr);
       }
       DropDownList1.DataSource = dt;
       DropDownList1.DataTextField = "fileName";
       DropDownList1.DataBind();
   }

转载于:https://www.cnblogs.com/houweidong/archive/2013/04/20/3033040.html