#include <afxdb.h>
要包含上面的头文件
CDatabase m_dbConn;
CString szTemp;szTemp.Format("Driver={SQL Server};Server=%s;UID=%s;PWD=%s;Database=DataCollection;wsid=DataCollection",
"127.0.0.1",
"sa",
"1234567");
BOOL flg = m_dbConn.OpenEx(szTemp, CDatabase::noOdbcDialog);
if (flg)
{
AfxMessageBox("成功");
CRecordset *m_pProof=new CRecordset(&m_dbConn);
CString strSQL = L"select * from t_User";
m_pProof->Open(AFX_DB_USE_DEFAULT_TYPE,strSQL,CRecordset::none);
// short num = m_pProof->GetRecordCount();
DWORD nRows = 0;
while(!m_pProof->IsBOF())
{
}
nRows = m_pProof->GetRecordCount();