A DataTable in which varchar is converted to Double after reordering.

The DataTable queries a field for a varchar type. But the numbers that are stored in them need to be sorted. But if the direct sort is wrong. Because of the varchar type, you need to convert it.

Method One:

Dt. Columns.Add ("Ipersonordersort", System.Type.GetType ("System.Double"));
Dt. columns["Ipersonordersort"]. Expression = "Convert (tagvalue, ' system.double ')";
DataView dv = new DataView (DT);
Dv. Sort = "Ipersonordersort asc";//Sort before conversion to DataView

Method Two:

Add a column for sorting when the SQL statement is filtered.
For example:

Select Percent as Strpercent,cast (Percent as int) as Intpercent
From Table.

Then a column intpercent int is automatically generated in the dataset.
In dataview.sortexpression = "intpercent"; Rather than "strpercent";

A DataTable in which varchar is converted to Double after reordering.