這篇文章主要介紹了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(); } }
