Populate Dropdown

Question

Hi

How is it possible to create dropdown options on the basis of another dropdown. For e.g i have 1 dropdown which lists the name of countries , i wan on the basis of country selected , list of cities of that country should appear in dropdown.

Thanks

Alex Asi · Answer

Yes it is possible here is a tutorial that you are looking for http://www.magic-dev.com/ajax-filtering-cities-based-on-countries-selection.htm

Jagjit Saini · Answer

Hi Satya My requirement was not actually same that was e.g. I have created 1 dropdown in which i have listed Locations . On the basis of selection of Location  i want to display Offices in that location . I want this through Javscript or Json or Jquery. Thanks

Satyapriya Nayak · Answer

Hi Jagjit  If you need in javascriptHere is your solution i have attached. Thanks If this post helps you mark it as answer

Satyapriya Nayak · Answer

Hi Jagjit Here is your solution using asp.net(c#) Default.aspx code Untitled Page onselectedindexchanged=DropDownList_country_SelectedIndexChanged> 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