How to load ListBox with a lot of data?

[vnarod]

I am sure everyone ran into this problem at some point. Is there a good solution?
I need to show records from database in a listbox or a grid. Number of records is about 50,000 and it will take too long to load them into listbox. What is the way to do it?

 

[bpayne111]

have you considered only showing a certain number of records at a time? granted its not what you wanna do but it would speed things up

 

[Derek Stone]

Load only a portion of the records at a time. When the user reaches either end of the current list, give them the option to display the next set of records, or do so automatically. It is far too impractical to load all 50,000 records at once, and theres no reason to do so. If youre coding for a client who wants all the records shown at once give them a demo of how long itll take to display 50,000 records. Thatll shut them up.

 

[vnarod]

How will I catch when user scrolls down to load next portion?