Large combo box

[Steve Lloyd]

Hi,

I am setting the datasource to a combobox but there datatable has over
10,000 rows and it is responding rather slowly when setting the datasource
and the display and value members. I filter the choices by filtering the
dataview as they type. Is there a better alternative?

Thanks for any help

Steve.

 

[Phil G.]

Hi Steve,

Good practice (so I've read!) is to only return the minimal amount of data
from a db that is necessary for your app.

Because you haven't given much info. I have to guess that you are returning
a complete table, ie. SELECT * FROM tblName. You then state that you are
performing filtering on the returned dataset (well, again I am assuming
because you haven't said).

A better approach would be to do a level of 'filtering' BEFORE returning the
dataset. ie. SELECT thisColumn FROM tblName. If you then need other data
associated with the selection you might use a button to get the rest.

This suggestion may be way off base, hence the need perhaps to be slightly
more descriptive so that we can help you out!

Regards, Phil