[WebMethod] public IEnumerable<CitySearchResult> SearchFromHomeBus(int fromid, int toid) { // DbDataReader sqlreader; SqlParameter []para=new SqlParameter[2]; para[0]=new SqlParameter("@city1",fromid); para[1]=new SqlParameter("@city2",toid); using (cab_4_21Entities1 d = new cab_4_21Entities1()) { ObjectResult<CitySearchResult> search =d.ExecuteStoreQuery<CitySearchResult>("usp_SearchcabResult @city1, @city2", para); //List<CitySearchResult> search = (d.ExecuteStoreQuery<CitySearchResult>("usp_SearchcabResult", para)).ToList<CitySearchResult>(); List<CitySearchResult> searchResult=search.ToList<CitySearchResult>(); return searchResult; } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)