_ConnectionPtr m_pconnection;
_RecordsetPtr m_precordset;
_variant_t RecordsAffected;
CString strsql;
strsql.Format(_T("select * from wentidaninfo where maiid='lijiahua'"));
try
{
m_pconnection.CreateInstance("ADODB.Connection");
m_pconnection->ConnectionString=_T("Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Data Source=QH-20160810ZMWN\\SQLEXPRESS");
HRESULT hr=m_pconnection->Open("","","",adModeUnknown);
if (SUCCEEDED(hr))
{
HRESULT hrr=m_precordset.CreateInstance(__uuidof(Recordset));
m_pconnection->Execute((_bstr_t)strsql,&RecordsAffected,adCmdText);
while (m_precordset->adoEOF)
{
AfxMessageBox(_T("进入循环1"));
int aa=0;
CString sss=(WCHAR *)_bstr_t(m_precordset->GetCollect("kuidi"));
m_precordset->MoveNext();
}
}
}
catch (_com_error e)
{
CString ss;
ss.Format(_T("连接数据库失败\r\n错误信息:%s"),(LPCTSTR)e.Description());
AfxMessageBox(ss);
}