How to sort DataTable based on multiple column?

Question

I have DataTable

Name  Date
bbb   01/01/2011
bbb   01/01/2012
aaa   01/01/2010
aaa   01/01/2011
bbb   01/01/2013
aaa   01/01/2012
bbb   01/01/2010
ccc   01/01/2010
aaa   01/01/2013
ccc   01/01/2012
ccc   01/01/2011

I need sort this table sort by name and every name by date:

Name  Date
aaa   01/01/2010
aaa   01/01/2011
aaa   01/01/2012
aaa   01/01/2013
bbb   01/01/2010
bbb   01/01/2011
bbb   01/01/2012
bbb   01/01/2013
ccc   01/01/2010
ccc   01/01/2011
ccc   01/01/2012

How to sort DataTable in c#?

I've tried the following:

   DataView dv = dt.DefaultView;
   dv.Sort = "col1 desc";
   DataTable sortedDT = dv.ToTable();

but this sort only by 1 column...

Might take a look at this: stackoverflow.com/q/2777765/945456 — Jeff B
– Jeff B, Commented Nov 25, 2013 at 22:24

Sergey Berezovskiy · Accepted Answer · 2013-11-25 22:28:12Z

4

You can use LINQ to DataSet

var sortedDT = dt.AsEnumerable()
                 .OrderBy(r => r.Field<string>("Name"))
                 .ThenBy(r => r.Field<DateTime>("Date"))
                 .CopyToDataTable();

Use CopyToDataTable method to create new DataTable from ordered rows.

answered Nov 25, 2013 at 22:28

Sergey Berezovskiy

237k44 gold badges441 silver badges468 bronze badges

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

2 Comments

Bryuk Over a year ago

Thanks, but coma would be much easier=)

Sergey Berezovskiy Over a year ago

@Bryuk agree, in this particular case, when you have DataView, string-based sorting looks more simple. If later you will require more complex sorting, then take a look on Sorting with DataView article

neilh · Accepted Answer · 2013-11-25 22:28:48Z

2

http://msdn.microsoft.com/en-us/library/system.data.dataview.sort.aspx

All you need to do is add a comma between the columns in the dv.Sort line.

To clarify

dv.Sort = "Name, Date";

answered Nov 25, 2013 at 22:28

neilh

7163 silver badges9 bronze badges

4 Comments

Bryuk Over a year ago

OMG! Sorry... Do I need to delete this question? Or accept and forget?=)

Tim Schmelter Over a year ago

@Bryuk: Is Date a DateTime or String column?

Tim Schmelter Over a year ago

If it's string it doesn't work. Add these rows and look at the "suprising" sort: dt.Rows.Add("Test", "01/01/2011"); dt.Rows.Add("Test", "02/01/2010");

neilh Over a year ago

I have to agree with @TimSchmelter here. If it's a string column you are much safer going the linq-to-dataset route where you can parse it to a date before doing the sort. That said, if the data you are currently dealing with happens to work with a simple string sort (i.e. you only ever have January 1st and are effectively sorting on year) then by all means take the easy solution. But please comment and unit test liberally.

Tim Schmelter · Accepted Answer · 2013-11-25 23:26:29Z

2

You can use Linq-To-DataSet:

var orderedRows = from row in dt.AsEnumerable()
                  orderby row.Field<string>("Name"), row.Field<DateTime>("Date")
                  select row; 
DataTable tblOrdered = orderedRows.CopyToDataTable();

If the Date column is actually a string column you need to parse it to DateTime first.

Assuming valid formats:

var orderedRows = from row in dt.AsEnumerable()
                  let date = DateTime.Parse(row.Field<string>("Date"), CultureInfo.InvariantCulture)
                  orderby row.Field<string>("Name"), date 
                  select row;

edited Nov 25, 2013 at 23:26

answered Nov 25, 2013 at 22:29

Tim Schmelter

462k79 gold badges719 silver badges980 bronze badges

Collectives™ on Stack Overflow

How to sort DataTable based on multiple column?

3 Answers 3

2 Comments

4 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related