Hi i have 3 cascading dropdownlists (Country,State,City) they depend on each other , My application when it run you have choose your country and then it will be saved in a session called: "location" so what i want is dont show the dropdownlist of the country
and show only the state and city the the state will show the states of the selected country that stored in the session . The below is the code of the state dropdownlist so can you help to update it depend on a session location
protected void statedrdolst_SelectedIndexChanged(object sender, EventArgs e)
{
DataTable StateDT = new DataTable();
using (SqlConnection con2 = new SqlConnection(ConfigurationManager.ConnectionStrings["BeravaConnectionString"].ConnectionString))
{
SqlDataAdapter adaptar = new SqlDataAdapter("Select [StateID],[State] FROM [State] WHERE [countryID] = Loca" , ...
Go to the complete details ...