Fill a ListView control with items from a database

[Dr_Michael]

I have connected to my database and I want to fill a listview control on the form with only three fields from the Database: 1)ID, 2)CompanyName, 3)BusinessName
How can I achieve that? What is the appropriate code for that? Keep in mind that my listview control is in report mode.
The code must be something like this:

Do Until rsAllCustomers.EOF
set mItem = lsvCustomers.ListItems.Add()
'the rating is here!!! :-)
'....
Loop



Thanx and Merry Christmas!

Michael Vlastos
Automation Engineer
Company SouthGate Hellas SA
Development Department
Athens, Greece