string DBPath = System.IO.Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "dbvoter.mdb");
string connstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + DBPath + "";
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = connstr;
conn.Open();
sda = new OleDbDataAdapter("select * from [voter]", conn);
OleDbCommandBuilder commbuider = new OleDbCommandBuilder(sda);
sda.UpdateCommand = commbuider.GetUpdateCommand();
dt = new DataTable();
sda.AcceptChangesDuringUpdate = true;
sda.Fill(dt);
读取显示没问题,在用sda.Update(dt);更新时提示更新语句有语法错误
sda = new OleDbDataAdapter("select * from [voter]", conn);
OleDbCommandBuilder commbuider = new OleDbCommandBuilder(sda);
dt = new DataTable();
sda.Fill(dt);
//修改dt
sda.Update(dt);