在执行update时出错.
-----------------------------------------
未处理的“System.InvalidOperationException”类型的异常出现在 system.data.dll 中。其他信息: 当传递具有已修改行的 DataRow 集合时,更新要求有效的 UpdateCommand。
------------------------------------------以下是代码:
string cmdSelectString = "select tblUserMail.ID,tblUserMail.toid,tblUserMail.MailTo,tblUserMail.BodyText,tblUserMail.Flag,tblUserMail.CreateDay,tblUser.name, tblUserMail.replytime from tblUserMail,tblUser where tblUserMail.toid = tblUser.id and tblUserMail.Flag= 1";
m_cnn.Open();
SqlCommand cmd = new SqlCommand(cmdSelectString,m_cnn); SqlDataAdapter emailAdapter = new SqlDataAdapter();
emailAdapter.SelectCommand=cmd; DataSet emailSet = new DataSet(); int icountRow; icountRow = emailAdapter.Fill(emailSet,"UserMail");
                
foreach(DataRow dr in emailSet.Tables["UserMail"].Rows)
{
string strID;
string strMailTo;
string strCreateDay; 
string strSendUserName;//要发送的游戏中的用户名
string strSendPassword;//对应的密码
// strID           = dr[0].ToString();//emailRow[0].ToString();
strSendTo       = dr[2].ToString();
strSendPassword = dr[3].ToString(); strCreateDay    = dr[5].ToString();
strSendUserName = dr[6].ToString();
int iRtn2;
iRtn2 = SendEmail(strSubject,strBodyText,strMailServer,strUserName,strPassword,strFrom,strSendTo);

if (iRtn2 == 1) //发送成功
{
string strDateTime;
DateTime dtNow = DateTime.Now;
strDateTime = dtNow.ToString();
                    
dr[7] = strDateTime;
dr[4] = 2;
} } emailAdapter.Update(emailSet,"UserMail");