OleDbConnection con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=access1.accdb");
string sql = "select * from plant";
OleDbDataAdapter ad = new OleDbDataAdapter(sql, con);
OleDbCommandBuilder cmd = new OleDbCommandBuilder(ad);
DataSet ds = new DataSet();
ds.Tables.Clear();
con.Open();
ad.Fill(ds);
ad.Update(ds);
con.Close();
ds.Clear();
ad.Dispose();
cmd.Dispose();
dataGridView1.Update(); dataGridView1.DataSource = ds.Tables[0];access数据库就是不更新,谢谢~~
string sql = "select * from plant";
OleDbDataAdapter ad = new OleDbDataAdapter(sql, con);
OleDbCommandBuilder cmd = new OleDbCommandBuilder(ad);
DataSet ds = new DataSet();
ds.Tables.Clear();
con.Open();
ad.Fill(ds);
ad.Update(ds);
con.Close();
ds.Clear();
ad.Dispose();
cmd.Dispose();
dataGridView1.Update(); dataGridView1.DataSource = ds.Tables[0];access数据库就是不更新,谢谢~~
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货