DropDown list selection

Question

Hi

i am having two pages in my website

one in default. asp x and other is default2.aspx

In my default.aspx page i am having one country drop down list(list items are India,USA,UK)

In my default2.aspx page i am having states drop down list(list items are Andhrapardesh,Assam,Texas, California,London)

Now if i select the India in my country drop down of default page,it should be redirect to default2 page and AndhraPardesh,Assam should be display in states drop down list.

how is it possible??

Satyapriya Nayak · Answer

Normal 0 Create table area( state varchar(50) country varchar(50) ) Delhi India Orissa India Bihar India West Bengal India Maharastra India Newyork Usa California Usa Ottawa Canada Sydney Australia Perth Australia Berlin Germany

sivaram reddy · Answer

i have understood the code...can u say the table names how u have taken??

Satyapriya Nayak · Answer

Hi Sivaram Try this... Untitled Page onselectedindexchanged=DropDownList_country_SelectedIndexChanged> using System; using System.Collections; 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; namespace Country_state { 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(); } } protected void DropDownList_country_SelectedIndexChanged(object sender EventArgs e) { Response.Redirect(default2.aspx?CountryID= + DropDownList_country.SelectedValue); } } } Untitled Page using System; using System.Collections; 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; namespace Country_state { public partial class Default2 : System.Web.UI.Page { string strConnString = ConfigurationManager.ConnectionStrings[ConnectionString].ConnectionString; string strs1; SqlCommand com; protected void Page_Load(object sender EventArgs e) { DropDownList_state.Items.Clear(); SqlConnection con = new SqlConnection(strConnString); con.Open(); s1 = Request.QueryString[CountryID]; str = select * from area where country=' + s1 + '; 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

sivaram reddy · Answer

can u send me the sample code.... in my default.aspx.cs protected void ddldist_SelectedIndexChanged(object sender EventArgs e) { Response.Redirect(default2.aspx?distID= + ddldist.SelectedValue); } In my default2.aspx.cs i have written the code string strConn = ConfigurationManager.ConnectionStrings[LeaderConnectionString].ConnectionString; protected void Page_Load(object sender EventArgs e) { string district = Convert.ToString(EmptyControlCollection); if(!Page.IsPostBack) { if (Request.QueryString[distID] != null) { district = Request.QueryString[distID].ToString(); Fillmp(districtID); } } } private void Fillmp(int districtID) { SqlConnection con = new SqlConnection(strConn); SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandType = CommandType.Text; cmd.CommandText = SELECT constIDconstName FROM const1_table WHERE distID =@distID; cmd.Parameters.AddWithValue(@distID districtID); DataSet objDs = new DataSet(); SqlDataAdapter dAdapter = new SqlDataAdapter(); dAdapter.SelectCommand = cmd; con.Open(); dAdapter.Fill(objDs); con.Close(); if (objDs.Tables[0].Rows.Count > 0) { ddlconst.DataSource = objDs.Tables[0]; ddlconst.DataTextField = constName; ddlconst.DataValueField = constID; ddlconst.DataBind(); ddlconst.Items.Insert(0 --Select--); } } public int districtID { get; set; }

Gopesh Sharma · Answer

Hey You can do that by passing values to another page using query string. In the next .aspx page when you will get India just filter the result according to the value entered in the first page.