티스토리 뷰

WPF

C# Multiple Order By with LINQ

NicSub 2021. 6. 25. 16:09
728x90
반응형

               

먼저 Orderby( e=> e.Field<string>("A1")). ThenBy(e => e.Field("A2")) 또는 ThenByDescending(e => e.Field<string>("A2"))

 

 DataTable query2 = new DataTable();
                 query2 =Result_DTL.AsEnumerable()
                            .GroupBy(row => new
                            {
                                TEC1 = row.Field<string>("a1"),
                                Grade1 = row.Field<string>("a2")
                            })
                            .Select(gcs =>
                            {
                                var row = Result_DTL.NewRow();
                                row["a1"] = gcs.Key.TEC1;
                                row["a2"] = gcs.Key.Grade1;
                                return row;
                            })
                            .OrderBy(e => e.Field<string>("a1")).ThenByDescending(e => e.Field<string>("a2"))
                            .CopyToDataTable();

반응형
댓글