代码如下:
try
{
m_pRecordset->AddNew();//添加新行
m_pRecordset->PutCollect("name",(_bstr_t)stname);
m_pRecordset->PutCollect("sex",(_bstr_t)stsex);
m_pRecordset->PutCollect("grade",(_bstr_t)stgrad);
m_pRecordset->PutCollect("class",(_bstr_t)stclas);
m_pRecordset->Update();
m_AdoConn.ExitConnect();
/*m_pRecordset->GetFields()->GetItem("name")->Value =(_bstr_t)stname;
m_pRecordset->GetFields()->GetItem("sex")->Value =(_bstr_t)stsex;
m_pRecordset->GetFields()->GetItem("class")->Value =(_bstr_t)stgrad;
m_pRecordset->GetFields()->GetItem("grade")->Value =(_bstr_t)stclas;
m_AdoConn.ExitConnect();*/
}
catch(...)
{
MessageBox("操作失败");
return;
以上操作中m_pRecordset->AddNew();//添加新行、m_pRecordset->Update();m_AdoConn.ExitConnect();均不可缺少,否则操作失败。