Sorting works wrongly for the columns which has decimal values.

[Senthil S]

Hi,

I am using silverlight 4.Sorting is not working properly in the gridview.

For ex:If one of the column in the Grid has the values like

112.45
23.00
112.46
45.00
42.00
0.00
2.00

If i sort with Ascending order it sorts like
0.00
112.45
112.46
 2.00
23.00
42.00
45.00

 For descending its sorts like
45.00
42.00
23.00
2.00
112.46
112.45
0.00

it sorts as if it has a string values.But the SQL query that i am using for the populating the grid has only the decimal value.

Even i have changed the datatype of that particular column to decimal.But it is sorting as if they have 'String' values.

Dim gridViewBoundColumnBase = TryCast(grdAddAssignments.Columns("Distance"), Telerik.Windows.Controls.GridViewBoundColumnBase)
If gridViewBoundColumnBase IsNot Nothing Then
    gridViewBoundColumnBase.DataType = GetType(Decimal)
End If

Thanks in Advance

Senthil

[Carina]

Hi were you able to find a solution for this?