By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,641 Members | 1,446 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,641 IT Pros & Developers. It's quick & easy.

Large combo box

P: n/a
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.
Nov 21 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
"Steve Lloyd" <st****************@livenowpaylater.co.uk> wrote in message
news:u%***************@TK2MSFTNGP15.phx.gbl...
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.

Nov 21 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.