Developing a registration form with Country and city name .
I need the city to be loaded in the dropdown list based on the selection in country dropdownlist.
CODE:
public void Bind_ddlCountry()
{
SqlConObject.Open();
SqlCommand cmd = new SqlCommand("sp_Country", SqlConObject);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader dr = cmd.ExecuteReader();
ddlCountry.DataSource = dr;
ddlCountry.Items.Clear();
ddlCountry.Items.Add("Select");
ddlCountry.DataTextField = "Country_Name";
ddlCountry.DataValueField = "Country_ID";
ddlCountry.DataBind();
SqlConObject.Close();
}
public void Bind_ddlCity(int countryid)
{
SqlConObject.Open();
SqlCommand cmd = new SqlCommand("sp_City", SqlConObject);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Countryid", SqlDbType.Int).Value = countryid;
SqlDataReader dr = cmd.ExecuteReader();
ddlCity.DataSource = dr;
ddlCity.Items.Clear();
ddlCity.Items.Add("Select");
ddlCity.DataTextField = "City_Name";
ddlCity.DataValueField = "Country_ID";
ddlCity.DataBind();
SqlConObject.Close();
}
}
protected void ddlCountry_SelectedIndexChanged(object sender, EventArgs e)
{
Bind_ddlCity(int.Parse(ddlCountry.SelectedValue));
}
No comments:
Post a Comment