<p>
序號(hào)：26602 發(fā)表者：陳章民 發(fā)表日期：2003-01-03 03:34:03
<br>主題：Access .mdb如何讀入
<br>內(nèi)容：假如有一個(gè)data.mdb的檔案<BR>裡面有Table就叫table<BR><BR>name ID<BR>&nbsp;&nbsp;A&nbsp;&nbsp;12<BR>&nbsp;&nbsp;B&nbsp;&nbsp;34<BR><BR>要讀入此Table的每筆資料後存入陣列name[], id[]<BR>此程式碼要如何寫,因?yàn)槲铱吹降墓?fàn)例都太複雜,我只要如此簡(jiǎn)單的功能就好了<BR>就是打開.mdb後,讀取每筆資料的欄位,就可以了...<BR><BR>可否幫我寫出此程式碼,小弟在此感激不盡...<BR>
<br><a href="javascript:history.go(-1)">返回上頁(yè)</a><br><a href=http://www.copathway.com/cndevforum/>訪問(wèn)論壇</a></p>
<hr size=1>
<blockquote><p>
<font color=red>答案被接受</font><br>回復(fù)者：龍貓-ft 也被人用了 回復(fù)日期：2003-01-03 09:57:24
<br>內(nèi)容：我也是剛學(xué) 自己的一段代碼抄上來(lái) testrs繼承自CRecordSet 連接ODBC DSN&nbsp;&nbsp;&nbsp;&nbsp; 寫進(jìn)文本文件 要寫到數(shù)組里也一樣<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CStdioFile f1;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; testrs rs1;<BR>&nbsp;&nbsp;&nbsp;&nbsp;CString filename, value1;<BR>&nbsp;&nbsp;&nbsp;&nbsp;filename = "E:\\tt.txt";<BR>&nbsp;&nbsp;&nbsp;&nbsp;rs1.Open(CRecordset::snapshot,"select * from table1");<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(f1.Open(filename,CFile::modeCreate|CFile::modeNoTruncate|CFile::modeWrite))<BR>&nbsp;&nbsp;&nbsp;&nbsp;{<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; while( !rs1.IsEOF() )<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; rs1.GetFieldValue("mobile",value1);<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; f1.WriteString(value1+"\n");<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; rs1.MoveNext();<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<BR>&nbsp;&nbsp;&nbsp;&nbsp;}<BR>&nbsp;&nbsp;&nbsp;&nbsp;else MessageBox("File initializtion error","information",MB_OK);<BR>&nbsp;&nbsp;&nbsp;&nbsp;rs1.Close;<BR>&nbsp;&nbsp;&nbsp;&nbsp;f1.Close;<BR>
<br>
<a href="javascript:history.go(-1)">返回上頁(yè)</a><br><a href=http://www.copathway.com/cndevforum/>訪問(wèn)論壇</a></p></blockquote>
<hr size=1>
<blockquote><p>
回復(fù)者：lin 回復(fù)日期：2003-01-03 10:21:40
<br>內(nèi)容：看看這段代碼先，順便解決你提出的文件運(yùn)行路徑問(wèn)題<BR><BR>用DAO,DAO只支持到Access97，Access2000生成的文件需要轉(zhuǎn)換
<br>
<a href="javascript:history.go(-1)">返回上頁(yè)</a><br><a href=http://www.copathway.com/cndevforum/>訪問(wèn)論壇</a></p></blockquote>
<hr size=1>
<blockquote><p>
回復(fù)者：陳章民 回復(fù)日期：2003-01-05 13:30:47
<br>內(nèi)容：來(lái) testrs繼承自CRecordSet 連接ODBC DSN&nbsp;&nbsp;&nbsp;&nbsp; <BR>那麼testrs要如何定義??
<br>
<a href="javascript:history.go(-1)">返回上頁(yè)</a><br><a href=http://www.copathway.com/cndevforum/>訪問(wèn)論壇</a></p></blockquote>