C # able sorting by numbers

Use DT. defaultview. Sort = "ratesort DESC ";

The order is ,.

Instead of 1, 2, 3, 10, 20, 30

Solution:

Sort by numeric values. You can add a column converted to a numeric value.

Dtsum. Columns. Add ("ratesort", typeof (INT ));

Store the values of this column in the numeric type to be sorted

Example:

Dtsum. Columns. Add ("rate"); // used for display

Dtsum. Columns. Add ("ratesort", typeof (INT); // used for sorting

Double dourate = (doufirsttime/double. parse (dtsum. Rows [I] [1]. tostring () * 100;
Dtsum. Rows [I] ["ratesort"] = dourate;

Dtsum. Rows [I] ["rate"] = double. parse (dourate. tostring ("0.00") + "% ";

// Bind

Dataview DV = dtsum. defaultview;
DV. Sort = "ratesort DESC ";
This. dgvagentfirsttime. datasource = DV. Table;