DataView .RowFilter 使用

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