Rad Grid column formatting

[Keshav]

Hi all ,

 

I have a requirement where I want the data in a currency column to be separated by commas. I have tried with different formats where i get commas but with '$' sign.I want commas with '$'. Any help is appreciated.

[Keshav]

I want commas without '$'.

#TypeError

 

Regards,

Anurag

[Mansour]

You could try putting something like this in the grid's ItemBound event:

1.protected void rgUserAccess_ItemDataBound(object sender, GridItemEventArgs e)
2.{
3.    if (e.Item is GridDataItem)
4.    {
5.        var editItem = (GridDataItem)e.Item;
6.        editItem["price"].Text = int.Parse(editItem["price"].Text).ToString("000,000.00");
7.    }
8.}

[Eyup]

Hi,

@Ali, Thank you for sharing your suggestion.

@Anurag, First of all, please make sure that you are not using DataBind() to bind the grid. Performing complex grid operations such as Inserting, Deleting, Updating, Hierarchy relations, Grouping, Exporting, Paging, Sorting, Filtering, etc. require accommodating appropriate database operations.  Therefore, we suggest you to avoid Simple Databinding and strongly recommend the use of more advanced databinding methods, which automatically handle the aforementioned functions:
Declarative DataSource
Programmatic Data Binding

As for the formatting requirement, you can achieve it using the formatting capabilities provided by .NET framework. For grid columns you can use the DataFormatString property:

Copy Code

<telerik:GridNumericColumn DataField="Freight" DataType="System.Decimal"
    FilterControlAltText="Filter Freight column" HeaderText="Freight"
    SortExpression="Freight" UniqueName="Freight" DataFormatString="{0:N0}">

For evaluated values you can use the String.Format(... / ...) method.

In addition, you can also check the following resources:
http://msdn.microsoft.com/en-us/library/dwhawy9k%28v=vs.110%29.aspx
http://msdn.microsoft.com/en-us/library/0c899ak8%28v=vs.110%29.aspx

Hope this helps.

Regards,
Eyup
Telerik