private Sub Command1_Click()
Set dgData.DataSource = Read_Text_FileEnd Sub
Public Function Read_Text_File() As ADODB.Recordset Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
Dim conn As ADODB.Connection
Set conn = New ADODB.Connection
conn.Open "DRIVER={Microsoft Text Driver (*.txt; *.csv)};" & "DBQ=" & "c:\ " & ";", "", "" rs.Open "select * from [jjjj.txt]", conn, adOpenStatic, adLockReadOnly, adCmdText
Set Read_Text_File = rs
' Set rs = Nothing
' Set conn = Nothing
End Function我用以上程序新建了一个数据库
当我想查找jjjj.txt中的某个数据的时候.
我应该如何编程.
Set dgData.DataSource = Read_Text_FileEnd Sub
Public Function Read_Text_File() As ADODB.Recordset Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
Dim conn As ADODB.Connection
Set conn = New ADODB.Connection
conn.Open "DRIVER={Microsoft Text Driver (*.txt; *.csv)};" & "DBQ=" & "c:\ " & ";", "", "" rs.Open "select * from [jjjj.txt]", conn, adOpenStatic, adLockReadOnly, adCmdText
Set Read_Text_File = rs
' Set rs = Nothing
' Set conn = Nothing
End Function我用以上程序新建了一个数据库
当我想查找jjjj.txt中的某个数据的时候.
我应该如何编程.
解决方案 »
- 请教datagrid问题
- SQL Server 好慢啊!大哥们救我
- vb链接数据库的问题
- mcisendstring播放avi,暂停时,当前帧的图像会被挡在前面的窗体抹去,如何解决?
- 哪位大侠能帮我在http://www.114online.com/html/search/class/b01.html填写“北京”、“东城区”并选上“卫生部”?
- 求助!明天交毕设!最后的纠结! 关于VB中 Teechart的只用问题
- VB如何调用RAR?
- asp导出execl合并上下两行代码怎么写
- 水晶报表中报表页眉有个OLE及交叉表,如何让交叉表起始位置不变?
- 请问后缀为frx的文件是什么文件?
- 谁有定时开关机代码呀?
- 如何自动添加用户名?
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
Dim conn As ADODB.Connection
Set conn = New ADODB.Connection
conn.Open "DRIVER={Microsoft Text Driver (*.txt; *.csv)};" & "DBQ=" & "c:\ " & ";", "", ""
rs.cursorlocation=aduseclient--->加這行
rs.Open "select * from [jjjj.txt]", conn, adOpenStatic, adLockReadOnly, adCmdText
Set dgData.DataSource = Read_Text_FileEnd Sub也已經在另一帖回答了﹐請你試一試
改成﹕Set dgData.DataSource =rs
不过我这有个,可以把txt转化成数据库的我发给你
Dim con As New ADODB.Connection
Dim rs As New ADODB.Recordset
Private Sub Command1_Click()
Open App.Path + "\turkey.txt" For Input As #1
While Not EOF(1)
Input #1, sStr
rs.AddNew
rs(0) = sStr
Wend
rs.Update
rs.Close
End SubPrivate Sub Form_Load()
mdbPath = App.Path + "\file.mdb"
con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & mdbPath & ";Persist Security Info=False"
rs.Open "select * from data", con, adOpenDynamic, adLockOptimistic
End Sub
这只是个例子,你看看 每一行做为一条记录
Dim con As New ADODB.Connection
Dim rs As New ADODB.Recordset
Private Sub Command1_Click() '把txt转换成数据库
Open App.Path + "\turkey.txt" For Input As #1
While Not EOF(1)
DoEvents
Input #1, sStr
rs.AddNew
rs(0) = sStr
Wend
rs.Update
rs.Close
End SubPrivate Sub Command2_Click() '产生txt
Open App.Path + "\turkey.txt" For Output As #1
For i = 1 To 50000
DoEvents
Write #1, i
Next i
Close #1
End SubPrivate Sub Command3_Click() '查找里边是4554 有MSGBOX提示
rs.Close
rs.Open "select * from data where 内容='4554' ", con, adOpenDynamic, adLockOptimistic
If rs.EOF Then
MsgBox "没有找到"
Else
MsgBox "找到了"
End If
End SubPrivate Sub Form_Load()
mdbPath = App.Path + "\file.mdb"
con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & mdbPath & ";Persist Security Info=False"
rs.Open "select * from data", con, adOpenDynamic, adLockOptimistic
End Sub
改后的,测试过了,如果有疑问加我qq51365133