OleDbDataAdpter的update报错:insert 语句语法出错
sql = "select * from line order by id";
myCommand = new OleDbCommand(sql,conn);
myAd.SelectCommand = myCommand;
lineCb = new OleDbCommandBuilder(myAd);
myAd.Fill(dataSet1,"line");
sql = lineCb.GetInsertCommand().CommandText.ToString();
dataGrid1.SetDataBinding(dataSet1,"line");
最后在执行myAd.update(dataSet1,"line")时说insert 语句语法出错(在update(DataRows[],MappingName)中)
请问这一般是什么原因啊??我在程序中其他地方也用到一样的语句,但是就没有任何问题