| 标题 | 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(); } } |
| 随便看 |
|
在线学习网考试资料包含高考、自考、专升本考试、人事考试、公务员考试、大学生村官考试、特岗教师招聘考试、事业单位招聘考试、企业人才招聘、银行招聘、教师招聘、农村信用社招聘、各类资格证书考试等各类考试资料。