先建表头: With lsw.ColumnHeaders .Add , , "课程编号", 660 .Add , , "课程名称", 1900, 2 .Add , , "课程类别", 660, 2 End With再读入: Dim Rs As New ADODB.Recordset Dim mItem As ListItem lsw.ListItems.Clear Rs.Open "SELECT * FROM Table", CnnDB, adOpenKeyset, adLockOptimistic, adCmdText If Rs.EOF And Rs.BOF Then Else Do Until Rs.EOF Set mItem = lsw.ListItems.Add(, , Rs("课程编号")) mItem.SubItems(1) = deNull(Rs("课程名称")) mItem.SubItems(2) = deNull(Rs("课程类别")) Rs.MoveNext Loop End If Rs.Close Set Rs = Nothing
With lsw.ColumnHeaders
.Add , , "课程编号", 660
.Add , , "课程名称", 1900, 2
.Add , , "课程类别", 660, 2
End With再读入:
Dim Rs As New ADODB.Recordset
Dim mItem As ListItem
lsw.ListItems.Clear
Rs.Open "SELECT * FROM Table", CnnDB, adOpenKeyset, adLockOptimistic, adCmdText
If Rs.EOF And Rs.BOF Then
Else
Do Until Rs.EOF
Set mItem = lsw.ListItems.Add(, , Rs("课程编号"))
mItem.SubItems(1) = deNull(Rs("课程名称"))
mItem.SubItems(2) = deNull(Rs("课程类别"))
Rs.MoveNext
Loop
End If
Rs.Close
Set Rs = Nothing
LV1.LabelEdit = False
LV1.FullRowSelect = True
LV1.Checkboxes = True