473,746 Members | 2,360 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 1401
On Sep 29, 12:42*pm, Chris <Ch...@discussi ons.microsoft.c omwrote:
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***@construc tion-imaging.com" wrote:
On Sep 29, 12:42 pm, Chris <Ch...@discussi ons.microsoft.c omwrote:
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
1905
by: Derk | last post by:
I have to write a web page wht three combo boxes, all three are to be populated from a database. - there tables = Bulidings, Floors and Offices The user will choose a 'Building' from the first combo, once it has been selected, I need to populate the second combo box with the 'floors' of that selected building. The user will then select the floor, which in turn will then populate the office combo box for the user to select Thanks
1
2280
by: Young J. Putt | last post by:
I have what I thought was a relatively simple data situation that I can't seem to get working using ADO.NET datasets and data binding. I have an "Issues" table which records the UserID of the user that opens, closes and is assigned to the Issue. These come from the same group of users, so they are all related to a "Users" table. I have three combo boxes on a form. I set up the binding as shown below. It works when the form is loaded, but...
2
3069
by: visionstate | last post by:
Hi there, I am working on a form that uses 3 text boxes and 3 combo boxes. When any data is entered into any of these, I click a command button and this requeries a sub query in the form and displays data dependent on what has been typed in. After having trouble with populating my second combo box (I eventually populated it by putting the fields for both combo boxes in 1 separate query) I am now having problems with the 3rd one and am...
0
963
by: heimdal | last post by:
I am new to VB. I have created a combo box in Visual Basic 2005 Express. I created this by dragging a field from a datasource across to the form as a combo box. However when I run the form I get a single value only in the combo box rather than a list of all the values in that column of the datasource.
7
1852
by: Ausclad | last post by:
Ok, ill try again..... It seems fairly simple. I have two combo boxes in a datagrid. The datagrid is bound to a a table in a dataset. The two combo boxes are bound to a single data table in a different dataset. One combo box is displaying the Employees payroll ID. The other is
3
2901
by: Phil | last post by:
I've posted this a few times without any luck, hoping for some fresh ideas on this. I'm pretty certain this can be done. I've been using a micrsoft template to create a supplier database called the Inventory management database, I have changed this so that there is a link in the relationships with the suppliers so that every product entered has a specific supplier related, thats fine the main problem I've encountered is setting up the...
2
3268
by: Dave | last post by:
I have 3 tables of information feeding into 4 combo boxes on my main form (DR Form). I have as many list boxes (acting as text boxes) as there are fields in each one of the 3 tables. Once selecting from the combo box, I have all the combo boxes, using afterupdate, populating their respective list boxes. These text boxes are directly correlated to the combo box selection using SQL. Here is an example from the afterupdate event in the...
3
1838
by: =?Utf-8?B?Y2RtdW5veg==?= | last post by:
I have created a sub routine to programmatically add an indefinite number of combo boxes to a form. The combo boxes are bound in code to a view for displaying the available options. This routine works good until you add the second combo box. At that point it changes the first combo box's selected item. A third changes the second and first and so on. I've tried setting the combo box name and tag to a unique name, but that doesn't help. ...
11
3057
by: jgoodnight | last post by:
Hi, I have a form with three combo boxes: Area, Sub-Area, and Factor. I've set up the Sub-Area combo box to list only those areas that are part of the selected area. I've set up the Factor combo box to list only those factors that are part of the selected sub-area. For example, if I select area 1.0, the Sub-Area combo box displays 1.1, 1.2, and 1.3 as options. It does not show 2.1, 3.1, etc. If I select area 2.0, the Sub-Area combo box...
0
8974
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9500
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9218
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8227
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6772
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4575
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4836
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
2765
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2199
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.