【DataSet更新到数据库的问题】

[boyxia]

myConn = new OleDbConnection(connStr_MSDAORA);
myDataAdapter = new OleDbDataAdapter();
myDataAdapter.DeleteCommand = new OleDbCommand("DELETE FROM XT_QX_ZZ_TB WHERE (QX_ZZ_BM = @QX_ZZ_BM)",myConn);
myDataAdapter.DeleteCommand.Parameters.Add("@QX_ZZ_BM", OleDbType.Double, 5472, "QX_ZZ_BM");
myDataAdapter.Update(myDataSet.Tables[0].GetChanges());

为什么执行的时候老是提示缺少表达式？

[boyxia]

myConn = new OleDbConnection(connStr_MSDAORA);
myDataAdapter = new OleDbDataAdapter();
myDataAdapter.DeleteCommand = new OleDbCommand("DELETE FROM XT_QX_ZZ_TB WHERE (QX_ZZ_BM = @QX_ZZ_BM)",myConn);
myDataAdapter.DeleteCommand.Parameters.Add("@QX_ZZ_BM", OleDbType.Double, 5472, "QX_ZZ_BM");
myDataAdapter.Update(myDataSet.Tables[0].GetChanges());

为什么执行的时候老是提示缺少表达式？

[boyxia]

myConn = new OleDbConnection(connStr_MSDAORA);
myDataAdapter = new OleDbDataAdapter();
myDataAdapter.DeleteCommand = new OleDbCommand("DELETE FROM XT_QX_ZZ_TB WHERE (QX_ZZ_BM = ?)",myConn);//改成问号就行了
myDataAdapter.DeleteCommand.Parameters.Add("@QX_ZZ_BM", OleDbType.Double, 5472, "QX_ZZ_BM");
myDataAdapter.Update(myDataSet.Tables[0].GetChanges());

散分

[suosuoyyy]

仅仅给DeleteCommand赋值是不够的，
string sqlStr = "Select * From " + tabName;
SqlDataAdapter DataAdapter = new SqlDataAdapter(sqlStr,Connection);
SqlCommandBuilder CommandBuilder = new SqlCommandBuilder(DataAdapter);
//这里重新设置你的DeleteCommand
DataAdapter.DeleteCommand.CommandText = ...;
DataAdapter.DeleteCommand.Parameters.Add("@QX_ZZ_BM",,);
DataAdapter.DeleteCommand.Parameters[("@QX_ZZ_BM"].Value = ...; //需要给参数赋值

DataAdapter.Update(dataSet,tabName);