代码如下:
Private Sub Command1_Click()'定义ado变量
Dim adocon As Connection'打开数据库
Set adocon = New Connection
adocon.CursorLocation = adUseClient
adocon.Open "Provider=Microsoft.jet.OLeDB.4.0;Data Source=" & App.Path & "\dbmy.mdb;"'读取数据库内储存的名字
Dim rsado0 As New ADODB.Recordset
rsado0.Open "select name from db1", adocon'在list表中列出名字
Dim m
-----------------------------------
m = rsado0.Count(错在这里!count)
-----------------------------------
For i = 1 To m
List1.List(m - 1) = rsado(m - 1)
NextEnd Sub
=========================================================================
报错:未找到方法或数据成员
=========================================================================
问题:我想知道我建立的数据集合rsado0一共有多少项并把它们一一列出,应该用什么方法?
=========================================================================
大虾们教我,谢谢,谢谢~~~~
Private Sub Command1_Click()'定义ado变量
Dim adocon As Connection'打开数据库
Set adocon = New Connection
adocon.CursorLocation = adUseClient
adocon.Open "Provider=Microsoft.jet.OLeDB.4.0;Data Source=" & App.Path & "\dbmy.mdb;"'读取数据库内储存的名字
Dim rsado0 As New ADODB.Recordset
rsado0.Open "select name from db1", adocon'在list表中列出名字
Dim m
-----------------------------------
m = rsado0.Count(错在这里!count)
-----------------------------------
For i = 1 To m
List1.List(m - 1) = rsado(m - 1)
NextEnd Sub
=========================================================================
报错:未找到方法或数据成员
=========================================================================
问题:我想知道我建立的数据集合rsado0一共有多少项并把它们一一列出,应该用什么方法?
=========================================================================
大虾们教我,谢谢,谢谢~~~~
Dim adocon As Connection
'打开数据库
Set adocon = New Connection
adocon.CursorLocation = adUseClient
adocon.Open "Provider=Microsoft.jet.OLeDB.4.0;Data Source=" & App.Path & "\dbriver.mdb;"
'读取数据库内储存的河段的名字
Dim rsado0 As New ADODB.Recordset
rsado0.Open "select name from db1", adocon
'在list表中列出河段的名字
Dim m
m = 0
Do While Not rsado.EOF
List1.List(m) = rsado(m)
m = m + 1
LoopEnd Sub
2)Do While Not rsado.EOF
List1.List(m) = rsado(m)
m = m + 1
rsado.MoveNext
Loop
改一下这里就应该可以了。rsado0.Open "select name from db1", adocon,adOpenKeyset
Private Sub Command1_Click()'定义ado变量
Dim adocon As Connection
'打开数据库
Set adocon = New Connection
adocon.CursorLocation = adUseClient
adocon.Open "Provider=Microsoft.jet.OLeDB.4.0;Data Source=" & App.Path & "\dbriver.mdb;"
'读取数据库内储存的河段的名字
Dim rsado0 As New ADODB.Recordset
rsado0.Open "select name from db1", adocon
'在list表中列出字段的名字
Do While Not rsado.EOF
List1.AddItem rsado.fields(0)
rsado.movenext
Loop
rsado.close
adocon.close
End Sub就这样就可以了~~~~~~~~~~~~~~~