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

Populating Combo boxes from HUGE datasource (help & ideas!)

P: n/a
We have many many systems (accounts) which we need to search on. What my
initial Idea is to have a ComboBox1 populated w/ a list of all systems at
load (from Oracle table). Done and quick

But, step two, I want to populate ComboBox2 depending on the System
selection from ComboBox1 . But, the problem is, I can load the list of
'Systems' data into a dataset in just a few seconds. I did a quick test and
filled a dataset selecting everything from accounts , and it took a long
while..

Any ideas on how to proceed other than filling the DS first w/ EVERYTHING at
load..
ComboBox1 SQLServer12345

Comboxbox2 Account1
Account2
Account3
Sep 29 '08 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Sep 29, 12:42*pm, Chris <Ch...@discussions.microsoft.comwrote:
We have many many systems (accounts) which we need to search on. *What my
initial Idea is to have a ComboBox1 populated w/ a list of all systems at
load (from Oracle table). *Done and quick

But, step two, I want to populate ComboBox2 depending on the System
selection from ComboBox1 . *But, the problem is, I can load the list of
'Systems' data into a dataset in just a few seconds. *I did a quick test and
filled a dataset selecting everything from *accounts , and it took a long
while..

Any ideas on how to proceed other than filling the DS first w/ EVERYTHINGat
load..

ComboBox1 SQLServer12345

Comboxbox2 Account1
* * * * * * * * * * * *Account2
* * * * * * * * * * * *Account3
If all you're doing is populating a combobox, why not use a datareader
instead of a dataset?
Sep 29 '08 #2

P: n/a
Would you happen to have any examples w/ datareader. I'm looking into it now.

Thanks!

"za***@construction-imaging.com" wrote:
On Sep 29, 12:42 pm, Chris <Ch...@discussions.microsoft.comwrote:
We have many many systems (accounts) which we need to search on. What my
initial Idea is to have a ComboBox1 populated w/ a list of all systems at
load (from Oracle table). Done and quick

But, step two, I want to populate ComboBox2 depending on the System
selection from ComboBox1 . But, the problem is, I can load the list of
'Systems' data into a dataset in just a few seconds. I did a quick test and
filled a dataset selecting everything from accounts , and it took a long
while..

Any ideas on how to proceed other than filling the DS first w/ EVERYTHING at
load..

ComboBox1 SQLServer12345

Comboxbox2 Account1
Account2
Account3

If all you're doing is populating a combobox, why not use a datareader
instead of a dataset?
Sep 29 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.