Issue sorting DataTable c#

Question

Supposing i have the following values in a column in DataTable

On sorting them in ASC ORDER i am always getting the 12510,00 on top and remaining sort perfectly fine. Any suggestion?

Tim Schmelter · Accepted Answer · 2014-09-01 22:03:36Z

2

I assume it's a string column, you should fill it with the correct type. If that's not possible you can use decimal.Parse, for example:

tbl = tbl.AsEnumerable()
    .OrderBy(row => decimal.Parse(row.Field<string>("ColumnName")))
    .CopyToDataTable();

You need to add using System.Linq.

If you use a different decimal separator you can use decimal.Parse(row.Field<string>("ColumnName"), new CultureInfo("de-DE")).

answered Sep 1, 2014 at 21:58

Tim Schmelter

462k79 gold badges719 silver badges980 bronze badges

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

1 Answer 1