Cascading Dropdowns with Webservice and Jquery Ajax
Create PROCEDURE COUNTRIES_List AS BEGIN select CTRY_ID, CRTY_NAME from COUNTRY END CREATE PROCEDURE STATES_LIST (@CTRY_ID int) AS BEGIN select STATE_ID,STATE_NAME from STATES where CTRY_ID=@CTRY_ID end ALTER PROCEDURE CITYS_BYSTATE_ID (@STATE_ID int) AS begin select CITY_ID, CITY_NAME from CITY where STATE_ID=@STATE_ID end [WebMethod] public void ListofCountries() { List<oCountry> countries = new List<oCountry>(); using (SqlConnection con = new SqlConnection(cs)) { SqlCommand cmd = new SqlCommand("COUNTRIES_List", con); cmd.CommandType = CommandType.StoredProcedure; ...