Using a combo box to populate another combobox

Question

0.00/5 (No votes)

See more:

I am using this code to populate the cmblocations combobox :

With cmbLocations
               .DataSource = dsLocations.Tables("tbl_locations")
               .DisplayMember = "location"
               .ValueMember = "id"
               .SelectedIndex = 0
           End With

I would like use the .ValueMember to query the database, then i can populate other combo box.

Posted 30-May-11 21:52pm

joseph k

Updated 30-May-11 21:53pm

walterhevedeich

v2

Add a Solution

Comments

Simon_Whale 31-May-11 4:49am

do you want the selected item to move to the new combo box? or do you have a different logic that needs to be used?

joseph k 31-May-11 5:00am

Yes, i want to use a selected item as a value to search for a record in another table called Regions, Am using its 'id' as Foregn key in table Regions , Then i load the results on another combo box

Thanks

Karwa_Vivek 31-May-11 5:19am

hi Joseph ..got the Solution ?

joseph k 31-May-11 6:33am

Yes i got the answer , Thanks very much

Karwa_Vivek 3-Jun-11 5:41am

If you Got it
here..Remember To
Mark Your Solution
So that it can help others
Also.it's Simple Just Click the Green
button.
Thanks

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

amit28august · Answer 1 · 2011-05-30T23:00:00

Solution 1

you can use string ID = cmbLocations.SelectedValue.ToString(); to get its current selected id then you can fire a database query for this id and get values for this id and assign it to another CMB.

Posted 30-May-11 23:00pm

amit28august

Comments

Simon_Whale 31-May-11 5:47am

Simple but good answer

joseph k 31-May-11 6:34am

Great i managed to nail it properly... Thanks

prem shanker verma 3-Jun-11 5:14am

right
just create a function having one argument(id) and call it on selectedIndex change, as
fillSecondCombo(ddl1.selectedValue.toString())

Savalia Manoj M · Answer 2 · 2011-06-02T23:04:00

You can try this
If cmbLocations.SelectedIndex > 0 Then
Dim dt = New DataTable
'Call DataAccess for New Result set
dt = obj.GetList(cmbLocations.SelectedValue)
With ComboBox1
.DataSource = dt
.DisplayMember = "location"
.ValueMember ="ID"
.SelectedIndex = 0
End With
End If