本文實(shí)例講述了VC基于ADO技術(shù)訪問(wèn)數(shù)據(jù)庫(kù)的方法。分享給大家供大家參考。具體如下:
一、在StdAfx.h文件中添加
二、數(shù)據(jù)庫(kù)應(yīng)用層操作
void CADOExample1Dlg::OnBtnQuery(){ // TODO: Add your control notification handler code here CoInitialize(NULL); _ConnectionPtr pConn(__uuidof(Connection)); _RecordsetPtr pRst(__uuidof(Recordset)); pConn->ConnectionString = "Provider=SQLOLEDB.1;Password=123456;Persist Security Info=True;User ID=sa;Initial Catalog=db_test;Data Source=."; pConn->Open("","","",adConnectUnspecified); pRst = pConn->Execute("select * from tb_image",NULL,adCmdText); while(!pRst->rsEOF) { ((CListBox*)GetDlgItem(IDC_LIST1))->AddString( (_bstr_t)pRst->GetCollect("imageID")); pRst->MoveNext(); } pRst->Close(); pConn->Close(); pRst.Release(); pConn.Release(); CoUninitialize();}希望本文所述對(duì)大家的VC程序設(shè)計(jì)有所幫助。
新聞熱點(diǎn)
疑難解答
圖片精選