vc 获取文件行数_VC SQL2000 获取总的行数两种方法

// 方法1

CString strSQL;

//1

strSQL.Format("SELECT SID FROM Equipment group by SID");//得到总的行数

CoInitialize(NULL);

_ConnectionPtr m_pConnection;

_RecordsetPtr m_pRecordset;

try{

m_pConnection.CreateInstance("ADODB.Connection");

m_pConnection->CursorLocation=adUseClient; //1 游标类型

m_pConnection->ConnectionString="Provider=SQLOLEDB.1;Password=; /

Persist Security Info=True;User ID=sa;Initial Catalog=PTMSE";

m_pConnection->Open("","","",adConnectUnspecified);//}

catch(...)

{

MessageBox("数据库连接失败!");

}

m_pRecordset=m_pConnection->Execute((_bstr_t)strSQL,NULL,adCmdText);//select * from History_Record authors

//CString str=(LPCSTR)_bstr_t(m_pRecordset->Fields->GetCount());//得到查询字段长度

//1。

//long count=(long)(m_pRecordset->GetRecordCount());//();//

long count=(long)(m_pRecordset->RecordCount);

CString str;

str.Format("%d",count);

MessageBox(str);

m_pRecordset->Close();

m_pConnection->Close();

m_pRecordset.Release();

m_pConnection.Release();

CoUninitialize();

//方法2：

CString strSQL;

//2{{{

strSQL.Format("SELECT count(distinct(SID)) as Total FROM Equipment");//

CoInitialize(NULL);

_ConnectionPtr m_pConnection;

_RecordsetPtr m_pRecordset;

try{

m_pConnection.CreateInstance("ADODB.Connection");

m_pConnection->CursorLocation=adUseClient; //1 游标类型

m_pConnection->ConnectionString="Provider=SQLOLEDB.1;Password=; /

Persist Security Info=True;User ID=sa;Initial Catalog=PTMSE";

m_pConnection->Open("","","",adConnectUnspecified);}

catch(...)

{

MessageBox("数据库连接失败!");}

m_pRecordset=m_pConnection->Execute((_bstr_t)strSQL,NULL,adCmdText);//select * from History_Record authors

//2。

// CStringstr=(LPCSTR)(_bstr_t)m_pRecordset->GetCollect("Total");//直接由程序得到结果，总的纪录数

// MessageBox(str);

m_pRecordset->Close();

m_pConnection->Close();

m_pRecordset.Release();

m_pConnection.Release();

CoUninitialize();