Posts

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;     ...