微软专家和高手们求救:使用OleDbCommandBuilder更新da.update(dt)oracle 9.12数据库操作失败。
pbfan 2005-01-27 10:54:30 OleDbConnection Connection = GetConnection(pub_int_conindes);
OleDbDataAdapter da = new OleDbDataAdapter(dataTable.ExtendedProperties["SelectStatement"].ToString(), Connection);
OleDbCommandBuilder CommandBuilder = new OleDbCommandBuilder(da);
da.Update(dataTable);//here error
插入和删除都可以,就是更新不行。(数据表已经设置了主键)
错误提示:Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information
thanks