Dropdowm did not show the value of next one

selvi subramanian

14y1.9k.NET

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="list.aspx.cs" Inherits="list" %>

Untitled Page

onselectedindexchanged="DropDownList1_SelectedIndexChanged">
onselectedindexchanged="DropDownList2_SelectedIndexChanged">

Coding
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;

public partial class list : System.Web.UI.Page
{

Class1 cls = new Class1();
DataSet ds = new DataSet();

protected void Page_Load(object sender, EventArgs e)
{

if (!IsPostBack)
{
sel();
}
}

private void sel()
{
DataSet ds = new DataSet();
ds = cls.getds("select State,StateId from State");
ListItem li = new ListItem();
li.Value = "0";
li.Text = "-Select-";
DropDownList1.Items.Add(li.ToString());

foreach (DataRow dr in ds.Tables[0].Rows)
{
ListItem li1 = new ListItem();
li1.Text = dr["State"].ToString();
DropDownList1.Items.Add(li1.ToString());

}

}

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
DropDownList2.Items.Clear();
DataSet ds = new DataSet();
ds = cls.getds("select City,CityId from City where StateId='" + DropDownList1.SelectedIndex.ToString() + "'");
ListItem li3 = new ListItem();
li3.Value = "0";
DropDownList2.Items.Add(li3.ToString());
foreach (DataRow dr in ds.Tables[0].Rows)
{
ListItem li2 = new ListItem();
li2.Value = dr["CityId"].ToString();
li2.Text = dr["City"].ToString();
DropDownList2.Items.Add(li2.ToString());

}
}
protected void DropDownList2_SelectedIndexChanged(object sender, EventArgs e)
{
DropDownList3.Items.Clear();
DataSet ds = new DataSet();
ds = cls.getds("select Location,LocationId from Location where CityId='" + DropDownList2.SelectedIndex.ToString() + "'");
ListItem li7 = new ListItem();
li7.Text = "-select";
li7.Value = "0";
DropDownList3.Items.Add(li7.ToString());
foreach (DataRow dr in ds.Tables[0].Rows)
{
ListItem li8 = new ListItem();
li8.Value = dr["LocationId "].ToString();
li8.Text = dr["Location"].ToString();
DropDownList3.Items.Add(li8.ToString());

}
}
}

12 Replies

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

Satyapriya Nayak14y ago
Accepted answer
Hi Selvi,

Try this...

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

    Untitled Page










                              ForeColor="Red" Width="100px">
                                 AppendDataBoundItems="true" runat="server" Height="20px" Width="156px"
                   onselectedindexchanged="ddlcountry_SelectedIndexChanged" Font-Bold="True"
                   ForeColor="#FF9900">











                  ForeColor="Red" Width="100px">
                    AppendDataBoundItems ="true" runat="server" Height="20px"
Width="155px" onselectedindexchanged="ddlstate_SelectedIndexChanged" Font-Bold="True"
             ForeColor="#993300">










                ForeColor="Red" Width="100px">
                  runat="server" Height="20px" Width="155px" Font-Bold="True" ForeColor="#CCCC00">









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_city
{
    public partial class _Default : System.Web.UI.Page
    {
        string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
        string str;
        SqlCommand com;
        SqlDataAdapter sqlda;
        DataSet ds;

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                bindcountry();
            }
        }

        protected void ddlcountry_SelectedIndexChanged(object sender, EventArgs e)
        {
            bindstate();
        }

        protected void ddlstate_SelectedIndexChanged(object sender, EventArgs e)
        {
            bindcity();
        }

        public void bindcountry()
        {
            SqlConnection con = new SqlConnection(strConnString);
            con.Open();
            str = "select CountryId,CountryName from Country";
            com = new SqlCommand(str, con);
            sqlda = new SqlDataAdapter(com);
            ds = new DataSet();
            sqlda.Fill(ds, "Country");
            ddlcountry.Items.Clear();
            ddlcountry.Items.Add("--Select--");
            ddlcountry.DataValueField = "CountryId";
            ddlcountry.DataTextField = "CountryName";
            ddlcountry.DataSource = ds;
            ddlcountry.DataMember = "Country";
            ddlcountry.DataBind();
            con.Close();
        }
        public void bindstate()
        {
            SqlConnection con = new SqlConnection(strConnString);
            con.Open();
            str = "select StateId,StateName from State where Country_Id='" + ddlcountry.SelectedValue + "'";
            com = new SqlCommand(str, con);
            sqlda = new SqlDataAdapter(com);
            ds = new DataSet();
            sqlda.Fill(ds, "State");
            ddlstate.Items.Clear();
            ddlstate.Items.Add("--Select--");
            ddlstate.DataValueField = "StateId";
            ddlstate.DataTextField = "StateName";
            ddlstate.DataSource = ds;
            ddlstate.DataMember = "State";
            ddlstate.DataBind();
            con.Close();
        }
        public void bindcity()
        {
            SqlConnection con = new SqlConnection(strConnString);
            con.Open();
            str = "select CityId,CityName from City where State_Id ='" + ddlstate.SelectedValue + "'";
            com = new SqlCommand(str, con);
            sqlda = new SqlDataAdapter(com);
            ds = new DataSet();
            sqlda.Fill(ds, "City");
            ddlcity.Items.Clear();
            ddlcity.Items.Add("--Select--");
            ddlcity.DataValueField = "CityId";
            ddlcity.DataTextField = "CityName";
            ddlcity.DataSource = ds;
            ddlcity.DataMember = "City";
            ddlcity.DataBind();
            con.Close();
        }

    }
}

