How to use combo box selected index changed

Question

1.00/5 (1 vote)

See more:

I have five combo box in my project and i binded the first combo box with the Id column of my table and also other comboboxes with different column, and i want to use selectedindexchanged property of combo box in a way that if i change the combo box value in first combobox dropdown then the corresponding value of other column should populate in other 4 combobox. So please provide me the code for combo box in selected index changed

What I have tried:

C#

private void cbPRNo_SelectedIndexChanged(object sender, EventArgs e)
{
    SqlCommand command;
    SqlDataAdapter adapter = new SqlDataAdapter();
    DataSet ds = new DataSet();
    dlprobj.getcon();
    command = new SqlCommand("Select * from Purchase where Id='" + cbPRNo.SelectedIndex + "'", dlprobj.con);
    adapter.SelectCommand = command;
    adapter.Fill(ds);
    adapter.Dispose();
    command.Dispose();
    dlprobj.con.Close();
    cbStore.SelectedIndex = ds.Tables[0].Columns["BranchId"].ToString();

}

Posted 12-Dec-16 22:11pm

SahuA

Updated 13-Dec-16 0:31am

Ehsan Sajjad

v3

Add a Solution

Comments

F-ES Sitecore 13-Dec-16 6:40am

It's called "cascading dropdowns" so google that for sample code.

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)

$*Developer - Vaibhav*$ · Answer 1 · 2016-12-12T22:17:00

Solution 1

C#

SqlCommand command;
SqlDataAdapter adapter = new SqlDataAdapter();
DataSet ds = new DataSet();
dlprobj.getcon();
command = new SqlCommand("Select * from Purchase where Id='" + cbPRNo.SelectedIndex +
                         "'", dlprobj.con);
adapter.SelectCommand = command;
adapter.Fill(ds);
adapter.Dispose();
command.Dispose();
dlprobj.con.Close();

cbStore.DataSource = ds.Tables[0];
cbStore.ValueMember = "au_id";
cbStore.DisplayMember = "au_lname";

Posted 12-Dec-16 22:17pm

$*Developer - Vaibhav*$

Updated 13-Dec-16 0:31am

v2

Comments

SahuA 13-Dec-16 4:29am

i want to initialize the other four comboboxes with the corresponding column value of selectedindex of combobox.

$*Developer - Vaibhav*$ 13-Dec-16 4:53am

with same dataset or different?

SahuA 13-Dec-16 23:30pm

i want to change the selected index of other combo boxes as the selected index of first combo box changes

Richard MacCutchan · Answer 2 · 2016-12-12T22:19:00

Solution 2

ComboBox.SelectedIndexChanged Event (System.Windows.Forms)[^]

Posted 12-Dec-16 22:19pm

Richard MacCutchan

Comments

SahuA 13-Dec-16 4:31am

i want code to initialise all other combo boxes with the corressponding value of column

Richard MacCutchan 13-Dec-16 4:53am

i want code
Then you need to write it, this forum is not here to do your work for you.

SahuA 13-Dec-16 23:26pm

i don't want whole code but i simply want a single line that how column value initialise to other other code like:
ComboBox1.SelectedIndexChanged Event (System.Windows.Forms)[^]
{
combobox2.SelectedIndex = ds.Tables[0].Columns[5].ColumnName.ToString();
}

i currently using that but its not working.

Richard MacCutchan 14-Dec-16 3:51am

What doe "not working" mean? You know how event handling works, and you have a link to the ComboBox documentation, so all you need to do is check which methods or properties will provide the data you need to extract.