1.将数据库连接属性设置一下就行了,如你的连接指针变量是m_pConnection,可以这样:
::CoInitialize(NULL);
m_pConnection.CreateInstance(_uuidof(Connection)); //初始化Connection指针
m_pConnection->CursorLocation = adUseClient;
。。。。
。。。。
2.遍历数据
long n = 0;
while(!myRecordset-> adoEOF)
{
n++;
myRecordset-> MoveNext();
}
3.通过Sql语句
Select Count(*)
from 表
where 条件
m_pPtr = m_paConnection->Execute((_bstr_t)strSQL, NULL, adCmdText);
_variant_t vIndex = (long)0;
_variant_t vCount =m_pPtr->GetCollect(vIndex);
long nNum = vCount.ulVal;