rad grid column sorting does not seem to work correctly for the last column in the grid

[ertet]

i am using rad grid and in the rad grid last column(total) sorting is not happening correctly. it is sorting from second record. for ex the output should be
$989.23
 $1099.81
$1799.12
$1988.45

but it is showing

 $1099.81
$1799.12
$1988.45
$989.23

I have added sort expression and also in page load i have given in page_load, all other columns sorting is working fine and this result is coming from database

            GridSortExpression expression = new GridSortExpression();
            expression.FieldName = "total";
            expression.SortOrder = GridSortOrder.Ascending;
            grdResults.MasterTableView.SortExpressions.AddSortExpression(expression);
            grdResults.MasterTableView.Rebind();
            this.grdResults.AllowSorting = true;

[Cori]

Have you set the DataType property for that column to a numeric one? That could be the issue.

[ertet]

Is it mandatory to change it to numeric as i have its datatype as system.decimal, will decimal or double work??

[ertet]

dataformat string is not working at all for currency format. i have given

 

<rad:GridBoundColumn DataField="fuel" DataFormatString="{0:$###,###.00}" HeaderButtonType="TextButton"

 

 

HeaderText="Fuel" ReadOnly="true" SortExpression="fuel" UniqueName="fuel" Visible="true">

 

 

<HeaderStyle HorizontalAlign="Right" />

 

 

<ItemStyle HorizontalAlign="Right" />

 

 

</rad:GridBoundColumn>

 

 

<rad:GridBoundColumn DataField="total" HeaderButtonType="TextButton" DataFormatString="{0:$###,####.00}"

 

 

HeaderText="Total" DataType="System.Decimal" AllowSorting="true" ReadOnly="true"

 

 

SortExpression="total" UniqueName="total" Visible="true">

 

 

<HeaderStyle HorizontalAlign="Right" />

 

 

<ItemStyle HorizontalAlign="Right" />

 

 

</rad:GridBoundColumn>

 

but still the format doesnt come, i have to hardcode it to

 

row["total"] = (row["fuel"].ToString() + row["mRate"].ToString());

 

 

row["fuel"] = "$" + row["fuel"].ToString();

 

 

row["total"] = "$" + row["total"].ToString();

so wen i do a sorting,it doesnt happen corectly.please advice.

 

[ertet]

Is there nobody to fix this issuee????

[Nikolay Rusev]

Hello Ertet,

RadGrid performs String.Format("value extracted from DataItem","specified format") when you specify DataFormatString.

You can try manually applying your custom format you some value that is used for binding RadGrid and see whether it is formatted as you expect.

Regards,
Nikolay
the Telerik team

[ertet]

it is not working, problem is with sorting............not sorting alsooo....

[Nikolay Rusev]

Hi Ertet,

If String.Format("value extracted from DataItem","specified format") does not work properly, neither DataFormatString will work.

Regards,
Nikolay
the Telerik team