net操作access數據庫示例分享

 這篇文章主要介紹了net操作access數據庫示例,需要的朋友可以參考下

 代碼如下: using System; using System.Data; using System.Configuration; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.OleDb;   /// <summary> ///AccessDB 的摘要說明 /// </summary> public class AccessDB {     public AccessDB()     {         //TODO: 在此處添加構造函數邏輯     }       /// <summary>     /// 讀取Access數據庫     /// </summary>     private void ReadAccessData()     {         //1、建立連接         string sAccessConnection = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Documents and SettingsAdministrator.WWW-410ADC78208桌面應用程序.mdb";         OleDbConnection odcConnection = new OleDbConnection(sAccessConnection);         //2、打開連接         odcConnection.Open();         //建立SQL查詢         OleDbCommand odCommand = odcConnection.CreateCommand();         //3、輸入查詢語句         odCommand.CommandText = "SELECT table.編號, table.[123], table.[456] FROM [table];";         //建立讀取         OleDbDataReader odrReader = odCommand.ExecuteReader();         //查詢並顯示數據         while (odrReader.Read())         {             ListViewItem item = new ListViewItem();             item.SubItems.Add(odrReader[0].ToString());             item.SubItems.Add(odrReader[1].ToString());             item.SubItems.Add(odrReader[2].ToString());             this.listView1.Items.Add(item);         }         //關閉連接         odrReader.Close();         odcConnection.Close();     }     /// <summary>     /// add     /// </summary>     /// <param name="sender"></param>     /// <param name="e"></param>     private void button1_Click(object sender, EventArgs e)     {         //1、建立連接         string sAccessConnection = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Documents and SettingsAdministrator.WWW-410ADC78208桌面應用程序.mdb";         OleDbConnection odcConnection = new OleDbConnection(sAccessConnection);         //2、打開連接         odcConnection.Open();         //建立SQL查詢         OleDbCommand odCommand = odcConnection.CreateCommand();         //3、輸入查詢語句         odCommand.CommandText = "INSERT INTO [table]([123],[456]) VALUES('88','88' )";         //執行         odCommand.ExecuteNonQuery();         //關閉連接         odcConnection.Close();         this.listView1.Items.Clear();         ReadAccessData();     }       /// <summary>     /// delete     /// </summary>     /// <param name="sender"></param>     /// <param name="e"></param>     private void button3_Click(object sender, EventArgs e)     {         //1、建立連接         string sAccessConnection = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Documents and SettingsAdministrator.WWW-410ADC78208桌面應用程序.mdb";         OleDbConnection odcConnection = new OleDbConnection(sAccessConnection);         //2、打開連接         odcConnection.Open();         //建立SQL查詢         OleDbCommand odCommand = odcConnection.CreateCommand();         //3、輸入查詢語句         string sql = "DELETE table.編號 FROM [table] WHERE (((table.編號)=" + this.listView1.SelectedItems[0].SubItems[1].Text + "))";         odCommand.CommandText = sql;         //執行         odCommand.ExecuteNonQuery();         //關閉連接         odcConnection.Close();         this.listView1.Items.Clear();         ReadAccessData();     }       /// <summary>     /// update     /// </summary>     /// <param name="sender"></param>     /// <param name="e"></param>     private void button2_Click(object sender, EventArgs e)     {         //1、建立連接         string sAccessConnection = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Documents and SettingsAdministrator.WWW-410ADC78208桌面應用程序.mdb";         OleDbConnection odcConnection = new OleDbConnection(sAccessConnection);         //2、打開連接         odcConnection.Open();         //建立SQL查詢         OleDbCommand odCommand = odcConnection.CreateCommand();         //3、輸入查詢語句         string sql = "UPDATE [table] SET 123='11',456='11'  WHERE (((table.編號)=" + this.listView1.SelectedItems[0].SubItems[1].Text + "))";         odCommand.CommandText = sql;         //執行         odCommand.ExecuteNonQuery();         //關閉連接         odcConnection.Close();         this.listView1.Items.Clear();         ReadAccessData();     } }