How to render the value in a templated RadGrid column in a specific culture and which RadGrid event to do this in?

[jgill]

I wanted to know if there is an event/method for templated RadGrid columns/items where I can specifically set the culture that a specific templated value is rendered in separately from the culture used on the rest of the page/values.

Example:  The user is viewing the page in Japanese and that is the culture for the overall site, but all prices in a certain column in a RadGrid need to be listed as US prices with the $ currency while all other resources need to still be in Japanese.  

For a specific datagrid and templated column, how can I set the culture that a particular column's values are rendered under?

Currently code like the following would show a price of 30 as 30¥ instead of $30.  In the code behind (not declaratively), when binding occurs I need to be abel to say that the price should render in the en-US culture, en-GB, etc.

<telerik:GridTemplateColumn UniqueName="ExamplePriceArea" ReadOnly="True" HeaderText="ExamplePrice">
    <ItemTemplate>
        <asp:Label ID="PriceLabel" runat="server" Text='<%# Eval("Price", "{0:C}") %>'></asp:Label>
    </ItemTemplate>
</telerik:GridTemplateColumn>

[Daniel]

Hello Jgill,

Please try the following approach:

<telerik:GridTemplateColumn UniqueName="ExamplePriceArea" ReadOnly="True" HeaderText="ExamplePrice">
    <ItemTemplate>
        <asp:Label ID="PriceLabel" runat="server" Text='<%# ConvertValue(Eval("Price")) %>'></asp:Label>
    </ItemTemplate>
</telerik:GridTemplateColumn>

protected string ConvertValue(object val)
{
    return ((double)val).ToString("C", CultureInfo.CreateSpecificCulture("en-US"));
}

Best regards,
Daniel
the Telerik team

[jgill]

Remarkably simple!  Works!