1、出错源码如下:
private void UpdateData(string oldname, string olddepartment, string newname, string newdepartment)
{
string sqlstr = "select name,department from TransTest where name='" + oldname + "' and department='" + olddepartment + "'";
DataSet ds = new DataSet();
OleDbDataAdapter dataAdapter = new OleDbDataAdapter(sqlstr, _DBConn);
//若不启用事务,则屏蔽此行
dataAdapter.SelectCommand.Transaction = _DBTrans;
OleDbCommandBuilder cb = new OleDbCommandBuilder(dataAdapter);
dataAdapter.Fill(ds, "TransTest");
DataTable table = ds.Tables[0];
DataRow currRow = table.Rows[0];
currRow["name"] = newname;
currRow["department"] = newdepartment;
dataAdapter.Update(table.GetChanges());
table.AcceptChanges();
}
2、原因分析:
用UpdateCommand命令更新数据库时,必须要有pk属性,否则无法构造动态sql语句。
用如上sqlstr定义,未将表单TransTest对应pk属性取到datatable中,从而也导致了否则无法构造动态sql语句。
3、结论
要使用dataAdapter.Update命令来更新数据库表结构,要求两点:1、此表必须具有pk属性,1:所获取的datatable中也不惜包含了pk属性值。
4、修改方法:
string sqlstr = "select id,name,department from TransTest where name='" + oldname + "' and department='" + olddepartment + "'";