怎么样在VC中使用ADO的Recordset向数据库增加记录？

Question

//pConnectiony已经初始化好了 _RecordsetPtr pRecordSet;
HRESULT hr;
try{
hr=pRecordSet.CreateInstance(__uuidof(Recordset));
if(SUCCEEDED(hr)){
pRecordSet->Open("select * from table",
    pConnection.GetInterfacePtr(),
    adOpenDynamic,
    adLockOptimistic,
    adCmdText);
pRecordSet->AddNew(); //各个字段入库：这里是两个CString入库 pRecordSet->PutCollect(L"字段1",&(_variant_t（LPCTSTR)str1)));
pRecordSet->PutCollect(L"字段2",&(_variant_t((LPCTSTRstr2))); pRecordSet->Update();
}
}
catch(_com_error &e)
{
TRACE("Error: %08lx.\n",e.Error());
TRACE("ErrorMessage: %s.\n",e.ErrorMessage());
TRACE("Source: %s.\n",(LPCTSTR)_bstr_t(e.Source()));
TRACE("Description: %s.\n",(LPCTSTR)_bstr_t(e.Description()));
return 0;
}
catch(...)
{
//AfxMessageBox("DataAdd error");
return 0;
}