C++简单练习

最新推荐文章于 2022-11-27 10:59:24 发布

flyerwing

最新推荐文章于 2022-11-27 10:59:24 发布

阅读量494

点赞数

文章标签： c++ security mfc null server list

本文链接：https://blog.csdn.net/flyerwing/article/details/5253830

版权

C++MFC用ADO连接MSSQL：

在stdafx.h中倒入ado.dll:

#import "C:/Program Files/Common Files/System/ado/msado15.dll" no_namespace rename("EOF","rsEOF")//倒入ADO动态连接库并做设置

按钮事件代码：

try
{
  CoInitialize(NULL);
  _ConnectionPtr pConn(__uuidof(Connection));
  _RecordsetPtr pRst(__uuidof(Recordset));
  pConn->ConnectionString="Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;PassWord=123;Server=.;Initial Catalog=WirelessCare";
  pConn->Open("","","",adConnectUnspecified);
  pRst=pConn->Execute("select * from City",NULL,adCmdText);
  while(!pRst->rsEOF)
  {
   ((CListBox*)GetDlgItem(IDC_LIST1))->AddString((_bstr_t)pRst->GetCollect("name"));
   pRst->MoveNext();
  }
  pRst->Close();
  pConn->Close();
  pRst.Release();
  pConn.Release();
  CoUninitialize();
}
catch(_com_error e)
{
AfxMessageBox(e.Description());
}