how to get relative value in combobox using other combobox in windows form

Question

0.00/5 (No votes)

See more:

i have 3 combobox(item name,brand name,price) but item name can be several brands and each brand has different price. now i want to do that, when user select item name using first combobox then it shows it's appropriate brand in second combobox. and when user select brand name using second combobox then it shows it's price in third combobox.
suppose i have item jeans and it has 5 brands(lee,levise,coutons,cotton county,liver pool) each brand has it's different price(999,1099,1599,2000,2599).
when user select brand=jeans using combobox1 then it shows 5 brands(lee,levise,coutons,cotton county,liver pool) in combobox2 and when user select brand name lee then price should be shown 999 and when user select liver pool then price should be shown 2599 and so on..... in combobox.
what should i do??????
plz help me
thankyou......

Posted 30-Oct-13 21:16pm

arvindnitin7

Add a Solution

Comments

BillWoodruff 2-Nov-13 6:19am

Are you accessing a database to get the information that goes into the ComboBoxes ?

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)

Animesh Datta · Answer 1 · 2013-10-30T21:24:00

Solution 1

Hello ,

try this example..

Cascading ComboBox In Winforms Windows Forms C# VB.NET

thanks
animesh

Posted 30-Oct-13 21:24pm

Animesh Datta

Comments

rohith naik 31-Oct-13 4:03am

Answers it the best !

Member 9822231 · Answer 2 · 2013-11-01T19:19:00

Try this.
let you have three combobox ddl1 ,ddl2 and ddl3(for item,brand and price respectively.)

write codes(making a separate function fillItemName() ) to fetch data(item name) from database and bind it with ddl1. you must call this function in page_load event.

write codes in ddl1_selectedIndexChanged() to fetch data(brandname) from database using where clause in Query and bind it with ddl2.

write codes in ddl2_selectedIndexChanged() to fetch data(price) from database using where clause in Query and bind it with ddl3(OR write ddl3.Text = ds.Tables[0].rows[0][0].ToString()).

if it works, let me know.