Thanks
If this post helps you mark it as answer
0
Kunal Vaishya14y ago
try this

ddl2.Items.Add(New ListItem(dr["Location"].ToString(), dr["LocationId "].ToString()))
0
selvi subramanian14y ago
thanks both of them .... thank u very much senthil
0

Senthilkumar14y ago

Hi Selvi,

Database Design:

CREATE TABLE States

(

iStateID INT IDENTITY(1,1) PRIMARY KEY,

StateName VARCHAR(100),

CreatedDate DATETIME DEFAULT GETDATE()

)

INSERT INTO States(StateName) VALUES('Assam')

INSERT INTO States(StateName) VALUES('Bihar')

INSERT INTO States(StateName) VALUES('Maharastra')

INSERT INTO States(StateName) VALUES('Punjab')

INSERT INTO States(StateName) VALUES('Karnataka')

INSERT INTO States(StateName) VALUES('Tamilnadu')

INSERT INTO States(StateName) VALUES('Kerala')

INSERT INTO States(StateName) VALUES('Puduchery')

CREATE TABLE Districts

(

iDistrictID INT IDENTITY(1,1) PRIMARY KEY,

iStateID INT REFERENCES States(iStateID),

DistrictName VARCHAR(100),

CreatedDate DATETIME DEFAULT GETDATE()

)

INSERT INTO Districts(iStateID,DistrictName) VALUES(6,'Chennai')

INSERT INTO Districts(iStateID,DistrictName) VALUES(6,'Madurai')

INSERT INTO Districts(iStateID,DistrictName) VALUES(6,'Coimbatore')

INSERT INTO Districts(iStateID,DistrictName) VALUES(6,'Erode')

INSERT INTO Districts(iStateID,DistrictName) VALUES(6,'Salem')

INSERT INTO Districts(iStateID,DistrictName) VALUES(6,'Trichy')

INSERT INTO Districts(iStateID,DistrictName) VALUES(6,'Tirunelveli')

INSERT INTO Districts(iStateID,DistrictName) VALUES(6,'Kanyakumari')

INSERT INTO Districts(iStateID,DistrictName) VALUES(6,'Vellore')

INSERT INTO Districts(iStateID,DistrictName) VALUES(6,'Dindugal')

CREATE TABLE Cities

(

iCityID INT IDENTITY(1,1) PRIMARY KEY,

iDistrictID INT REFERENCES Districts(iDistrictID),

CityName VARCHAR(100),

CreatedDate DATETIME DEFAULT GETDATE()

)

INSERT INTO Cities(iDistrictID,CityName) VALUES(1,'Numgambakam')

INSERT INTO Cities(iDistrictID,CityName) VALUES(1,'Vadapalani')

INSERT INTO Cities(iDistrictID,CityName) VALUES(1,'Adyar')

INSERT INTO Cities(iDistrictID,CityName) VALUES(1,'Velachery')

INSERT INTO Cities(iDistrictID,CityName) VALUES(1,'Thiruvanmiyur')

.aspx design:

Select a state:	Height="16px" onselectedindexchanged="dllState_SelectedIndexChanged" Width="172px">
Select a District:	Height="16px" onselectedindexchanged="ddlDistricts_SelectedIndexChanged" Width="170px">
Select a City:	onselectedindexchanged="ddlCity_SelectedIndexChanged" Width="170px">
LandMark:

In code file:

protected void Page_Load(object sender, EventArgs e)

