一个例子引用ado2.x Public con As Connection Public re As RecordsetSub connect() Dim path As String path = App.path If Right(path, 1) <> "/" Then path = path + "/" path = path + "db1.mdb" Set con = New Connection con.Open "provider=microsoft.jet.oledb.4.0; data source=" + path con.CursorLocation = adUseClient Set re = New Recordset End Sub If re.State = 1 Then re.Close End IfListView1.ListItems.Clear ListView1.View = lvwSmallIcon re.Open "tab1", con, adOpenDynamic, adLockBatchOptimistic If re.RecordCount > 1 Then For i = 1 To re.RecordCount ListView1.ListItems.Add , , re.Fields("id").Value & "员工", Val(re.Fields(1)), Val(re.Fields(1)) re.MoveNext Next
End If
不好意思!!end sub 下面的代码放在command1_click()中Public Sub Command1_Click() If re.State = 1 Then re.Close End IfListView1.ListItems.Clear ListView1.View = lvwSmallIcon re.Open "tab1", con, adOpenDynamic, adLockBatchOptimistic If re.RecordCount > 1 Then For i = 1 To re.RecordCount ListView1.ListItems.Add , , re.Fields("id").Value & "员工", Val(re.Fields(1)), Val(re.Fields(1)) re.MoveNext Next
有文章可参照
如果数据多的话,可以分页加。如何将数据分页,请看ADO的帮助。
可以在计算机中查找:ADO*.chm,内容很详细。
Public con As Connection
Public re As RecordsetSub connect()
Dim path As String
path = App.path
If Right(path, 1) <> "/" Then path = path + "/"
path = path + "db1.mdb"
Set con = New Connection
con.Open "provider=microsoft.jet.oledb.4.0; data source=" + path
con.CursorLocation = adUseClient Set re = New Recordset
End Sub
If re.State = 1 Then
re.Close
End IfListView1.ListItems.Clear
ListView1.View = lvwSmallIcon
re.Open "tab1", con, adOpenDynamic, adLockBatchOptimistic
If re.RecordCount > 1 Then
For i = 1 To re.RecordCount
ListView1.ListItems.Add , , re.Fields("id").Value & "员工", Val(re.Fields(1)), Val(re.Fields(1))
re.MoveNext
Next
End If
不好意思!!end sub 下面的代码放在command1_click()中Public Sub Command1_Click()
If re.State = 1 Then
re.Close
End IfListView1.ListItems.Clear
ListView1.View = lvwSmallIcon
re.Open "tab1", con, adOpenDynamic, adLockBatchOptimistic
If re.RecordCount > 1 Then
For i = 1 To re.RecordCount
ListView1.ListItems.Add , , re.Fields("id").Value & "员工", Val(re.Fields(1)), Val(re.Fields(1))
re.MoveNext
Next
End If
End Sub