VC6.0 利用ADO连接Sqlserver2005数据库方法

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