ListView Add Item - Xtreme Visual Basic Talk

01-05-2005, 07:23 AM

woody999

Centurion

Join Date: Mar 2004

Posts: 128

ListView Add Item

Hi

No doubt a nice simple one for someone but I am trying to use the ListView to display a set of records.

Can somebody tell me how to add a value to the listview? I have a recordset and I asume I need to cycle through it adding each value to the listview - but how?

Cheers

01-05-2005, 08:10 AM

00100b

Martian In Disguise

Retired Moderator
* Guru *

Join Date: May 2003

Location: Minneapolis, MN

Posts: 9,566

One method is to iterate through the recordset and add an instance of a ListItem object to the ListItems collection of the ListView for each record. The value for the first column would be assigned to the Text argument when adding the ListItem and the values for the other columns would be added to the SubItems(n) collection. You will need to make sure that you have the ColumnHeaders defined in order to have each column available, and use the Report-View setting for the display.

Example:

Code:

Dim objListItem As ListItem

Do While Not objRecordset.EOF
    Set objListItem = Me.ListView1.ListItems.Add(Text:=objRecordset.Fields(0).Value)
    objListItem.SubItems(1) = objRecordset.Fields(1).Value
    objListItem.SubItems(2) = objRecordset.Fields(2).Value
    ' etc.
    objRecordset.MoveNext
Loop

__________________
The only stupid question is the one that goes un-asked.

01-05-2005, 08:46 AM