Dropdowm did not show the value of next one

Question

Untitled Page .style1 { width: 100%; } .style2 { width: 412px; } 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 StateStateId 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 CityCityId 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 LocationLocationId 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()); } } }

Satyapriya Nayak · Answer

Hi Selvi Try this... 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 CountryIdCountryName 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 StateIdStateName 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 CityIdCityName 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

Kunal Vaishya · Answer

try this ddl2.Items.Add(New ListItem( dr[Location].ToString()  dr[LocationId ].ToString() ))

selvi subramanian · Answer

thanks both of them .... thank u very much senthil

Senthilkumar · Answer

Hi Selvi Database Design: CREATE TABLE States ( iStateID INT IDENTITY(11) 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(11) PRIMARY KEY iStateID INT REFERENCES States(iStateID) DistrictName VARCHAR(100) CreatedDate DATETIME DEFAULT GETDATE() ) INSERT INTO Districts(iStateIDDistrictName) VALUES(6'Chennai') INSERT INTO Districts(iStateIDDistrictName) VALUES(6'Madurai') INSERT INTO Districts(iStateIDDistrictName) VALUES(6'Coimbatore') INSERT INTO Districts(iStateIDDistrictName) VALUES(6'Erode') INSERT INTO Districts(iStateIDDistrictName) VALUES(6'Salem') INSERT INTO Districts(iStateIDDistrictName) VALUES(6'Trichy') INSERT INTO Districts(iStateIDDistrictName) VALUES(6'Tirunelveli') INSERT INTO Districts(iStateIDDistrictName) VALUES(6'Kanyakumari') INSERT INTO Districts(iStateIDDistrictName) VALUES(6'Vellore') INSERT INTO Districts(iStateIDDistrictName) VALUES(6'Dindugal') CREATE TABLE Cities ( iCityID INT IDENTITY(11) PRIMARY KEY iDistrictID INT REFERENCES Districts(iDistrictID) CityName VARCHAR(100) CreatedDate DATETIME DEFAULT GETDATE() ) INSERT INTO Cities(iDistrictIDCityName) VALUES(1'Numgambakam') INSERT INTO Cities(iDistrictIDCityName) VALUES(1'Vadapalani') INSERT INTO Cities(iDistrictIDCityName) VALUES(1'Adyar') INSERT INTO Cities(iDistrictIDCityName) VALUES(1'Velachery') INSERT INTO Cities(iDistrictIDCityName) 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 subramanian · Answer

senthil stil not yet works

selvi subramanian · Answer

Hi senthil still not yet works. again the 2nd dropdown is empty

Senthilkumar · Answer

hi Selvi Can you check this line ds = cls.getds(select CityCityId from City where StateId=' + DropDownList1.SelectedIndex.ToString() + '); If stateid is int column in sql server then ds = cls.getds(select CityCityId from City where StateId= + DropDownList1. SelectedItem.Value.ToString() ); Try this...

selvi subramanian · Answer

-Select- 10 11 12 0 0 0 Label if i change the codings u mentioned above the output come like this

selvi subramanian · Answer

OutPut It shows like this -Select- TamilNadu Kerela Kovai 0 Label

selvi subramanian · Answer

its not working senthil

Senthilkumar · Answer

Hi There are problem in the binding drop down list1. private void sel() { DataSet ds = new DataSet(); ds = cls.getds(select StateStateId 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 CityCityId 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.

selvi subramanian · Answer

Please Senthil reply me