先在listview 里面 ,单击右键,属性,新增几个相关的列
Dim objCn As New Connection
Dim objRs As New Recordset
dim item as listitem
打开连接,打开记录集,
do while not objrs.eof
set item =listview1.listitems.add()
item.text=objrs.fields(0)
for i=1 to objrs.fislds.count-1
item.subitems(i)=objrs.fields(i)
next
objrs.movenext
loop