Rounding in Grid

[Tomáš]

Hello!

It's possible to round number directly in RadGrid? I have grid and I dynamically create its structure. I get from my database numbers like 3.123456789 , but i need to show just 3.12

[Shinu]

Hi Tomas,

Try setting the DataFormatString for the Grid column as shown below and see whether it is working.

ASPX:

<telerik:GridBoundColumn UniqueName="UnitPrice"

DataFormatString="{0:N2}"    HeaderText="UnitPrice" DataField="UnitPrice" ></telerik:GridBoundColumn>

If you are creating the Grid Column dynamically you may try the following approach.

CS:

GridBoundColumn boundCol = new GridBoundColumn();
            RadGrid1.MasterTableView.Columns.Add(boundCol);
            boundCol.DataField = "UnitPrice";
            boundCol.HeaderText = "UnitPrice";
            boundCol.UniqueName = "UnitPrice";
            boundCol.DataFormatString = "{0:N2}";

Thanks
Shinu