Sorting datatable by two columns with one column asc and the other one desc c#

Question

I have multiple columns in datatable like this:

   COL1   COL2 COL3      
   aaa    5    bla
   bbb    8    blablabla
   ccc    11   blabla
   ddd    9    bl
   eee    6    blabl

I'm trying to sort this datatable by COL1 asc and by COL2 desc BOTH!

I have tried the following solution but it doesn't exactly sort the second column:

DataTable dt = GetMyData();
dt.DefaultView.Sort = "COL1";
dt.DefaultView.Sort = "COL2 DESC";
dt = dt.DefaultView.ToTable();

Gerald Gonzales · Accepted Answer · 2016-09-05T09:00:31.743

1

Use LINQ to DataSet/DataTable

https://msdn.microsoft.com/en-us/library/bb386977.aspx

var newDt = dt.AsEnumerable()
            .OrderByDescending(x => x.Field<int>("COL2"))
            .ThenBy(x => x.Field<string>("COL1"))
            .CopyToDataTable();

edited Sep 05 '16 at 09:00

answered Sep 05 '16 at 08:55

Gerald Gonzales

533
2
6
20

score 1 · Answer 2 · answered Sep 05 '16 at 08:55

1

  DataView sortedView = new DataView(dt);

  // Sort by COL1 and COL2
  sortedView.Sort = "COL1 DESC, COL2 ASC";

after this you should have sorted records in the data view

answered Sep 05 '16 at 08:55

Sujit Singh

799
6
11

Sorting datatable by two columns with one column asc and the other one desc c#

2 Answers2