OleDbCommandBuilder 更新数据库出现错误
错在哪里,代码应该怎么写呢?
//去除重复
public void delCHongFu()
{
string del = "select * from Abiao where id in (select min(id) from Abiao group by topic)"; //查询topic单一的数据(去掉重复)
//将查询结果放入内存表
OleDbDataAdapter oda = new OleDbDataAdapter(del, acc.getCon());
DataSet ds = new DataSet();
oda.Fill(ds, "danyi");
DataTable dt = ds.Tables["danyi"];
//删除表
acc.qingkong("Abiao"); //删除数据库中Abiao的数据
//将内存中的表数据添加到数据表中
OleDbCommandBuilder cb = new OleDbCommandBuilder(oda);
oda.Update(ds, "danyi");
System.Windows.Forms.MessageBox.Show("已去除重复的行");
}