第一步:在stdafx.h文件里添加代码:
#import "C:/Program Files/Common Files/System/ado/msado15.dll" no_namespace /
rename("EOF","adoEOF") rename("BOF","adoBOF")
第二步:添加一个连接数据库的对象:_ConnectionPtr m_pConnection;
第三步:添加一个按钮。响应函数为:
void CVDlg::OnButton1()
{
// TODO: Add your control notification handler code here
::CoInitialize(NULL);
try{
m_pConnection.CreateInstance("ADODB.Connection");
_bstr_t strConnect="Provider=SQLNCLI.1;Password=111,Persist Security Info=True;User ID=tsoft;Initial Catalog=MySQLDB;Data Source=HRMS";
m_pConnection->Open(strConnect,"","",adModeUnknown);
}
catch(_com_error e)
{
AfxMessageBox(e.Description());
}
}