DropDown list selection

sivaram reddy

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??

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Satyapriya Nayak14y ago

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 reddy14y ago
i have understood the code...can u say the table names how u have taken??
Satyapriya Nayak14y ago
Hi Sivaram,

Try this...

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="Country_state._Default" %>

    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);
        }
    }
}

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default2.aspx.cs" Inherits="Country_state.Default2" %>

    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 str,s1;
        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 reddy14y ago
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 constID,constName 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 Sharma14y ago
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.