with rsrecordset '循环记录集
while not.eof
inti=inti+1 '行数
listview.listitem.add,,,0 '增加新行
listview.listitem(inti).subitem(1)=rsrecordset.field(0) '写入记录
listview.listitem(inti).subitem(1)=rsrecordset.field(1)
listview.listitem(inti).subitem(1)=rsrecordset.field(2)
.movenext
wend
end with
这样就应该很详细了
Private Sub Command1_Click()
Me.ProgressBar1.Max = Data1.Recordset.RecordCount
Totel = Data1.Recordset.RecordCount
Data1.Caption = Totel
Set Val = Data1.Recordset
Do While Val.EOF = False
Max = Max + 1
Me.ProgressBar1.Value = Max
With ListView1.ListItems.Add()
For intX = 0 To 4
If intX = 0 Then
.Text = Data1.Recordset.Fields(0).Value
Else
.SubItems(intX) = Data1.Recordset.Fields(intX).Value
End If
Next
Data1.Recordset.MoveNext
End With
Loop
End Sub
比如DataGrid,里面有个属性DataSource,可以作为数据源,当然了,这需要写各类来实现
=====================================
可以提示一下
dim lst as listitem
set lst=listview1.listitems.add()
具体参数我就不写了,实际上在数据库中里面的表的主键作index,内容作text
需要引用ADO.....