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