采用ADO连接数据库.doc

《采用ADO连接数据库.doc》由会员分享，可在线阅读，更多相关《采用ADO连接数据库.doc（5页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、连接数据库首先编辑UDL文件。新建一个txt文件，将其后缀名改为udl即可配置；在头文件中加入：#pragma warning(disable:4146)#import C:Program FilesCommon FilesSystemADOmsado15.dll named_guids rename(EOF,adoEOF), rename(BOF,adoBOF)#pragma warning(default:4146)using namespace ADODB;#include icrsint.h#include comutil.h/对COM组件进行初始化#include comdef.h在

2、cpp文件中：_ConnectionPtrm_pConnection;_RecordsetPtr m_pRecordset;if FAILED(:CoInitialize(NULL)CATDlgNotify * pPromptBox = new CATDlgNotify(CATApplicationFrame:GetApplicationFrame()-GetMainWindow(), 提示, CATDlgNfyInformation); pPromptBox-SetText(初始化COM库失败！); pPromptBox-SetVisibility(CATDlgShow);return ;H

3、RESULT hr;if(FAILED(m_pConnection.CreateInstance(ADODB.Connection) /ADODB.Connection或_uuidof(Connection) coutError, Unicom: Create the Instance Failed!GetMainWindow(), 提示, CATDlgNfyInformation); pPromptBox-SetText(创建_ConnectionPtr对象失败！); pPromptBox-SetVisibility(CATDlgShow);m_pConnection-Release();

4、return ; try m_pConnection-ConnectionString=File Name=C:/ado.udl;m_pConnection-ConnectionTimeout = 20;/设置超时时间为20秒m_pConnection-Open(,adModeUnknown);catch(_com_error a_pComError)AfxMessageBox(a_pComError.Description();CATDlgNotify * pPromptBox = new CATDlgNotify(CATApplicationFrame:GetApplicationFram

5、e()-GetMainWindow(), 提示, CATDlgNfyInformation); pPromptBox-SetText(数据源连接失败，请检查您的数据服务是否正常！); pPromptBox-SetVisibility(CATDlgShow);m_pConnection.Release();return; hr=m_pRecordset.CreateInstance(_uuidof(Recordset);/初始化Recordset指针 _CommandPtr m_pCommand;m_pCommand.CreateInstance(_uuidof(Command);m_pComm

6、and-ActiveConnection = m_pConnection; m_pCommand-CommandText = thecommandtext; /select * from 表名m_pRecordset = m_pCommand-Execute(NULL, NULL,adCmdText);CATUnicodeString type;int Thecountofm_pRecordset=0;while(!m_pRecordset-adoEOF)_variant_t var; var = m_pRecordset-GetCollect(TYPE_NAME);if (var.vt!=VT_NULL) type=(LPCSTR)_bstr_t(var);/转换成CATUnicodeStringcPublic:AddNewItemToCombo(type,Combo);m_pRecordset-MoveNext(); m_pRecordset-Close();m_pConnection-Close();:CoUninitialize();