[Solved] Change DataFormatString for cell based on another cell

[Curtis Hunter]

I have a situation where one column can have either dollar amounts or plain decimal amounts (these are used as multipliers) and I need to change the DataFormatString for the cell based on the value of another cell in the row. 

We are binding the grid in the OnNeedDataSource event to a IList<>.  I've looked at the ItemDataBound event walk throughs but I can't seem to figure out how to access the DataFormatString.

How can I do this?

Thanks
Curtis

[Daniel]

Hello Curtis,

DataFormatString affects the whole column therefore it isn't suitable for this scenario. You can use String.Format to format each cell on ItemDataBound.

protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
{
    if (e.Item is GridDataItem)
    {
        double myValue = (double)DataBinder.Eval(e.Item.DataItem, "myValue");
        GridDataItem item = e.Item as GridDataItem;

        if (something)
            item["myColumn"].Text = String.Format("{0:n}", myValue);
        else
            item["myColumn"].Text = String.Format("{0:c}", myValue);
    }
}

I hope this helps.

Best regards,
Daniel
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[Curtis Hunter]

Thanks Daniel!

That worked like a charm.  I was so focused on DataFormatString that I didn't even think about just dealing with the .Text directly.

Curtis