请问

Question

     _ConnectionPtr m_pConnection; 
     m_pConnection.CreateInstance(__uuidof(Connection)); 
     _RecordsetPtr pr; 
     _bstr_t query("SELECT * FROM test"); 
     _variant_t vr; 
     vr.vt=VT_ERROR; 
     vr.scode=DISP_E_PARAMNOTFOUND; 
     pr=m_pConnection->Execute(query,&vr,adOptionUnspecified);
     请问然后我怎么遍历pr记录的内容？？？   

Answer 1

if(pr->GetRecordCount()!=0)
{
    pr->MoveFirst();
}
while(!pr->IsEoF) //这里看你是怎么import的
{
   pr->GetCollect("FieldName");
   .....//用GetCollect取每个字段的值
   pr->MoveNext();
}