HELP::急~并发冲突:UpdateCommand 影响 0 个记录 ~~
q_m 2004-11-08 10:15:45 代码如下:
OleDbDataAdapter da = new OleDbDataAdapter("SelectUser",con);
da.SelectCommand.ComandType = CommandType.StoredProcedure;
da.SelectCommand.Parameters.Add(new OleDbParameter(" @UserName ",OleDbType.VarChar,20,"UserName"));
da.SelectCommand.Parameters[" @UserName "].Value = "testuser";
DataSet ds = new DataSet();
da.Fill(ds,"SignOn");
OleDbCommand updateCommand = new OleDbCommad("UpdateUser",con);
updateCommand.CommandType = CommandType.StoredProcedure;
OleDbParameter workRow = new OleDbParameter(" @UserName ",OleDbType.VarChar,20,"UserName");
workRow.SourceVersion = DataRowVersion.Original;
updateCommand.Parameters.Add(workRow);
updateCommand.Parameters.Add(new OleDbParameter(" @Password ",OleDbType.VarChar,20,"Password"));
da.UpdateCommand = updateCommand;
DataRow row = ds.Tables["SignOn"].Rows[0];
row["Password"] = "new password";
da.update(ds,"SignOn");
如果将其中任何一个存储过程直接用SQL语句就不会出现并发冲突??为什么啊~~请各位大侠帮忙解决~~