1,451
社区成员
发帖
与我相关
我的任务
分享
lvw.CheckBox = true
Dim xx As Long
For xx = ListView1.ListItems.Count To 1 Step -1
If ListView1.ListItems.Item(xx).Checked Then
debug.print listview1.listitems.item(xx).subitems(1) '输出选中行的第二列的内容。
End If
Next xx
Dim rs As New ADODB.Recordset
rs.Open strsql, dbConnection, adOpenKeyset, adLockReadOnly
While Not rs.EOF
Dim xitem As ListItem
Set xitem = ListView1.ListItems.Add(, "d" & CStr(rs.Fields("d_id")))
xitem.SubItems("1") = rs.Fields("s_id")
xitem.SubItems("2") = rs.Fields("d_id")
Set xitem = Nothing
rs.MoveNext
Wend
rs.Close
Set rs = Nothing