VC ADO²Ù×÷SQLSERVERÊý¾Ý¿âµÄһЩÎÊÌâ

ÎÒ´òËãÔÚÊý¾Ý±íÖвåÈëÒ»Ìõ¼Ç¼,´úÂëÈçÏÂ:
try
{
m_pRecordset->MoveFirst();
}
catch(_com_error e)
{
CString errormessage;
errormessage.Format("\r\n%s",e.ErrorMessage());
AfxMessageBox(errormessage);//
}


try
{
m_pRecordset->AddNew();
m_pRecordset->PutCollect("̞",(_variant_t)m_user);
m_pRecordset->PutCollect("ÃÜÂë",(_variant_t)m_passwd);
m_pRecordset->PutCollect("ÐÕÃû",(_variant_t)m_name);
m_pRecordset->PutCollect("µç»°",(_variant_t)m_phone);
m_pRecordset->Update();
}
catch(_com_error e)
{
AfxMessageBox(e.ErrorMessage());
}

ÔËÐÐʱ,Á¬Ðøµ¯³öÁ½¸öͬÑùµÄ¶Ô»°¿ò,ÄÚÈݶ¼ÊÇ"ÎÞЧָÕë",ÇëÎʵÚÒ»¸öÎÞЧָÕëÐÅÏ¢³öÏÖµÄÔ­ÒòÊÇʲô?µÚ¶þ¸öÎÞЧָÕëÐÅÏ¢³öÏÖµÄÔ­ÒòÊÇʲô?

---

m_pRecordsetÇ°ÃæûÓÐCloseµô°É£¿

---

²Î¿¼ÏÂ
C/C++ code:

·½·¨Ò»£¨²»´ø²ÎÊý£©£º

// Add new record into this table:
try
{
if(!m_pRecordset->Supports(adAddNew)) return;
m_pRecordset->AddNew();
m_pRecordset->Fields->GetItem(_variant_t("ÐÕÃû"))->Value=_bstr_t("ÕÔÞ±");
m_pRecordset->Fields->GetItem(_variant_t("ÐÔ±ð"))->V