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