rivate 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中的某个数据的时候.
我应该如何编程.
解决方案 »
- sSql = "select * from routes1 where ID=z"
- Vb类型不匹配
- VB +access 这样连接 为什么会提示错误?
- vb连接access数据库出错
- 怎么使用在VB中添加的windows media player 9.0的播放控件呢?
- VBA中,连接两个数据库老是有问题,
- 一个SQL语句的问题!!!(急)
- 如何修改,删除MSHFLEXGRID控件中的某一行记录(用鼠标选择)!
- 一个中等的问题.COME ON!
- DAO删除问题
- 请问有谁知道"Bit4VB.DLL"?(急啊!)
- 我想编个小程序:把它放在优盘里(不是放在电脑里),每次插上优盘时,这个程序就会自动运行,把桌面上的*.PPT文件copy到优盘。(上课用
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 = Read_Text_File
时说是要求对象。。
Set dgData.DataSource =rs
rs.find "字段='aaa'"
if not rs.eof then
msgbox"已經找到"
else
msgbox"記錄沒找到"
end
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 [jjj.txt]", conn, adOpenStatic, adLockReadOnly, adCmdText
Set dgData.DataSource = rs
rs.MoveFirst
rs.Find "name='111'"
If Not rs.EOF Then
MsgBox "已經找到"
Else
MsgBox "記錄沒找到"
End IfEnd Sub运行到 Set dgData.DataSource = rs 行时总是提示要求对象
运行到rs.Find "name='111'"这一行提示说是
项目在所需的名称或序数中末被发现。
怎么办?
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 [jjj.txt]", conn, adOpenStatic, adLockReadOnly, adCmdText
msgbox"記錄數為﹕" & rs.recordcount '--如果打開記錄集正確﹐這一行應該顯示為多少記錄數
Set dgData.DataSource = rs
rs.MoveFirst
rs.Find "name='111'"
If Not rs.EOF Then
MsgBox "已經找到"
Else
MsgBox "記錄沒找到"
End If
//运行到rs.Find "name='111'"这一行提示说是
dim aa as string
aa='111'
改成﹕rs.find "name='" & aa & "'"
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
Dim conn As ADODB.Connection
Dim aa As String
aa = "111"
Set conn = New ADODB.Connection
conn.Open "DRIVER={Microsoft Text Driver (*.txt; *.csv)};" & "DBQ=" & "c:\ " & ";", "", ""
rs.CursorLocation = adUseClient
rs.Open "select * from [jjj.txt]", conn, adOpenStatic, adLockReadOnly, adCmdText
MsgBox "記錄數為﹕" & rs.RecordCount '--如果打開記錄集正確﹐這一行應該顯示為多少記錄數rs.MoveFirstaa = "111"
rst.Find "name='" & aa & "'"
If Not rs.EOF Then
MsgBox "已經找到"
Else
MsgBox "記錄沒找到"
End IfEnd Sub还是一样的。
运行到rst.Find "name='" & aa & "'"这一行提示说是
项目在所需的名称或序数中末被发现。
怎么办?
在rs.fields.item1.name 这个NAME里面有我所要查找的数据
请问需要引用的具体名字叫什么。
不好意思。
麻烦了。
我的工具框里面只有一个跟数据库有关的控件
叫data
我是直接又击加到我的FORM1上的。
没有改名字叫data1
是这个吗?
加了还是不行。
没有你的那个(SP5)
加上了还是不行。
改名叫DGDATA就可以了。
但是运行到rs.Find "name='" & aa & "'"这一行提示说是
项目在所需的名称或序数中末被发现。
怎么办?
不过我这有个,可以把txt转化成数据库的我发给你
Dim sStr As String
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
这只是个例子,你看看 每一行做为一条记录
name你的TXT里没有吧
。
说对了
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