Show all citys by state in dropdown list

Question

Show all city like this drop doropdown list in asp.net

Ravi Shekhar · Answer

Hi Bhupendra  You have to take 2 Tables. First contain statelist. second contain state and citylist(find attached Image). Now write the below code on the page load. protected void Page_Load(object sender EventArgs e) { SqlConnection cn = new SqlConnection(Data Source=BCILGGN13\SQLEXPRESS; Initial catalog=Test; Uid=sa; Pwd=bcil;); DataTable dt; DataTable dt1; SqlDataAdapter adap; if (!IsPostBack) { ddlCity.AppendDataBoundItems = true; ddlCity.Items.Insert(0 -select-); adap = new SqlDataAdapter(select * from State_List cn); dt = new DataTable(); adap.Fill(dt); int j = 0; if (dt.Rows.Count > 0) { j = 1; for (int i = 0; i { ddlCity.Items.Add(dt.Rows[i][State].ToString()); ddlCity.Items[j].Attributes.Add(style color:red); adap = new SqlDataAdapter(select City from city_list where state= ' + dt.Rows[i][State] + ' cn); dt1 = new DataTable(); adap.Fill(dt1); for (int k = 0; k { ddlCity.Items.Add(dt1.Rows[k][City].ToString()); } j = dt1.Rows.Count + dt.Rows.Count; } } } } It returns same result as u want. Regards Ravi Please mark it as answer if you are happy with the above code.