subject_28333.htm

一些关于vc的问答

<p>
序号：28333 发表者：二进制 发表日期：2003-01-20 15:07:14
<br>主题：VC中用ODBC连接ACCESS数据库
<br>内容：　　在VC中用ODBC连接ACCESS数据库，该怎样提交一个查询？<BR>比如：&nbsp;&nbsp;&nbsp;&nbsp;CDatabase*&nbsp;&nbsp;m_tmpdb;<BR>&nbsp;&nbsp;&nbsp;&nbsp;JhdbRecordset* m_pSet;<BR>&nbsp;&nbsp;&nbsp;&nbsp;CString strSQL;<BR>&nbsp;&nbsp;&nbsp;&nbsp;strSQL="select * from companylist";<BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;sDSN="ODBC;DRIVER=Microsoft Access Driver (*.mdb);DSN='';DBQ=colist.mdb";<BR>&nbsp;&nbsp;&nbsp;&nbsp;m_tmpdb =new CDatabase;<BR>&nbsp;&nbsp;&nbsp;&nbsp;if(!m_tmpdb-&gt;Open(NULL,FALSE,FALSE,sDSN,FALSE))<BR>&nbsp;&nbsp;&nbsp;&nbsp;m_pSet=new JhdbRecordset(m_tmpdb);<BR>&nbsp;&nbsp;&nbsp;&nbsp;m_pSet-&gt;Open(CRecordset::dynaset,strSQL);<BR>这样提交了一个查询：select * from companylist<BR>是不是每提交一个查询都要这样？还是有别的简单的方法？<BR>2003-1-20 15:29:28