DataView .RowFilter使用更方便不用遍历。
根据条件筛选出数据。
public static List<CityEntity> GetCityList(string ProvinceID)
{
DataSet ds = GetCity();
List<CityEntity> list = new List<CityEntity>();
if (ds != null)
{
DataView dv = ds.Tables[0].DefaultView;
dv.RowFilter = "ProvinceID='" + ProvinceID + "'";//在内存中找与ProvinceID相同的市;
dv.Sort = "city_id asc";//按升序排列
foreach (DataRowView row in dv)
{
CityEntity entity = new CityEntity();
entity.city_id = int.Parse(row["city_id"].ToString());
entity.ProvinceID = int.Parse(row["ProvinceID"].ToString());
entity.city_name = row["city_name"].ToString();
list.Add(entity);
}
}
return list;
//if (ds != null)
//{
// foreach (DataRow dr in ds.Tables[0].Rows)
// {
// CityEntity entity = new CityEntity();
// entity.city_id = int.Parse(dr["city_id"].ToString());
// entity.ProvinceID = int.Parse(dr["ProvinceID"].ToString());
// entity.city_name = dr["city_name"].ToString();
// list.Add(entity);
// }
//}
//return list;
}