Sorting Percentage Column

[JD Plagianis]

I have a webpage that creates a datatable programmatically depending on options that users have chosen on different pages.  I store the table as a session variable, then when the time comes, I assign the table to the grid during NeedDataSource.  No columns are explicitly defined in the RadGrid.  One of the columns could contain a percentage value.

The problem comes when someone tries to sort this percentage column:  It seems to sort as text!  100% will show up next to 10% and be listed lower than 95%.  I read through the forums and the only remedy I found was to define the radgrid column as a percentage value.  Unfortunately, I have not explicitly defined the columns in the radgrid, so RadGrid1.MasterTableView.Columns.Count = 0 and I cannot set column X's property to percentage.

Any suggestions for how to fix my sorting problem?

[Cori]

Set the DataType of your percentage column.

Like so: DataType="System.Double". This way RadGrid knows that it should sort it numerically.

I hope that helps.

[JD Plagianis]

Yes, but how to access that column in the radgrid to set the column's property when the column is autogenerated and not explicitly declared?

[Iana Tsolova]

Hello JD,

You can handle the ColumnCreated event for that purpose.

For more information you can check out this article.


Sincerely yours,
Iana
the Telerik team