_RecordsetPtr m_pRecordset;
m_pRecordset.CreateInstance("ADODB.Recordset");
m_pRecordset->Open("select * from task where state=3",_variant_t((IDispatch*)m_pConnection,true),adOpenDynamic,adLockOptimistic,adCmdText);
m_pRecordset->MoveFirst();
int iCount=m_pRecordset->GetRecordCount();
m_pRecordset.CreateInstance("ADODB.Recordset");
m_pRecordset->Open("select * from task where state=3",_variant_t((IDispatch*)m_pConnection,true),adOpenDynamic,adLockOptimistic,adCmdText);
m_pRecordset->MoveFirst();
int iCount=m_pRecordset->GetRecordCount();
对啊,
m_pRecordset->GetRecordCount();
你要先遍历所有的记录再调用这个函数,返回的才是记录数,
也就是如下样子:
m_pRecordset->movefirst();
while(m_pRecordset->IsEOF()?)
{
m_pRecordset->movenext();
}
count=m_precordset->getrecordcount();