can u tell me how to bind data to the dropdownlist?

Question

hi all can u tell me how to bind data to the dropdownlist box when i select STATE so and so MANDAL it shoulg reflet in another dropdownlist as i desinged database for example if i select MANDAL so and so villages should display in other dropdownlit box(4 dropdowns) STATE DISTRICT MANDAL VILLAGE IN THE ABOVE FORMAT IF I SLELECT STATE DISTRICTS SHOULD DISPLAY IN DISTRICT DROPDOWNLIST BOC SO ON.... THANKS IN ADVANCE

Sunny Sharma · Answer

Hi ANI I've found a solution for you. http://csharpdotnetfreak.blogspot.com/2009/03/populate-dropdown-based-selection-other.html Please go through this link this will achieve your purpose. Please don't forget to accept this as answer if it helps! Thanks.

Sunny Sharma · Answer

I'm glad you did it. Happy Coding :)

JAYRAM · Answer

i got it........ Thank you for spending your valuable time

Sunny Sharma · Answer

Hi ANI your code looks all good no prob. I suggest you check the select query for Fourth DDL (ddl ddlRegion) is returning values properly or please share if it gives any error. If still have problem I suggest you share your project ad I'll fix that. Thanks

JAYRAM · Answer

k...... plz check below code ..... i have four dropdowns (ddlCatogirieyddltypeddlregiondddivision) first 3 dropdown woking k but when i select option third dropdown(ddlregion) not display related values in fourth drop(dddivision) down ......plz correct my code ........ protected void BindContrydropdown() { //conenction path for database //SqlConnection con = new SqlConnection(strConnection); con.Open(); SqlCommand cmd = new SqlCommand(select * from Country con); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); con.Close(); ddlCatogiries.DataSource = ds; ddlCatogiries.DataTextField = CountryName; ddlCatogiries.DataValueField = CountryID; ddlCatogiries.DataBind(); ddlCatogiries.Items.Insert(0 new ListItem(--Select Catogiries-- 0)); ddltype.Items.Insert(0 new ListItem(--Select Type-- 0)); ddlRegion.Items.Insert(0 new ListItem(--Select SubType-- 0)); dddivision.Items.Insert(0 new ListItem(--Select SubType-- 0)); } /// /// Bind State Dropdown Based on CountryID /// /// /// protected void ddlCountry_SelectedIndexChanged(object sender EventArgs e) { int CountryID = Convert.ToInt32(ddlCatogiries.SelectedValue); //SqlConnection con = new SqlConnection(strConnection); con.Open(); SqlCommand cmd = new SqlCommand(select * from State where CountryID= + CountryID con); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); con.Close(); ddltype.DataSource = ds; ddltype.DataTextField = StateName; ddltype.DataValueField = StateID; ddltype.DataBind(); ddltype.Items.Insert(0 new ListItem(--Select Type-- 0)); if (ddltype.SelectedValue == 0) { ddlRegion.Items.Clear(); ddlRegion.Items.Insert(0 new ListItem(--Select SubType-- 0)); dddivision.Items.Clear(); dddivision.Items.Insert(0 new ListItem(--Select SubType-- 0)); } } /// /// Bind Region dropdown based on Re /// /// /// protected void ddlState_SelectedIndexChanged(object sender EventArgs e) { int StateID = Convert.ToInt32(ddltype.SelectedValue); //SqlConnection con = new SqlConnection(strConnection); con.Open(); SqlCommand cmd = new SqlCommand(select * from Region where StateID= + StateID con); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); con.Close(); ddlRegion.DataSource = ds; ddlRegion.DataTextField = RegionName; ddlRegion.DataValueField = RegionID; ddlRegion.DataBind(); ddlRegion.Items.Insert(0 new ListItem(--Select SubType-- 0)); if (ddlRegion.SelectedValue == 0) { dddivision.Items.Clear(); dddivision.Items.Insert(0 new ListItem(--Select SubType-- 0)); } } protected void ddlRegion_SelectedIndexChanged(object sender EventArgs e) { int RegionID = Convert.ToInt32(ddlRegion.SelectedValue); //SqlConnection con = new SqlConnection(strConnection); con.Open(); SqlCommand cmd = new SqlCommand(select * from Sregion where RegionID= + RegionID con); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); con.Close(); dddivision.DataSource = ds; dddivision.DataTextField = Sregionname; dddivision.DataValueField = Sregionid; dddivision.DataBind(); dddivision.Items.Insert(0 new ListItem(--Select SubType-- 0));

Sunny Sharma · Answer

Hi ANI  ToolkitScriptManager is the obsolete version of ScriptManager so if you already have included a ScriptManager then there's no need to add another. Please share your project should you still have any problem :)

Sunny Sharma · Answer

well... that's your homework ANI :)

JAYRAM · Answer

thanx...........i have 4 dropdowns(countrystatedistmandal) but above have only 3 dropdown(countrystatecity)......????

JAYRAM · Answer

k ... i got error another application .. when i add below code added to the page..... error................ Only one instance of a ScriptManager can be added to the page.