Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Visual Basic
Expertise: Beginner
Jul 7, 1997

Data Retrieval to a ListBox

Question:
I need to know how to retrieve multiple data and put it in a listbox. This data is also indexed to another database by it customer id. I can retrieve all data except for the list box.

Answer:
If you are retrieving this data from a database, you can simply loop through the records in the recordset and call AddItem on the list box to add each record to it. For instance:

Dim rsData as Recordset
Set rsData = db.OpenRecordset("Employees")
Do While Not rsData.EOF
   ListBox.AddItem rsData("Name")
   rsData.MoveNext
Loop
rsData.Close
DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date