VC 修改SQL中的数据

 UpdateData(TRUE);  if (m_no.IsEmpty() || m_sex == -1 || m_name.IsEmpty() || m_id.IsEmpty())  {   MessageBox("×¢Ò⣺´ò*ºÅµÄ±ØÐëÌîдÍêÕû","¾¯¸æ!",MB_ICONSTOP | MB_OK);   return;  }  if (strcmp(m_pwd,m_pwdagain) != 0)  {   MessageBox("ÄúÁ½´ÎÊäÈëµÄÃÜÂë²»Ïàͬ£¬ÇëÖØÐÂÊäÈë!!","¾¯¸æ!",MB_ICONSTOP | MB_OK);   return;  }    if (m_R->State ==  adStateOpen)   m_R->Close();  CString sql;  CString isex;  _variant_t vFieldName;  _variant_t vFieldValue;     sql = "select * from serverloadtbl where serverno = '";  sql += strServerNo + "'";    //MessageBox(sql);  m_R->Open(_variant_t(sql),m_P.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText);  vFieldName.SetString("ServerPwd");  vFieldValue.SetString(m_pwd);  m_R->Update(vFieldName,vFieldValue);  vFieldName.Clear();  vFieldValue.Clear();

 vFieldName.SetString("ServerName");  vFieldValue.SetString(m_name);  m_R->Update(vFieldName,vFieldValue);  vFieldName.Clear();  vFieldValue.Clear();    vFieldName.SetString("ServerSex");  if(m_sex == 0)   vFieldValue.SetString("men");  else   vFieldValue.SetString("women");

 m_R->Update(vFieldName,vFieldValue);  vFieldName.Clear();  vFieldValue.Clear();

 vFieldName.SetString("ServerAge");    if (m_age == "")   m_age = "0";     vFieldValue.SetString(m_age);  m_R->Update(vFieldName,vFieldValue);  vFieldName.Clear();  vFieldValue.Clear();

 vFieldName.SetString("ServerID");  vFieldValue.SetString(m_id);  m_R->Update(vFieldName,vFieldValue);  vFieldName.Clear();  vFieldValue.Clear();  m_R->Close();  MessageBox("¹§Ï²Ä㣬Ð޸ijɹ¦!!","Ìáʾ¿ò!",MB_ICONINFORMATION | MB_OK);

 EndDialog(1);//·µ»Ø´úÂë