Private Sub Form_Load()
Dim conn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim sql As String
Dim i As Integer
Text1.Enabled = False
Text2.Enabled = False
Text3.Enabled = False
Text4.Enabled = False
Text5.Enabled = False
Combo1.ListIndex = 1
Set conn = New ADODB.ConnectionSet rs = New ADODB.Recordset
rs.CursorLocation = adUseClient
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\199905.mdb;Persist Security Info=False"conn.OpenIf conn.State = 0 Then MsgBox ("连接失败")
Set rs = conn.OpenSchema(adSchemaTables)
i = 0
Do While Not rs.EOF
If rs.Fields("TABLE_TYPE") = "TABLE" Then
i = i + 1
Combo2.AddItem rs.Fields("TABLE_NAME")
End If
rs.MoveNext
Loop
Combo2.ListIndex = 1
sql = "select * from " & Combo2.TextSet rs = conn.Execute(sql)
If rs.State = 0 Then MsgBox ("数据库操作失败")
'Text1.Text = rs.Fields("")dg.DataSource = rs
dg.RefreshEnd Sub
在dg.DataSource = rs这里还是出现找不到方法或成员!!!
在conn.open之前我已经添加了rs.CursorLocation = adUseClient的了!!
麻烦帮我看看,那里错了,我看了一晚上了,都没看出来!
Dim conn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim sql As String
Dim i As Integer
Text1.Enabled = False
Text2.Enabled = False
Text3.Enabled = False
Text4.Enabled = False
Text5.Enabled = False
Combo1.ListIndex = 1
Set conn = New ADODB.ConnectionSet rs = New ADODB.Recordset
rs.CursorLocation = adUseClient
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\199905.mdb;Persist Security Info=False"conn.OpenIf conn.State = 0 Then MsgBox ("连接失败")
Set rs = conn.OpenSchema(adSchemaTables)
i = 0
Do While Not rs.EOF
If rs.Fields("TABLE_TYPE") = "TABLE" Then
i = i + 1
Combo2.AddItem rs.Fields("TABLE_NAME")
End If
rs.MoveNext
Loop
Combo2.ListIndex = 1
sql = "select * from " & Combo2.TextSet rs = conn.Execute(sql)
If rs.State = 0 Then MsgBox ("数据库操作失败")
'Text1.Text = rs.Fields("")dg.DataSource = rs
dg.RefreshEnd Sub
在dg.DataSource = rs这里还是出现找不到方法或成员!!!
在conn.open之前我已经添加了rs.CursorLocation = adUseClient的了!!
麻烦帮我看看,那里错了,我看了一晚上了,都没看出来!
解决方案 »
- 改表中字段值无效的问题
- 郁闷的HEX转CHR,在线等待.高分求助~~~~~~~~~~~~~~~
- 请问如何通过修改注册表实现类似winrar的“压缩为*.rar”系统菜单功能?
- 请高手给我解释一下 recordset的open方法的 几个参数的枚举值的详细作用及意义.谢谢
- 希望大家帮忙,怎样生成dll??????????
- 如何通过同一个存储过程,返回多个结果集。如能提供点范例代码,感激不尽!
- 想做一个小的月历,请问哪儿这种文章或是方法呀
- 请问如何出现菜单最左边的系统图标?以及菜单条上相应菜单项左边的图标?
- vb窗体光标自动定位到文本输入框
- 关于Setup Builder (32-bit)?
- text透明控件
- treeview的问题
Dim conn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim sql As String
Dim i As Integer
Text1.Enabled = False
Text2.Enabled = False
Text3.Enabled = False
Text4.Enabled = False
Text5.Enabled = False
Combo1.ListIndex = 1
Set conn = New ADODB.Connection
Set rs = New ADODB.Recordsetconn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\199905.mdb;Persist Security Info=False"conn.OpenIf conn.State = 0 Then MsgBox ("连接失败")'
Set rs = conn.OpenSchema(adSchemaTables)
i = 0
Do While Not rs.EOF
If rs.Fields("TABLE_TYPE") = "TABLE" Then
i = i + 1
Combo2.AddItem rs.Fields("TABLE_NAME")
End If
rs.MoveNext
Loop
Combo2.ListIndex = 1
sql = "select * from " & Combo2.Text
rs.Close
rs.CursorLocation = adUseClient
rs.Open sql, conn, adOpenKeyset, adLockOptimistic, adCmdText
If rs.State = 0 Then MsgBox ("数据库操作失败")Set dg.DataSource = rs
dg.RefreshEnd Sub
是set dg.DataSource = rs而不是dg.DataSource = rs