subject_37099.htm

vc

<p>
序号：37099 发表者：xuan 发表日期：2003-04-21 21:47:02
<br>主题：要用_RecordsetPtr需要加入哪些头文件？？？
<br>内容：要在一个数据库工程中用_RecordsetPtr和_ConnectionPtr这两咱类型，要在头文件中加入那些头文件啊，谁能帮忙，小弟在此多谢先
<br><a href="javascript:history.go(-1)">返回上页</a><br><a href=http://www.copathway.com/cndevforum/>访问论坛</a></p>
<hr size=1>
<blockquote><p>
<font color=red>答案被接受</font><br>回复者：擎天柱 回复日期：2003-04-21 21:50:58
<br>内容：#import "c:\Program Files\Common Files\System\ADO\msado15.dll" \<BR>no_namespace rename("EOF", "EndOfFile")<BR><BR>#include &lt;stdio.h&gt;<BR><BR>void main(void)<BR>{<BR>&nbsp;&nbsp; CoInitialize(NULL);<BR>&nbsp;&nbsp; try <BR>&nbsp;&nbsp; {<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;_ConnectionPtr pConn("ADODB.Connection");<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;_RecordsetPtr&nbsp;&nbsp;pRst("ADODB.Recordset");<BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;pConn-&gt;Open("Provider=sqloledb;Data Source=MyServer;"<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "Initial Catalog=pubs;User Id=sa;Password=;", <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "", "", adConnectUnspecified);<BR>// Note 1.<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;pRst-&gt;Open(<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "authors",<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; _variant_t((IDispatch *) pConn, true),<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; adOpenStatic,<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; adLockReadOnly,<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; adCmdTable);<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;pRst-&gt;MoveLast();<BR>// Note 2.<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;printf("Last name is '%s %s'\n", <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(char*) ((_bstr_t) pRst-&gt;GetFields()-&gt;GetItem("au_fname")-&gt;GetValue()),<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(char*) ((_bstr_t) pRst-&gt;Fields-&gt;Item["au_lname"]-&gt;Value));<BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;pRst-&gt;Close();<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;pConn-&gt;Close();<BR>&nbsp;&nbsp; }<BR>&nbsp;&nbsp; catch (_com_error &amp;e)<BR>&nbsp;&nbsp; {<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;printf("Description = '%s'\n", (char*) e.Description());<BR>&nbsp;&nbsp; }&nbsp;&nbsp; <BR>::CoUninitialize();<BR>}
<br>
<a href="javascript:history.go(-1)">返回上页</a><br><a href=http://www.copathway.com/cndevforum/>访问论坛</a></p></blockquote>