DataTable Sort in C#?

Question

I'd like to sort DataTable by one Column of the DataTable,for example Name.While I'd like to define my own way of sorting, such as sort by the entension of the file, how to implement that way?

http://stackoverflow.com/questions/1819744/sorting-datatable-columns?rq=1 ? — iabbott, Sep 13 '13 at 10:13
http://stackoverflow.com/questions/582374/dataview-sort-more-than-just-asc-desc-need-custom-sort — Matus, Sep 13 '13 at 10:15

score 2 · Answer 1 · answered Sep 13 '13 at 10:17

The easiest and most extendable way is to use Linq-To-DataSet and Path.GetExtension:

var orderedRows = dataTable.AsEnumerable()
    .Select(row => new { // create an anoymous type for readability
        row, 
        extension = Path.GetExtension(row.Field<string>("Filename"))  
    })
    .OrderBy(x => x.extension)
    .Select(x => x.row);

If you need a new DataTable from the query (you could simply loop it with foreach) use:

dataTable = orderedRows.CopyToDataTable();

score 1 · Answer 2 · answered Sep 13 '13 at 10:36

1

DataTable result = dt.AsEnumerable()
                     .OrderBy(d=>d.Field<string>("YourFieldName"))
                     .CopyToDataTable();

answered Sep 13 '13 at 10:36

Kaf

33,101
7
58
78

score 0 · Answer 3 · answered Sep 13 '13 at 10:13

0

Easiest way: add a hidden DataColumn where you will store file extension and sort DataTable on that DataColumn as usually.

answered Sep 13 '13 at 10:13

Andrius Naruševičius

8,348
7
49
78

DataTable Sort in C#?

3 Answers3