Solved

Databound LIst/Grid Control That Displays Many Records

Posted on 2010-08-14
3
321 Views
Last Modified: 2013-12-26
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
Comment
Question by:DRRobinson
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 10

Expert Comment

by:t_hungate
ID: 33439513
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
 
LVL 18

Accepted Solution

by:
John (Yiannis) Toutountzoglou earned 500 total points
ID: 33440691
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
 

Author Closing Comment

by:DRRobinson
ID: 33440867
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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question