C# Linq Group By 사용법(DataTable)

DataTable을 사용하여 Linq Group By 사용방법 입니다.

 

 

    
                //Data 조회
                _dtSource = Query.GET_MAP_HIS();
 
                //Linq Group by
                var query =
            from order in _dtSource.AsEnumerable()
            group order by new
            {
                PBOXID = order.Field<String>("PBOXID"),
                P_MODE = order.Field<String>("P_MODE")
            } into g
            select new
            {
                PBOXID = g.Key.PBOXID,
                P_MODE = g.Key.P_MODE
            };
                
           //Linq to Arry변화하여 그리드 DataSource 할당
           LGrid.DataSource = query.ToArray();