How To Sort Decimal Number with % as post fix in Radgrid

[Rahul Khinvasara]

Hello,
I am using Radgrid one of it's coulmn havivg value in decimal with % as post fix for example 99.22%,When I m trying
to Sort this collumn it is not sorting Correctly.... I used 

DataType

="System.Decimal" DataFormatString="{0:###.###%}"  in property of that column then also it's not working properly.
Please  let me know what to do?

 Hope I'll get solutions soon.

Thanks

 

[Princy]

Hello Rahul,

Try setting the DataFormatString for the Column as shown in the code below:
aspx:

<telerik:GridBoundColumn DataField="Percentage" HeaderText="Percentage" ReadOnly="True" SortExpression="Percentage" UniqueName="Percentage" DataType="System.Decimal" DataFormatString="{0:###.###}%">
</telerik:GridBoundColumn>

Hope this helps.
Princy.

[Rahul Khinvasara]

Hi,
I already have used same code...But it does not work,Plz give me another solution.

Thanks