VC6.0 利用ADO连接Sqlserver2005数据库方法创建一个基于对话框的工程。
1.在stdafx.h中添加ADO的引用//步骤1 添加ado dll的引用
#import "C:\Program Files\Common Files\System\ado\msado15.dll" no_namespace rename("EOF","rsEOF")
//步骤2,添加查询按钮和List控件,添加代码
void CAdoTestDlg::OnbtnQuery()
{
CoInitialize(NULL);
_ConnectionPtr pConn(__uuidof(Connection));
_RecordsetPtr pRst(__uuidof(Recordset));
//_CommandPtr pCmd(__uuidof(Command));
//SQL2005数据库几种常见的连接方式,更多参考//http://www.connectionstrings.com/sql-server-2005
//_bstr_t strConnect="driver={SQL Native Client};Server=192.168.150.1\\SQL2005;Database=eBookStore;Trusted_Connection=yes;";
//_bstr_t strConnect="driver={SQL Native Client};Server=GMH\\SQL2005;Database=eBookStore;UID=sa;PWD=sa123";\\myServerName\theInstanceName方式
//标准连接方式:"Driver={SQL Native Client};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;"
_bstr_t strConnect="Driver={SQL Native Client};Server=127.0.0.1;Database=eBookStore;Uid=sa;Pwd=sa123;";
pConn->Open(strConnect,"","",adConnectUnspecified);
pRst=pConn->Execute("select * from users",NULL,adCmdText);
while(!pRst->rsEOF)
{
((CListBox*)GetDlgItem(IDC_LIST1))->AddString(
(_bstr_t)pRst->GetCollect("username"));
pRst->MoveNext();
}
pRst->Close();
pConn->Close();
//pCmd.Release();
pRst.Release();
pConn.Release();
CoUninitialize();
}
效果图:
3.数据库结构说明:
数据库实例名 eBookStore 用户名 sa 密码sa123
Database=eBookStore;Uid=sa;Pwd=sa123
数据库表 users
字段 username ...
http://download.csdn.net/download/vcpro126/4846741