How to bind or populate data into a Dropdown List based on first or another Dropdown List in Asp.net C#

Question

5.00/5 (1 vote)

See more:

How to bind or populate data into a Dropdown List based on first or another Dropdown List in Asp.net C#
=======================================================================

Dear Experts !!

am working on asp.net,C#,Sqlserver2005

I have Two Dropdownlists.... Dropdownlist1 and Dropdownlist 2

In first dropdownlist it shows list of companies..... in second dropdownlist it shows Departments.

These two will comes from database.

Suppose when the user select the company from 1st dropdownlist so,in the other dropdownlist it should show related departments to that company.

Please help me how to do this.

Thanks.

Posted 9-Jun-12 1:53am

Ranjith Reddy CSE

Add a Solution

Comments

Nandakishore G N 11-Dec-12 0:49am

what have you tried ? post it.

4 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)

Dee_Bee · Answer 1 · 2012-12-10T17:31:00

You can do it easily,

Code for binding database values to company drop down :

Getting values from data base, you will have those details in ViewState["Company"] and bind to your drop down as shown in below code.

C#

ddlCompany.DataSource = ViewState["Company"];
               ddlCompany.DataTextField = "description";
               ddlCompany.DataValueField = "value";
               ddlCompany.DataBind();

To build Departments :

You will have one input field for Departments dropdown in your stored procedure,
give it the input value as

C#

cmnDetails.companyId = ddlCompany.SelectedValue;

In my code I used three tier architecture, hope you understand as I can't place all the code here. But if you need it I will post .

There is another way to solve is using Cascading dropdown concept.

Thank you

John Orendt · Answer 2 · 2012-06-09T02:00:00

Solution 1

see

AutoComplete With DataBase and AjaxControlToolkit

this is not exactly what you want, however the use of ajax is the way to go.

Posted 9-Jun-12 2:00am

John Orendt

Mits Machhi · Answer 3 · 2012-06-09T02:05:00

you can use following things:
protected void Page_Load(object sender, EventArgs e)
   {

        if (!IsPostBack)
        {
             FillDropDownList();
        }
    }

Make company drop down Auto postback true.


   private void FillDropDownList()
         {
             DataSet ds = new DataSet();
             SqlDataAdapter myda = new SqlDataAdapter("Select company  FROM Tablename", connection Object);
        myda.Fill(ds);
        drop_company.DataSource = ds;
        drop_company.DataValueField = "company";
        drop_company.DataBind();
        drop_company.Items.Insert(0, new ListItem("Select", "0"));
    }

Double click on Company`s DropDown.;
 protected void drop_company_SelectedIndexChanged(object sender, EventArgs e)
    {

        DataSet ds = new DataSet();
        SqlDataAdapter myda = new SqlDataAdapter("Select department FROM tablename where company='"+drop_company.SelectedItem.Value+"'",connection_Object);
        myda.Fill(ds);
        drop_dept.DataSource = ds;
        drop_dept.DataValueField = "department";
        drop_dept.DataBind();
        drop_dept.Items.Insert(0, new ListItem("Select", "0"));

    }


Hope This will Help You, if not please Post it.

sreeCoderMan · Answer 4 · 2012-12-10T16:18:00

Solution 3

friend this link will help you
http://www.aspdotnet-suresh.com/2010/10/how-to-populate-dropdown-based-on-other.html[^]

Posted 10-Dec-12 16:18pm

sreeCoderMan

How to bind or populate data into a Dropdown List based on first or another Dropdown List in Asp.net C#

4 solutions

Solution 4

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0