set dropdownbox value which affect on other dropdown

[KIDYA]

Hello experts, I want to do is,i have 2 dropdownboxes having names like Country and states ,when i select country then state dropdown box must give respective country's states.Give me way or logic to do this.....

[Gamzun]

Why don't you try little bit harder, I know you can do it :) it's easy

[deepseeindeepsy]

Hi Kemya, You can do this using design time & coding. Which u want to prefer...? :) Its deepak. So..Whats Your Rashi?

[KIDYA]

Hi Deepak, I done my design work but how will do this by coding,Do uhave any idia? For this i have to make table which contain field like country and state? suggest me proper way!!

[KIDYA]

Hello sir!! I got little bit idea , i dont knw its true or wrong? its like i can use onchange event of dropdownbox and sql query.....for sql query i required table having fields country and states... Is it right way?

[deepseeindeepsy]

Hi kemu... Just give ur email id. Or koin me on G-talk. I will give u straight forward code for it. OK Sir... :)

[Gamzun]

Yes absolutely.

[KIDYA]

smartkidya@rediffmail.com Thanx!!

[deepseeindeepsy]

Sent.. :laugh:

[Nishant Singh]

Simplest option would be use UpdatePanel put both dropDowns in Update panel , and just write the normal code (ie:- Server side code on Selected Index Change Event of Country DropDown)

[April Fans]

namespace WebApplicationDlh { using System; using System.Data; using System.Drawing; using System.Web; using System.Web.UI.WebControls; using System.Web.UI.HtmlControls; using System.Data.SqlClient; using Db; /// <summary> /// Area /// </summary> public class Area : System.Web.UI.UserControl { protected System.Web.UI.WebControls.DropDownList ddlProvince; protected System.Web.UI.WebControls.DropDownList ddlCity; public string strProvince { get { return ddlProvince.SelectedItem.Value; } set { ddlProvince.SelectedItem.Value = value; } } public string strCity { get { return ddlCity.SelectedItem.Value; } set { ddlCity.SelectedItem.Value = value; } } private void Page_Load(object sender, System.EventArgs e) { if(!IsPostBack) { ddlProvinceBind(); ddlCity.Items.Insert(0,"-City to choose-"); } } private void ddlProvinceBind() { Db.Area myArea = new Db.Area(); SqlDataReader dr = myArea.GetAllProvince(); if(dr.Read()) { ddlProvince.DataSource = dr; ddlProvince.DataTextField = "Province"; ddlProvince.DataValueField = "Province"; ddlProvince.DataBind(); ddlProvince.Items.Insert(0,"-Province to choose-"); } } #region Web override protected void OnInit(EventArgs e) { // // CODEGEN: // InitializeComponent(); base.OnInit(e); } /// <summary> /// /// /// </summary> private void InitializeComponent() { this.ddlProvince.SelectedIndexChanged += new System.EventHandler(this.ddlProvince_SelectedIndexChanged); this.Load += new System.EventHandler(this.Page_Load); } #endregion private void ddlProvince_SelectedIndexChanged(object sender, System.EventArgs e) { if(ddlProvince.SelectedItem.Value == "-Province to choose-") { ddlCity.Items.Clear(); ddlCity.Items.Insert(ddlProvince.SelectedIndex,"-City to choose-"); } else { Db.Area myArea = new Db.Area(); SqlDataReader dr = myArea.GetAllCityWhereProvince(ddlProvince.SelectedItem.Value); if(dr.Read()) { ddlCity.DataSource = dr; ddlCity.DataTextField = "City"; ddlCity.DataValueField = "ID"; ddlCity.DataBind(); } } } } } =============================================================〉 using System; using System.Data; using System.Data.SqlClient; using System.Configuration; namespace Db { /// <summary> /// Area /// </summary> public class Area:Base { public Area() { // // TODO: // } public SqlDataReader GetAllProvince() {