Public Class Form1
Dim conn As ADODB.Connection
Dim rs As ADODB.Recordset
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
conn = New ADODB.Connection()
rs = New ADODB.Recordset()
With conn
.Provider = "Microsoft.Jet.Oledb.4.0"
.Open("employee_data.mdb")
End With
rs.Open("select * from 商品库存", conn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockPessimistic)
Dim column_count As Single = rs.Fields.Count
Dim count_row As Single = rs.RecordCount
ListView1.GridLines = True
For i As Single = 0 To column_count - 1
ListView1.Columns.Add(rs.Fields(i).Name, 70)
Next i
ListView1.Items.Clear()
For i As Integer = 1 To count_row
ListView1.Items.Add(rs.Fields(0).Value)
For j As Integer = 1 To column_count - 1
ListView1.Items(i).SubItems(j) = rs.Fields(j)
Next
rs.MoveNext()
Next
conn = Nothing
rs = Nothing
End Sub
End Class
![]()