Based on Drop down list selection fill another dropdownlist

Question

0.00/5 (No votes)

See more:

How to fill a second dropdownlist based on the selection made in the first one.
i want to use a condition:
for example:

protected void dropdownlist1_SelectedIndexChanged(object sender, EventArgs e)
       {

           if (dropdownlis1t.SelectedValue == "1")
           {
               SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings[""].ConnectionString);
               con.Open();

               SqlCommand cmd = new SqlCommand("Select [Code] from Table where Index= '3' OR Index= '2'", con);
               SqlDataAdapter da = new SqlDataAdapter(cmd);
               DataSet ds = new DataSet();
               da.Fill(ds);
               con.Close();
               dropdownlist2.DataSource = ds;
               dropdownlist2.DataTextField = "Code";
               dropdownlist2.DataValueField = "Code";
               dropdownlist2.DataBind();

           }
           else
               if (dropdownlist1.SelectedValue == "2")
               {

                   SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings[""].ConnectionString);
                   con.Open();

                     SqlCommand cmd = new SqlCommand("Select [Code] from Table where Index= '1'", con);
               SqlDataAdapter da = new SqlDataAdapter(cmd);
               DataSet ds = new DataSet();
               da.Fill(ds);
               con.Close();
               dropdownlist2.DataSource = ds;
               dropdownlist2.DataTextField = "Code";
               dropdownlist2.DataValueField = "Code";
               dropdownlist2.DataBind();
               }

Posted 18-Jan-13 10:16am

lovitaxxxx

Add a Solution

Comments

Richard C Bishop 18-Jan-13 16:19pm

Does your example not work?

lovitaxxxx 18-Jan-13 16:31pm

noo
the second dropdownlist doesnt take any value
remains empty

Richard C Bishop 18-Jan-13 16:48pm

In your sqlcommand, you need to remove the single tick marks from the numbers in the where clause. Your dropdownlist2 was not getting any data because your query is bad is my guess. Try that and let me know. "Select [code] from table where Index = 1;"

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)

Nandakishore G N · Answer 1 · 2013-01-18T17:33:00

according to your code..the values does not populate to the dropdownlist.

C#

dropdownlist2.DataTextField = "Code";
                dropdownlist2.DataValueField = "Code";

because, it will not hold the values but it just assigns the values to the
dropdownlist textfield and value field.

to populate.this is one of the method

prepare the dataset;
dataset dv;

int n = dv.Tables["tblcountry"].Rows.Count;

     DropDownList.Items.Clear();
     DropDownList.Items.Add("--Select--");

     for (int i = 0; i <= n - 1; i++)
     {
         DropDownList.DataSource = dv;
         ListItem li = new ListItem();
         li.Text = dv.Tables["tblcountry"].Rows[i][1].ToString();
         li.Value = dv.Tables["tblcountry"].Rows[i][0].ToString();
         DropDownList.Items.Add(li);
     }

it works try this method.

Bassofa · Answer 2 · 2013-01-18T11:07:00

Solution 1

I think you need to perform a callback whenever, the first drop down changes. It's being a long time I wrote code to do that. This link could be helpful.
http://support.microsoft.com/kb/910450[^]

Posted 18-Jan-13 11:07am

Bassofa