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

posted @ 2013-04-20 20:18  侯伟东  阅读(385)  评论(0编辑  收藏  举报