C#操作Access的查詢、添加、刪除、修改源程序

1、using System;using ;using ;using ;using ;using ;using Locationpublic partial class Form1 : Formpublic Form1()InitializeComponent();private void Form1_Load( object sender, EventArgs e)"Location System" " 連接數(shù)據(jù)庫(kù) "" 查詢 "" 退出 "" 添加 "" 刪除 ""

2、 修改 ""ID ： " "0"private void button1_Click( object sender, EventArgs e)string ConStr = "Provider= source=" ;ext);OleDbComman dcmd = new OleDbComman(d"Select * From data where ID>=id" con);"id" ,i);OleDbDataReader reader = ();();oString();= re

3、ader1.ToString();= reader2.ToString();= reader3.ToString();= reader4.ToString();= reader5.ToString();= reader6.ToString();();();private void button4_Click( object sender, EventArgs e) / 添加 string ConStr = "Provider= source=" ; / 創(chuàng)建 OleDbConnection 對(duì)象 OleDbConnection con = new OleDbConnecti

4、on (ConStr);();for ( int i = 0; i < 1000; i+)string sql = "insert into data(ID)values(" + i + ")" ; OleDbComman dcmd = new OleDbComman(dsql, con);();();private void button5_Click( object sender, EventArgs e)string ConStr = "Provider= source=" ; / 創(chuàng)建 OleDbConnection 對(duì)

5、象OleDbConnection con = new OleDbConnection (ConStr); ();OleDbComman dcmd = new OleDbComman(d"delete from data" , con); ();private void button6_Click( object sender, EventArgs e)string ConStr = "Provider= source=" ; / 創(chuàng)建 OleDbConnection 對(duì)象OleDbConnection con = new OleDbConnection (ConStr); ();string sql = "update data set longit