学步园

一、在StdAfx.h文件中添加
#import "C:/Program Files/Common Files/System/ado/msado15.dll" no_namespace rename("EOF","rsEOF")
导入ADO引擎。
二、数据库应用层操作
void CADOExample1Dlg::OnBtnQuery()<br /> {<br /> // TODO: Add your control notification handler code here<br /> CoInitialize(NULL);<br /> _ConnectionPtr pConn(__uuidof(Connection));<br /> _RecordsetPtr pRst(__uuidof(Recordset));<br /> pConn->ConnectionString = "Provider=SQLOLEDB.1;Password=123456;Persist Security Info=True;User ID=sa;Initial Catalog=db_test;Data Source=.";<br /> pConn->Open("","","",adConnectUnspecified);<br /> pRst = pConn->Execute("select * from tb_image",NULL,adCmdText);<br /> while(!pRst->rsEOF)<br /> {<br /> ((CListBox*)GetDlgItem(IDC_LIST1))->AddString(<br /> (_bstr_t)pRst->GetCollect("imageID"));<br /> pRst->MoveNext();<br /> }<br /> pRst->Close();<br /> pConn->Close();<br /> pRst.Release();<br /> pConn.Release();<br /> CoUninitialize();<br /> }