subject_22422.htm

一些关于vc的问答

<p>
序号：22422 发表者：doggie 发表日期：2002-11-25 21:20:01
<br>主题：请问ADO的recordset如何才能读出日期字段内容（急）？
<br>内容：try<BR>&nbsp;&nbsp;{<BR>&nbsp;&nbsp; m_pRs1-&gt;MoveFirst();<BR>&nbsp;&nbsp; while(m_pRs1-&gt;EndOfFile == false)<BR>&nbsp;&nbsp; {<BR>&nbsp;&nbsp;&nbsp;&nbsp;_variant_t TheValue1,TheValue2,TheValue3;<BR>&nbsp;&nbsp;&nbsp;&nbsp;CString&nbsp;&nbsp;&nbsp;&nbsp;stritem1,stritem2,stritem3;<BR>&nbsp;&nbsp;&nbsp;&nbsp;//事件序号,事件内容为varchar2型字段,事件时间为Date型字段<BR>&nbsp;&nbsp;&nbsp;&nbsp;TheValue1 = m_pRs1-&gt;GetCollect("事件序号");<BR>&nbsp;&nbsp;&nbsp;&nbsp;TheValue2 = m_pRs1-&gt;GetCollect("事件时间");<BR>&nbsp;&nbsp;&nbsp;&nbsp;TheValue3 = m_pRs1-&gt;GetCollect("事件内容");<BR>&nbsp;&nbsp;&nbsp;&nbsp;stritem1 = (TheValue1.vt!=VT_NULL)?(char*)_bstr_t(TheValue1):("");<BR>//下面这行不报错，但是无结果<BR>&nbsp;&nbsp;&nbsp;&nbsp;stritem2 = (TheValue2.vt!=VT_NULL)?(char*)_bstr_t(TheValue2):("");<BR><BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;stritem3 = (TheValue3.vt!=VT_NULL)?(char*)_bstr_t(TheValue3):("");<BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;m_pRs1-&gt;MoveNext();<BR>&nbsp;&nbsp; }<BR>&nbsp;&nbsp;}<BR>&nbsp;&nbsp;catch (_com_error &amp;e)<BR>&nbsp;&nbsp;{<BR>&nbsp;&nbsp; GenerateError(e.Error(), e.Description());<BR>&nbsp;&nbsp;}<BR><BR>
<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>回复者：啊志 回复日期：2002-11-25 22:46:31
<br>内容：应该用COleDatetime类型的变量接收，然后转换成字符串<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; _variant_t vtime;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;COleDateTime m_time;<BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;vtime=m_recordset-&gt;GetCollect(_variant_t("time"));<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;vtime.ChangeType(VT_DATE);<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;m_time=COleDateTime(vtime);<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CString time=m_time.Format(VAR_TIMEVALUEONLY);<BR>（我在这个站上考的代码）
<br>
<a href="javascript:history.go(-1)">返回上页</a><br><a href=http://www.copathway.com/cndevforum/>访问论坛</a></p></blockquote>