How do you Sort a DataTable given column and direction?

Question

I need to resort, in memory, a DataTable based on a column and direction that are coming from a GridView. The function needs to look like this:

public static DataTable resort(DataTable dt, string colName, string direction) { DataTable dtOut = null; .... }

I need help filling in this function. I think I can use a Select statement but I am not sure how. I can't click on Comments because of this browser but you can show me an in-place or new DataTable solution, either one. For the people showing me pointers, please, I need a coded function similar to the one prototyped.

How about:

// ds.Tables[0].DefaultView.Sort="au_fname DESC"; public static void Resort(ref DataTable dt, string colName, string direction) { string sortExpression = string.Format("{0} {1}", colName, direction); dt.DefaultView.Sort = sortExpression; }

Berkay Turancı · Accepted Answer · 2012-12-25 13:34:20Z

I assume "direction" is "ASC" or "DESC" and dt contains a column named "colName"

public static DataTable resort(DataTable dt, string colName, string direction) { DataTable dtOut = null; dt.DefaultView.Sort = colName + " " + direction; dtOut = dt.DefaultView.ToTable(); return dtOut; }

OR without creating dtOut

public static DataTable resort(DataTable dt, string colName, string direction) { dt.DefaultView.Sort = colName + " " + direction; dt = dt.DefaultView.ToTable(); return dt; }

This seems to work the first time but not subsequent times. When I set my defaultView.Sort a second time to a different column direction, the table in the gridView diappears....
Hmm, looks like it's overwriting the tableStyles.GridCOlumnStyles
You can also simplify the second code block to simply return dt.DefaultView.ToTable();.

Benny Skogberg · Accepted Answer · 2013-02-28 13:12:54Z

If you've only got one DataView, you can sort using that instead:

table.DefaultView.Sort = "columnName asc";

Haven't tried it, but I guess you can do this with any number of DataViews, as long as you reference the right one.

Kᴀτᴢ · Accepted Answer · 2015-11-10 13:54:26Z

22

Actually got the same problem. For me worked this easy way:

Adding the data to a Datatable and sort it:

dt.DefaultView.Sort = "columnname"; dt = dt.DefaultView.ToTable();

answered Nov 10, 2015 at 13:54

Kᴀτᴢ

2,1966 gold badges33 silver badges60 bronze badges

1 Comment

TylerH Over a year ago

How did you have the same problem if you weren't using a DataTable before? The question here is about sorting a DataTable. "Adding the data to a DataTable" can't possibly be of any use in that scenario; it's already in a DataTable. This also appears to repeat the solution from Berkay Turanci from 3 years prior.

Paul Sasik · Accepted Answer · 2011-02-15 15:40:21Z

DataTables have an overloaded Select method that you can you to do this. See here: http://msdn.microsoft.com/en-us/library/way3dy9w.aspx

But the return val of the Select call is not a DataTable but an array of RowData objects. If you want to return a DataTable from your function you will have to build it from scratch based on that data array. Here is a post that addresses and provides a sample for both issues: http://social.msdn.microsoft.com/Forums/en-US/winformsdatacontrols/thread/157a4a0f-1324-4301-9725-3def95de2bf2/

Evan Parsons · Accepted Answer · 2017-01-24 16:50:22Z

In case you want to sort in more than one direction

 public static void sortOutputTable(ref DataTable output) { DataView dv = output.DefaultView; dv.Sort = "specialCode ASC, otherCode DESC"; DataTable sortedDT = dv.ToTable(); output = sortedDT; }

TylerH · Accepted Answer · 2024-10-29 21:16:33Z

Create a DataView. You cannot sort a DataTable directly, but you can create a DataView from the DataTable and sort that.

Creating: http://msdn.microsoft.com/en-us/library/hy5b8exc.aspx

Sorting: http://msdn.microsoft.com/en-us/library/13wb36xf.aspx

The following code example creates a view that shows all the products where the number of units in stock is less than or equal to the reorder level, sorted first by supplier ID and then by product name.

DataView prodView = new DataView(prodDS.Tables["Products"], "UnitsInStock <= ReorderLevel", "SupplierID, ProductName", DataViewRowState.CurrentRows);

Collectives™ on Stack Overflow

How do you Sort a DataTable given column and direction?

6 Answers 6

3 Comments

Comments

1 Comment

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

3 Comments

Comments

1 Comment

Comments

Comments

Comments

Linked

Related