| 标题 | 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(); } } |
| 随便看 |
|
在线学习网范文大全提供好词好句、学习总结、工作总结、演讲稿等写作素材及范文模板，是学习及工作的有利工具。