469,934 Members | 1,543 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,934 developers. It's quick & easy.

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

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
2 1294
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
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.

Similar topics

2 posts views Thread by Derk | last post: by
reply views Thread by heimdal | last post: by
7 posts views Thread by Ausclad | last post: by
3 posts views Thread by Phil | last post: by
3 posts views Thread by =?Utf-8?B?Y2RtdW5veg==?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.