110,533
社区成员
发帖
与我相关
我的任务
分享
string strConnection = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=data.accdb";
OleDbConnection objConnection = new OleDbConnection(strConnection);
string sql = "select * from sk";
OleDbDataAdapter adapter = new OleDbDataAdapter(sql, strConnection);
OleDbCommandBuilder bld = new OleDbCommandBuilder(adapter);
adapter.UpdateCommand = bld.GetUpdateCommand();
DataTable dt = new DataTable();
adapter.Fill(dt);
dt.Rows[i].Delete();
dt.AcceptChanges();
adapter.Update(dt);