C# DataTable 数据分组(两种方法)

一：字典存

if (ds != null && ds.Tables[0].Rows.Count > 0)
                {
                    Dictionary<string, List<object>> dic = new Dictionary<string, List<object>>();

                    for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                    {
                        string khid = ds.Tables[0].Rows[i]["KHID"].ToString();
                        if (dic.Keys.Contains(khid))//如果存在
                        {
                            List<object> list = dic[khid];
                            list.Add(new { ADRJD = ds.Tables[0].Rows[i]["ADRJD"].ToString(), ADRWD = ds.Tables[0].Rows[i]["ADRWD"].ToString() });
                        }
                        else
                        {//如果不存在
                            dic.Add(khid, new List<object>() { new { ADRJD = ds.Tables[0].Rows[i]["ADRJD"].ToString(), ADRWD = ds.Tables[0].Rows[i]["ADRWD"].ToString() } });
                        }
                        
                      }
                 }

二  数组对象存

if (ds != null && ds.Tables[0].Rows.Count > 0)
                {
                    List<AllArea> all = new List<AllArea>();

                    for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                    {
                        string khid = ds.Tables[0].Rows[i]["KHID"].ToString();
                        
                        if (all.Count > 0 && all.Exists(a => a.KHID.Equals(khid)))//如果存在
                        {
                            List<Area> list = all.Find(b => b.KHID.Equals(khid)).POINTS;
                            list.Add(new Area { ADRJD = ds.Tables[0].Rows[i]["ADRJD"].ToString(), ADRWD = ds.Tables[0].Rows[i]["ADRWD"].ToString() });
                        }
                        else {
                            all.Add(new AllArea { KHID = khid, POINTS = new List<Area> { new Area { ADRJD = ds.Tables[0].Rows[i]["ADRJD"].ToString(), ADRWD = ds.Tables[0].Rows[i]["ADRWD"].ToString() } } });
                        }
                    }
}
 public class Area
        {
            public string ADRJD { get; set; }
            public string ADRWD { get; set; }
        }
            public class AllArea
        {
            public string  KHID { get; set; }
            public string SNAME { get; set; }
            public string ADRJD { get; set; }
            public string ADRWD { get; set; }
            public List<Area> POINTS { get; set; }
        }