public List<City> GetCityByProvinceID(int pid) { List<City> cities = new List<City>(); City c = null; SqlDataReader dr = SqlHelper.ExecuteReader("Get_All_City_ByName",new SqlParameter("id",pid)); while (dr.Read()) { c = new City(); c.ID = dr.GetInt32(0); c.Name = dr.GetString(1); cities.Add(c); } dr.Close(); return cities; }
public List<City> GetAllcity() { List<City> cities = new List<City>(); City p = null; SqlDataReader dr = SqlHelper.ExecuteReader("dbo.Get_All_City"); while (dr.Read()) { p = new City(); p.ID = dr.GetInt32(0); p.Name = dr.GetString(1); cities.Add(p); } dr.Close(); return cities; }