我在程序中用的ACCESS数据库,想做符合条件的搜索,然后把结果另存为文本文件,高手们请帮忙,分不够,再开贴。谢谢!
解决方案 »
- toolbar如何加背景图片
- 如何限制程序只运行一次
- 关于三层模式中,数据访问层的写法,欢迎来探讨(COM+熟悉的请进)
- 操作二进制数据问题
- 请问:DataGrid如何显示数据库中搜索出来的结果?加急!(在线)
- 调用ExitWindowsEx(EWX_SHUTDOWN + EWX_POWEROFF, 0)为什么老是注销 而不是关机
- MSFlexGrid控件中怎样才能显示上标?
- 大家谁玩过吃豆子的游戏,就是那个什么恢复胃动力“吗叮咛”广告中的游戏,请教算法?
- 如何根据数据库重读取的数据来设置comboBox的值?
- 哪位高手知道,vb中不用ocx 和 dll 读取CPU信息!谢谢!
- 关于datagrid的超郁闷问题,小小的系统弄的俺焦头烂额。
- 这样的界面应该怎么实现比较好
dim db as database
dim rs recordset
Set db = OpenDatabase(t)
Set rs = db.TableDefs("db_biaoyi").OpenRecordset(dbOpenDynaset)
rs.Filter = "作者=frmsearch.comboauthor.text"
rs.Sort = "作者"
Set rss = rs.OpenRecordset()
rs.Close
rss.MoveFirst
Do While Not rss.EOF
For Each fld In rss.Fields
rss.MoveFirst
Do While Not rss.EOF
For Each fld In rss.Fields
Open "c:\temp.txt" For Append Lock Write As filenum
Print #filenum, fld
Close #filenum
Next
rss.MoveNext
rss.MoveNext
Loop
rss.Close
db.Close结果程序报错,说Set rss = rs.OpenRecordset()
这句参数有误。
下周得交,请高手帮忙,万分感谢!
dim rs recordset
Set db = OpenDatabase(t)
Set rs = db.TableDefs("db_biaoyi").OpenRecordset(dbOpenDynaset)
rs.Filter = "作者=frmsearch.comboauthor.text"
rs.Sort = "作者"rs.MoveFirst
Do While Not rs.EOF
For Each fld In rss.Fields
Open "c:\temp.txt" For Append Lock Write As filenum
Print #filenum, fld
Close #filenum
Next
rs.MoveNext
Loop
rs.Close
db.Close
Dim db As Database
Dim rss As Recordset
Set db = OpenDatabase(t)
Set rss = db.TableDefs("db_biaoyi").OpenRecordset(dbOpenDynaset)
rss.Filter = "作者=frmsearch.comboauthor.text"
rss.Sort = "作者" rss.MoveFirst
Do While Not rss.EOF
For Each fld In rss.Fields
Open "c:\temp.txt" For Append Lock Write As filenum
Print #filenum, fld
Close #filenum
Next
rss.MoveNext
Loop
rss.Close
db.Close
End Sub
引用ADO(“工程”/“引用”/Microsoft ActiveX Data 2.X Library)Private Sub Command1_Click()
Dim cn As New ADODB.Connection, rs As New ADODB.Recordset, i As Integer
cn.CursorLocation = adUseClient
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\Test.mdb;Jet OLEDB:DataBase password=;" rs.Open "select * from 表名称 where 作者='" & frmsearch.comboauthor.Text & "' order by 作者 ", cn, adOpenKeyset, adLockReadOnly rs.MoveFirst
While Not rs.EOF
For i = 0 To rs.Fields.Count - 1
Open "c:\temp.txt" For Append Lock Write As #1
Print #1, rs(i)
Close #1
Next
rs.MoveNext
Wend
rs.Close
cn.Close
End Sub
避免经常打开经常关闭操作 rs.MoveFirst
Open "c:\temp.txt" For Append Lock Write As #1
While Not rs.EOF
For i = 0 To rs.Fields.Count - 1
Print #1, rs(i)
Next
rs.MoveNext
Wend
Close #1 rs.Close
cn.Close
End Sub
不想每个字段做一行,只要稍微改一下上面的代码就行了Private Sub Command1_Click()
Dim cn As New ADODB.Connection, rs As New ADODB.Recordset, i As Integer, strTemp As String
cn.CursorLocation = adUseClient
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\Test.mdb;Jet OLEDB:DataBase password=;"
rs.Open "select * from 表名称 where 作者='" & frmsearch.comboauthor.Text & "' order by 作者 ", cn, adOpenKeyset, adLockReadOnly
rs.MoveFirst
Open "c:\temp.txt" For Append Lock Write As #1
While Not rs.EOF
For i = 0 To rs.Fields.Count - 1
strTemp = strTemp & rs(i) & " "
Print #1, strTemp
Next
strTemp = ""
rs.MoveNext
Wend
Close #1
rs.Close
cn.Close
End Sub