{

if (!Page.IsPostBack)

{

LoadStates();

}

protected void dllState_SelectedIndexChanged(object sender, EventArgs e)

{

if (ddlState.SelectedIndex > -1)

{

LoadDistricts();

}

protected void ddlDistricts_SelectedIndexChanged(object sender, EventArgs e)

{

if (ddlDistricts.SelectedIndex > -1)

{

Loadcities();

}

protected void ddlCity_SelectedIndexChanged(object sender, EventArgs e)

{

}

private void LoadStates()

{

ListItem listItem = new ListItem();

DataSet dataSet = RetrieveDataSets("SELECT * FROM states");

ddlState.DataSource = dataSet.Tables[0];

ddlState.DataTextField = dataSet.Tables[0].Columns["StateName"].ToString();

ddlState.DataValueField = dataSet.Tables[0].Columns["iStateID"].ToString();

ddlState.DataBind();

listItem.Text = "--Select--";

ddlState.Items.Insert(0, listItem);

}

private void LoadDistricts()

{

ddlDistricts.Items.Clear();

ListItem listItem = new ListItem();

DataSet dataSet = RetrieveDataSets("SELECT * FROM Districts WHERE iStateID='"+ddlState.SelectedItem.Value.ToString()+"'");

ddlDistricts.DataSource = dataSet.Tables[0];

ddlDistricts.DataTextField = dataSet.Tables[0].Columns["DistrictName"].ToString();

ddlDistricts.DataValueField = dataSet.Tables[0].Columns["iDistrictID"].ToString();

ddlDistricts.DataBind();

listItem.Text = "--Select--";

ddlDistricts.Items.Insert(0, listItem);

}

private void Loadcities()

{

ddlCity.Items.Clear();

ListItem listItem = new ListItem();

DataSet dataSet = RetrieveDataSets("SELECT * FROM Cities WHERE iDistrictID='"+ddlDistricts.SelectedItem.Value.ToString()+"'");

ddlCity.DataSource = dataSet.Tables[0];

ddlCity.DataTextField = dataSet.Tables[0].Columns["CityName"].ToString();

ddlCity.DataValueField = dataSet.Tables[0].Columns["iCityID"].ToString();

ddlCity.DataBind();

listItem.Text = "--Select--";

ddlCity.Items.Insert(0, listItem);

}

private DataSet RetrieveDataSets(string sqlQuery)

{

DataSet dataSet = new DataSet();

string _ConnectionString = @"Data Source=Test438\SQLEXPRESS;Initial Catalog=Projects;Integrated Security=true;";

using(SqlConnection sqlConnection = new SqlConnection(_ConnectionString))

{

sqlConnection.Open();

SqlCommand sqlCommand = new SqlCommand(sqlQuery, sqlConnection);

SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand);

sqlDataAdapter.Fill(dataSet);

}

return dataSet;

}

Hope this will help you.

selvi subramanian14y ago
senthil stil not yet works
0
selvi subramanian14y ago
Hi senthil still not yet works., again the 2nd dropdown is empty
0
Senthilkumar14y ago
hi Selvi,

Can you check this line

ds = cls.getds("select City,CityId from City where StateId='" + DropDownList1.SelectedIndex.ToString() + "'");

If stateid is int column in sql server then

ds = cls.getds("select City,CityId from City where StateId=" + DropDownList1. SelectedItem.Value.ToString());

Try this...
0
selvi subramanian14y ago

Label

if i change the codings u mentioned above the output come like this
0
selvi subramanian14y ago
OutPut

It shows like this

Label

0
selvi subramanian14y ago
its not working senthil
0
Senthilkumar14y ago
Hi,

There are problem in the binding drop down list1.

private void sel()
{
DataSet ds = new DataSet();
ds = cls.getds("select State,StateId from State");
ListItem li = new ListItem();
li.Value = "0";
li.Text = "-Select-";
DropDownList1.Items.Add(li.ToString());

foreach (DataRow dr in ds.Tables[0].Rows)
{
ListItem li1 = new ListItem();
li1.Text = dr["State"].ToString();
li1.Value= dr["StateId"].ToString();
DropDownList1.Items.Add(li1.ToString());

}

}

In the index change event,

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
DropDownList2.Items.Clear();
DataSet ds = new DataSet();
ds = cls.getds("select City,CityId from City where StateId='" + DropDownList1.SelectedItem.Value.ToString() + "'");
ListItem li3 = new ListItem();
li3.Value = "0";
DropDownList2.Items.Add(li3.ToString());
foreach (DataRow dr in ds.Tables[0].Rows)
{
ListItem li2 = new ListItem();
li2.Value = dr["CityId"].ToString();
li2.Text = dr["City"].ToString();
DropDownList2.Items.Add(li2.ToString());

}
}

Try this.
0
selvi subramanian14y ago
Please Senthil reply me
0

Label




Label