• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 330
  • Last Modified:

Databound LIst/Grid Control That Displays Many Records

I have an application that that uses an Access database BE, with a VB.NET FE.  I have a combo box that allows users to select a specific mailing list that relates to another table that contains the mailng list member data.  

Some mailing lists contain upward of 50,000 records.  So when the user selects a mailing list from the combo dropdown, the list control will populate with the members of the mailing list.  

With mailing lists that contain so many records it becomes very time-consuming to add that many items to the ListBox view.  

What would be the best / most efficient way to address this problem?  Perhaps a list / grid control that populates only a few records, then if the user scrolls, will dynamically add more records to the control?  I hope that makes sense.    I using vb.net 2005, but I also have 2010 version as well.  Any advise would be appreciated.
0
DRRobinson
Asked:
DRRobinson
1 Solution
 
Tony HungateDirector of TrainingCommented:
I would only list the names of the mailing list in your combo box, and only populate the large number of records when you are ready to actually send the email.  i.e. Let the user select the name of the mailing list to their hearts content, and only on lets say the on click event of a send button would I actually pull all of the records and complete the command to send or create a report/document.

At that point I would also give your user some sort of status bar, letting them know that they are sending / pulling XX,XXX number of address, and that it may take some time to complete.

This is actually a standard practice.  If you are not currently using that data for some purpose, then do have the application pull/store/ and compile all of that information.

TLH
0
 
John (Yiannis) ToutountzoglouInstructor Multiengine PilotCommented:
You may add some more search creteria just to reduce the number of records.also set another one combobox or a textbox with an autocomplete function and fire the search function only if both comboboxes  are selected...
Also The autocomplete Property is a very good search creteria ....
0
 
DRRobinsonAuthor Commented:
Yes, I've resolved myself this morning that I'll have to do exactly something like that, I guess it's just not practical to have a list box contain that many rows....

t_hungate:
I do just as you suggest in the area of the software that actually sends the mail.  This situation is in the area of the program the deals with maintaining the mailing list.

Thanks for the comments
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now