100分,求一个C#操作ACCESS的例子,不散分!

Question

如果您有的话,请发到[email protected],马上就结帖.

Answer 1

http://www.c-sharpcorner.com/1/insert_query.asp
http://www.c-sharpcorner.com/FAQ/AddRecordsWithSP.asp

Answer 2

DataSet ds=new DataSet();
System.Data.OleDb.OleDbConnection conn=new System.Data.OleDb.OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source ='c:\db.mdb'");
System.Data.OleDb.OleDbDataAdapter da=new System.Data.OleDb.OleDbDataAdapter("Select * from Table1",conn);
System.Data.OleDb.OleDbCommandBuilder cb=new System.Data.OleDb.OleDbCommandBuilder(da);
da.Fill(ds);
this.listBox1.DataSource=ds.Tables[0];
this.listBox1.DisplayMember="test";
DataRow dr=ds.Tables[0].NewRow();
dr["test"]="Hello world";
ds.Tables[0].Rows.Add(dr);
da.Update(ds);