Passing the result of a comboBox to another comboBox

Question

2.33/5 (3 votes)

See more:

Hi, Im new hear and could do with a bit of help. I have not managed to find this info anywhere and stumbled accross this community which seems to have some very helpful memebers!

I have an application with a comboBox populated with data from a database, I need the selection to then populate another comboBox with the appropriate data for example:

comboBox 1 has a number of food types i.e. Tinned, Fresh, Meat

if a user selected Tinned, comboBox 2 would be populated with all the tinned food contained within the database.

I hope i've explained that well enough! I appreciate any help immensly as I have been struggling with this for a few days now!

Thanks in advance,

Dan

Posted 22-May-11 15:40pm

DanHodgson88

Add a Solution

1 solution

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)

CS2011 · Accepted Answer · 2011-05-22T16:58:00

i can definitely help you with concept but except to me write complete code for you. Here is how you can do it

1. Load the data into first combobox on form load or any other event you like(say click of a button etc).

2.There is a even associated with combobox call "onSelectedIndexChange". On this even of combobox1 write the code which will pull the data based on selection made in combobox1. your query will look something like this

select column_name from tablename where index_comuln='"+combobox1.text+"'"

and then bound the result to combobox2.

P.S Do not copy paste this query. This will not work