How to bind one dropdown in another ...

Question

1.00/5 (1 vote)

See more:

Problem is this.. in my project I use 3 dropdownlist and I want, If I select 1st ddl then in 2nd ddl show 1st related data and then I select 2nd show 3rd ddl data..
But I use Below Code and 2nd ddl working properly and same code is used for 3rd the they show only first select value.

What I have tried:

private void ddBindCategory()
{

ddL1.DataSource = ProductBAL.Instance.GetCatfirst();
ddL1.DataTextField = "NameL1";
ddL1.DataValueField = "IDL1";
ddL1.DataBind();
ddBindsub();

}
public void ddBindsub()
{
DataTable dt = new DataTable();
ddL2.DataSource = ProductBAL.Instance.GetCatSecond(ddL1.SelectedValue);
ddL2.DataTextField = "NameL2";
ddL2.DataValueField = "IDL2";
ddL2.DataBind();
ddBindthird();
}

public void ddBindthird()

{
ddL3.DataSource = ProductBAL.Instance.GetCatThird(ddL2.SelectedValue);
ddL3.DataTextField = "NameL3";
ddL3.DataValueField = "IDL3";
ddL3.DataBind();

}

protected void ddL1_SelectedIndexChanged(object sender, EventArgs e)
{

ddL2.DataSource = ProductBAL.Instance.GetCatSecond(ddL1.SelectedValue);
ddL2.DataTextField = "NameL2";
ddL2.DataValueField = "IDL2";
ddL2.DataBind();

}

protected void ddL2_SelectedIndexChanged1(object sender, EventArgs e)
{
ddL3.DataSource = ProductBAL.Instance.GetCatThird(ddL2.SelectedValue);
ddL3.DataTextField = "NameL3";
ddL3.DataValueField = "IDL3";
ddL3.DataBind();

}

Posted 28-Jun-16 21:03pm

Member 12556026

Updated 28-Jun-16 21:26pm

Add a Solution

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)

Satish Padnani · Answer 1 · 2016-06-28T21:11:00

ASP:

ASP.NET

<span style ="font-family:Arial">Select Continent : </span>

<asp:DropDownList ID="ddlContinents" runat="server" AutoPostBack = "true"

             OnSelectedIndexChanged="ddlContinents_SelectedIndexChanged">

<asp:ListItem Text = "--Select Continent--" Value = ""></asp:ListItem>

</asp:DropDownList>

 

<br /><br />

<span style ="font-family:Arial">Select Country : </span>

<asp:DropDownList ID="ddlCountry" runat="server" AutoPostBack = "true"

Enabled = "false"  OnSelectedIndexChanged="ddlCountry_SelectedIndexChanged">

<asp:ListItem Text = "--Select Country--" Value = ""></asp:ListItem>

</asp:DropDownList>

 

<br /><br />

<span style ="font-family:Arial">Select City : </span>

<asp:DropDownList ID="ddlCity" runat="server" AutoPostBack = "true"

 Enabled = "false" OnSelectedIndexChanged="ddlCity_SelectedIndexChanged">

<asp:ListItem Text = "--Select City--" Value = ""></asp:ListItem>

</asp:DropDownList>

 

<br /><br />

<asp:Label ID="lblResults" runat="server" Text="" Font-Names = "Arial" />

Satish Padnani · Answer 2 · 2016-06-28T21:26:00

C#

C#

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

ddlContinents.AppendDataBoundItems = true;

String strConnString = ConfigurationManager

.ConnectionStrings["conString"].ConnectionString;

String strQuery = "select ID, ContinentName from Continents";

SqlConnection con = new SqlConnection(strConnString);

SqlCommand cmd = new SqlCommand();

cmd.CommandType = CommandType.Text;

cmd.CommandText = strQuery;

cmd.Connection = con;

try

{

con.Open();

ddlContinents.DataSource = cmd.ExecuteReader();

ddlContinents.DataTextField = "ContinentName";

ddlContinents.DataValueField = "ID";

ddlContinents.DataBind();

}

catch (Exception ex)

{

throw ex;

}

finally

{

con.Close();

con.Dispose();

}

}

}

How to bind one dropdown in another ...

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0