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.

Show all citys by state in dropdown list

Answers (1)