How to sort DataTable by two columns in c# How to sort DataTable by two columns in c# asp.net asp.net

How to sort DataTable by two columns in c#


c# asp.net sorting datatable

You can use LINQ to DataSet/DataTable 

var newDataTable = yourtable.AsEnumerable()                   .OrderBy(r=> r.Field<int>("ItemIndex"))                   .ThenBy(r=> r.Field<int>("ItemValue"))                     .CopyToDataTable();

c# asp.net sorting datatable

Create a DataView and use the Sort Property:

DataView dv = new DataView(dt);dv.Sort = "ItemIndex, ItemValue";

e.g.

foreach (DataRowView row in dv) {   Console.WriteLine(" {0} \t {1}", row["ItemIndex"], row["ItemValue"]);}

For more information, check out MDSN for a more thorough example:

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

c# asp.net sorting datatable

On the datatable object, just get the defaultview object and set the sort.

dataTable.DefaultView.Sort = "ItemIndex, ItemValue";

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last