RE:Ciclo for con ADO y ListView
A ver si te ayuda de algo:
Private Sub Command1_Click()
Dim i As Integer
Dim conn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim sSql As String
Dim Cont As Integer
Cont = 1
Set conn = New ADODB.Connection
Set rs = New ADODB.Recordset
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\database.mdb;Persist Security Info=False"
conn.Open
sSql = "select * from tabla"
rs.Open sSql, con, adOpenForwardOnly, adLockReadOnly
rs.MoveFirst
list.ColumnHeaders.Add , , "ID"
list.ColumnHeaders.Add , , "Descripcion"
list.ColumnHeaders.Add , , "Cantidad"
While Not rs.EOF
list.ListItems.Add , , rs("campo_id")
list.ListItems.Item(Cont).ListSubItems.Add , , rs
("campo_descripcion")
list.ListItems.Item(Cont).ListSubItems.Add , , rs
("campo_cantidad")
Cont = Cont + 1
rs.MoveNext
Wend
End Sub
o sea para la ´primer columna se utiliza el list.ListItems.Add
y para las demas columnas se utiliza list.ListItems.Item(Cont).ListSubItems.Add
suerte
NdeR: Con ayuda de Tony