How to sort datatable with multi column using LINQ

Question

I have a Datatable contain n columns. I want to sort n columns in the datatable by LINQ but I don't know how to do that. I sorted successfully with 1 columns but I didn't with multi columns

Ex:

Dictionary<string, string> dict = Dictionary<string, string>
dict.Add("column_1", "asc");
dict.Add("column_2", "asc");
dict.Add("column_3", "asc");
...
dict.Add("column_n", "asc");
var Rows = from row in datatable.AsEnumerable()
           orderby n1 acsending  (I need loop to add all columns in Dictionary here to sort multi columns)
           select row

How to loop n columns to add in orderby operator.

My problem is user have a array contain name of columns to sort and I need loop a array to add columns name in operator orderby to sort multi column

PS: My English is not good. Sorry

Thanks Nguyen

I have commented detail about my problem. Please help me to resolve it — user1186850
– user1186850, Commented Jun 26, 2015 at 15:57
Possible duplicate of How to sort DataTable by two columns in c# — Sometowngeek
– Sometowngeek, Commented Aug 5, 2016 at 15:08

Steffen Timm · Accepted Answer · 2015-06-26 15:48:28Z

3

datatable.AsEnumerable().OrderBy(c => c[0]).ThenBy(c => c[1]);

This will order the rows by the first and the second column

answered Jun 26, 2015 at 15:48

Steffen Timm

916 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Adam · Accepted Answer · 2015-06-26 15:48:43Z

3

list.OrderBy(x => x.att1).ThenByDescending(x => x.att2);

Could be ThenByAscending. Using a lambda in this situation would be cleaner to read as well.

answered Jun 26, 2015 at 15:48

Adam

2,44021 silver badges30 bronze badges

Comments

Steffen Timm · Accepted Answer · 2015-06-26 16:18:07Z

3

To use the dictionary as order definition you can use the following:

Dictionary<string, string> dict = new Dictionary<string, string>();
dict.Add("col1", "asc");
dict.Add("col2", "desc");

DataTable datatable = new DataTable();
datatable.Columns.Add("col1");
datatable.Columns.Add("col2");
datatable.Rows.Add(new[] {"a", "1"});
datatable.Rows.Add(new[] {"b", "2"});
datatable.Rows.Add(new[] {"a", "5"});

datatable.DefaultView.Sort = 
                  String.Join(",", dict.Select(x => x.Key + " " + x.Value).ToArray());
datatable = datatable.DefaultView.ToTable();

answered Jun 26, 2015 at 16:18

Steffen Timm

916 bronze badges

Comments

Hugh · Accepted Answer · 2015-06-26 15:50:32Z

0

Try comma seperating the order by columns

var Rows = from row in datatable.AsEnumerable()
       orderby n1 acsending, n2
       select row

answered Jun 26, 2015 at 15:50

Hugh

4543 silver badges13 bronze badges

Collectives™ on Stack Overflow

How to sort datatable with multi column using LINQ

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related