subject_65325.htm

vc

<p>
序号：65325 发表者：好古L 发表日期：2003-12-17 03:33:03
<br>主题：请问在ADO里取出数据库某行某列的函数是什么啊？
<br>内容：请问在ADO里取出数据库某行某列的函数是什么啊？
<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>回复者：gaojie 回复日期：2003-12-17 08:54:11
<br>内容：使用GetCollect()函数，但取出的数据要转换，如下：<BR>_variant_t strQuery = &#34;select custom_Name, room_Id, dia_Flag, pay_Mode, deposit from Enrol_Info where credential_Num = '&#34; + m_strCustomID + &#34;'&#34;;<BR>&nbsp;&nbsp;&nbsp;&nbsp;theApp.ADOExecute (m_pCustomSet, strQuery);<BR>&nbsp;&nbsp;&nbsp;&nbsp;Holder = m_pCustomSet-&gt;GetCollect(&#34;custom_Name&#34;); <BR>&nbsp;&nbsp;&nbsp;&nbsp;m_strName = Holder.vt == VT_NULL ? &#34;&#34; : (char*)(_bstr_t)Holder;<BR>&nbsp;&nbsp;&nbsp;&nbsp;Holder = m_pCustomSet-&gt;GetCollect(&#34;room_Id&#34;);<BR>&nbsp;&nbsp;&nbsp;&nbsp;m_strRoomID = Holder.vt == VT_NULL ? &#34;&#34; : (char*)(_bstr_t)Holder;<BR>&nbsp;&nbsp;&nbsp;&nbsp;Holder = m_pCustomSet-&gt;GetCollect(&#34;dia_Flag&#34;);<BR>&nbsp;&nbsp;&nbsp;&nbsp;m_strDiaFlag = Holder.vt == VT_NULL ? &#34;&#34; : (char*)(_bstr_t)Holder;<BR>&nbsp;&nbsp;&nbsp;&nbsp;Holder = m_pCustomSet-&gt;GetCollect (&#34;pay_Mode&#34;);<BR>&nbsp;&nbsp;&nbsp;&nbsp;m_strPayMode = Holder.vt == VT_NULL ? &#34;&#34; : (char*)(_bstr_t)Holder;
<br>
<a href="javascript:history.go(-1)">返回上页</a><br><a href=http://www.copathway.com/cndevforum/>访问论坛</a></p></blockquote>