📄 mdmscexampleadowithoutextensions.htm

📁 ADO使用手册,非常详细

💻 HTM

字号:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">
<HTML dir=ltr>
<HEAD>
<META HTTP-EQUIV="Content-Type" Content="text/html; charset=gb2312"><title>范例: 无 Extensions 的 ADO</title>
<style>@import url(msdn_ie4.css);</style>
</HEAD>
<BODY>
<h2><a name="mdmscexampleadowithoutextensions"></a>范例: 无 Extensions 的 ADO</h2>
<p><a href="dir.htm">目录</a></p>
<p>
该程序段说明了如何从字段检索数值并将数值转换为 C++ 变量。</p>
<pre>#import "c:\Program Files\Common Files\System\ADO\msado15.dll" 
   no_namespace rename("EOF", "EndOfFile")
#include &lt;stdio.h&gt;Class CEmployee
{
public:
   FetchEmployeeData();   char m_szFirstName[30];
   char m_szLastName[30];
   int nAge;
};CEmployee::FetchEmployeeData()
{
_ConnectionPtr   pCon();
_RecordsetPtr    pRs();
FieldPtr         pfldFirstName, pfldLastName, pfldAge;
_variant_t      vFirstName, vLastName, vAge;pCon.CreateInstance(__uuidof(Connection));
pCon-&gt;Open("pubs", "sa", "");pRs.CreateInstance(__uuidof(Recordset));
pRs-&gt;Open("select FirstName, LastName, Age from Employees", pCon, 
   adOpenForwardOnly, adLockReadOnly, adCmdUnknown);pfldFirstName = pRs-&gt;Fields-&gt;GetItem(0);
pfldLastName = pRs-&gt;Fields-&gt;GetItem(1);
pfldAge = pRs-&gt;Fields-&gt;GetItem(2);while (VARIANT_FALSE == pRs-&gt;EndOfFile)
   {
   vFirstName.Clear();
   vLastName.Clear();
   vAge.Clear();   vFirstName = pfldFirstName-&gt;Value;
   WideCharToMultiByte(CP_ACP, 0, vFirstName.bstrVal, -1, 
      m_szFirstName, sizeof(m_szFirstName), NULL, NULL);   vLastName = pfldLastName-&gt;Value;
   WideCharToMultiByte(CP_ACP, 0, vLastName.bstrVal, -1, 
      m_szLastName, sizeof(m_szLastName), NULL, NULL);   nAge = vAge.iVal;   pRs-&gt;MoveNext();
   }
}
</pre>
<center> <A HREF="http://www.51windows.Net">www.51windows.Net</A></center>
<SCRIPT LANGUAGE="JavaScript" src="/log/sitelog2.asp"></SCRIPT>
<script src="script.js"></script></BODY>
</HTML>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -