Dropdownlist slection chanaged with two ddl in asp.net

Question

Hi Kindly share source code there is two dropdownlist one is state another is dist--- want to show when select first dropdownlist state then show all dist of state--in C#.asp.net--with Sql server Ex--State--delhi then show all dist/town--south exlajpatnagerashokvihar select ddl1-delhi then show in ddl2 south ex lahpatnagar ashokvihar Thanks

Prabhakar Reddy · Answer

Hi Ravi this is the code for double dropdown listand i developed on asp.net user control(.ascx page) and u need to change YPMainMenu as state and YPSubMenu as city. i hope it will work surely Private con As New OleDbConnection(Keep ur database path here) Protected Sub Page_Load(ByVal sender As Object ByVal e As EventArgs) con.Open() If Not IsPostBack Then BindYPMainMenu() End If End Sub ''' ''' Bind COuntrydropdown ''' Protected Sub BindYPMainMenu() 'conenction path for database Dim con As New OleDbConnection(Keep ur database path here) 'con.Open() Dim cmd As New OleDbCommand(select * from yellopageids1 ORDER BY YELLOPAGESNAME ASC  con) Dim da As New OleDbDataAdapter(cmd) Dim ds As New DataSet() da.Fill(ds) con.Close() YPMainMenu.DataSource = ds YPMainMenu.DataTextField = YELLOPAGESName YPMainMenu.DataValueField = YPID YPMainMenu.DataBind() YPMainMenu.Items.Insert(0 New ListItem(--Select-- 0)) 'YPSubMenu.Items.Insert(0 New ListItem(--Select-- 0)) If YPMainMenu.SelectedValue = 0 Then YPSubMenu.Items.Clear() YPSubMenu.Items.Insert(0 New ListItem(--Select-- 0)) End If End Sub ''' ''' Bind State Dropdown Based on CountryID ''' ''' ''' Protected Sub YPMainMenu_SelectedIndexChanged(ByVal sender As Object ByVal e As EventArgs) Dim YPID As Integer = Integer.Parse(YPMainMenu.SelectedValue) 'Dim con As New OleDbConnection() 'con.Open() Dim cmd As New OleDbCommand(select YPSUBMENUIDSUBYELLOPAGESPageLink from yellopageids2 where YPID= & YPID Me.con) Dim da As New OleDbDataAdapter(cmd) Dim ds As New DataSet() da.Fill(ds) 'con.Close() YPSubMenu.DataSource = ds YPSubMenu.DataTextField = SUBYELLOPAGES YPSubMenu.DataValueField = PageLink YPSubMenu.DataBind() YPSubMenu.Items.Insert(0 New ListItem(--Select-- 0)) End Sub Protected Sub YPSubMenu_SelectedIndexChanged(ByVal sender As Object ByVal e As System.EventArgs) Dim str As String str = YPSubMenu.SelectedValue str = str.Replace(# ) 'Result.Text = str Response.Redirect(str) End Sub Category : onselectedindexchanged=YPMainMenu_SelectedIndexChanged> Sub Category : onselectedindexchanged=YPSubMenu_SelectedIndexChanged>

Satyapriya Nayak · Answer

Hi Ravi Try this... Normal 0 Default.aspx code @ Page Language =C# AutoEventWireup =true CodeFile =Default.aspx.cs Inherits =_Default %> DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd> html xmlns =http://www.w3.org/1999/xhtml> head runat =server> title > Untitled Page title > head > body > form id =form1 runat =server> div > br /> asp : Label ID =Label3 runat =server Text =Country Width =100px> asp : Label > asp : DropDownList ID =DropDownList_country runat =server AutoPostBack =True onselectedindexchanged =DropDownList_country_SelectedIndexChanged> asp : DropDownList > br /> asp : Label ID =Label2 runat =server Text =State Width =100px> asp : Label > asp : DropDownList ID =DropDownList_state runat =server> asp : DropDownList > div > form > body > html > Default.aspx.cs code using System; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; public partial class _Default : System.Web.UI. Page { string strConnString = ConfigurationManager .ConnectionStrings[ ConnectionString ].ConnectionString; string str; SqlCommand com; protected void Page_Load( object sender EventArgs e) { SqlConnection con = new SqlConnection (strConnString); if (!IsPostBack) { DropDownList_country.Items.Add( Choose country ); con.Open(); str = select country from area group by country ; com = new SqlCommand (str con); SqlDataReader reader = com.ExecuteReader(); while (reader.Read()) { DropDownList_country.Items.Add(reader[ country ].ToString()); } reader.Close(); con.Close(); } DropDownList_state.Items.Clear(); } protected void DropDownList_country_SelectedIndexChanged( object sender EventArgs e) { SqlConnection con = new SqlConnection (strConnString); con.Open(); str = select * from area where country=' + DropDownList_country.SelectedItem.Text + ' ; com = new SqlCommand (str con); SqlDataReader reader = com.ExecuteReader(); while (reader.Read()) { DropDownList_state.Items.Add(reader[ state ].ToString()); } reader.Close(); con.Close(); } } Thanks If this post helps you mark it as answer

Santhosh Kumar Jayaraman · Answer

Try this: First make AutoPostBack true Property in state Dropdown then in page load : if (!ispostback) { FillDropDownList(); } ------> private void FillDropDownList() { DataSet ds = new DataSet(); SqlDataAdapter myda = new SqlDataAdapter( select statename from state connection object ); myda.Fill(ds); drop_state.DataSource = ds; drop_state.DataValueField = statename ; drop_state.DataBind(); } and double click on Drop_state Dropdown protected void drop_state_SelectedIndexChanged( object sender EventArgs e) { DataSet ds = new DataSet(); SqlDataAdapter myda = new SqlDataAdapter( select districtname from districts where statename=' +Drop_state.SelectedValue.ToString()+ '  connection object ); myda.Fill(ds); drop_district.DataSource = ds; drop_district.DataValueField = districtname ; drop_district.DataBind(); }