asp.net online backup, compression, and Repair Access database sample code

This article mainly describes how to asp.net online backup, compression and repair of Access database, the need for friends can refer to the next 1. Question     When designing small and medium Web applications, you can choose Microsoft Accesss as a database. Frequent additions and deletions are made during the use of the database. In fact, Microsoft Access does not effectively release allocated but deleted object space, which means that even if you delete an object, the object still occupies the space of the database, making the database bigger and larger. Not only occupy unnecessary space, but also reduce the efficiency of the database. Especially in the virtual site of the problem is particularly prominent. Therefore, compressing the Access database is of practical significance.   Although the Access database itself has the "Compress and Repair Database" feature (tool è database utility è compression and repair database). However, it is inconvenient for the general user to operate. Usually the ACCESSS database is placed on the virtual host, need to download it down "compression repair" and then pass up a waste of time, so it is best to compress the database online.     2. The implementation of online compression database     2.1. Add reference to     Add a reference under the Vs.net environment solution. The methods are as follows: Items → add references → tabs → browse (C:/Program files/comm files/system/ado/msjro.dll).     2.2. Create a Web application form     Place a button on a Web Form (database.aspx):  code as follows: <asp:button id= "COMPACTBTN" runat= "Server" text= "Compress Database" onclick= "Compactbtn_click"/>  Add a Label control:  <asp:label id= "Msglabel" runat= "Server" ></asp:Label>    2.3. In code state, add a reference   code as follows: using system;  using System.IO;   using jro;    2.4. Add code     code as follows://Compressed database   protected VOID Compactbtn_click (object sender, EventArgs e)   {  string DbPath1, DbPath2, DbConn1, dbconn2;    DBPA Th1 = Server.MapPath (".. /app_data/database.mdb ")//Original database path   DBPATH2 = Server.MapPath (". /app_data/database2.mdb ")//Compressed database path   DBCONN1 =" Provider=Microsoft.Jet.OLEDB.4.0;Data source= "+ DbPath1;   DBCONN2 = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=" + dbpath2;    try  {  jetengine Data Baseengin = new JetEngine ();  databaseengin.compactdatabase (DbConn1, DBCONN2);//compression     File.Copy ( DbPath2, DbPath1, true);//The compressed database is overwritten with the original database   File.delete (DBPATH2);//Delete compressed database     Msglabel.text = "database compression succeeded !";  }  catch  {  msglabel.text = "Database compression failed, please try again!";  } }    3. Backup DATABASE     3.1. Create a Web application form     Place a button on a Web Form (database2.aspx):  & The code is as follows: <asp:button id= "backupbtn" runat= "Server" text= "Backup Database" onclick= "Backupbtn_click"/>  Add a Label control:  <asp:lAbel id= "Msglabel" runat= "Server" ></asp:Label>    3.2. In the code state, add a reference     code as follows: using System;   using system.io;    3.3. Add code     code as follows://BACKUP database   protected void Backupbtn_click (object sender, EventArgs e)   {  string DbPath1, DbPath2, dbname4dbpath2;    dbname4dbpath2 = DateTime.Now.To String (). Replace (":", ".");   DBPATH1 = Server.MapPath (".. /app_data/database.mdb ");  DbPath2 = Server.MapPath (".. /app_data/"+ dbname4dbpath2 +". mdb ");    try  {  file.copy (DbPath1, DbPath2, True);    MSG Label.text = "Database backup succeeded to" + Dbname4dbpath2 + ". mdb!";  }  catch  {  msglabel.text = "Database backup failed, please try again!";   Msglabel.cssclass = "Redcolor"; } }    4. Summary     Compressed so that Microsoft Access really frees up the extra space it occupies, The database is minimized to ensure it runs most efficiently. Therefore, during the design process, it is important not to overlook the importance of compressing Microsoft Access.   recommend that you back up the database before compressing it.