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

[=?Utf-8?B?Q2hyaXM=?=]

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

[zacks]

On Sep 29, 12:42*pm, Chris <[e-mail]:

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?

[=?Utf-8?B?Q2hyaXM=?=]

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 <[e-mail]:

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?