1 void CsunxinDlg::OnClickedQuery()
 2 {
 3     // TODO: 在此添加控件通知处理程序代码
 4     CoInitialize(NULL);
 5     _ConnectionPtr pConn(_uuidof(Connection));
 6     _RecordsetPtr pRst(_uuidof(Recordset));
 7     pConn->ConnectionString="Data Source=.;Provider=SQLOLEDB.1;Persist Security Info=False;Initial Catalog=HRMS";
 8     pConn->Open("","","",adConnectUnspecified);
 9     pRst=pConn->Execute("select * from dbo.tb_employee",NULL,adCmdText);
10     while(!pRst->adoEOF)
11     {
12         ((CListBox*)GetDlgItem(IDC_LIST1))->AddString((_bstr_t)pRst->GetCollect("employee_name"));
13         pRst->MoveNext();
14     }
15     pRst->Close();
16     pConn->Close();
17     pRst.Release();
18     pConn.Release();
19     CoUninitialize();
20 }