Show all citys by state in dropdown list

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 < dt.Rows.Count; 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 < dt1.Rows.Count; 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.

1 Reply

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

Ravi Shekhar13y ago
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 < dt.Rows.Count; 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 < dt1.Rows.Count; 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.
0