Edit this page

Conditional Formatting

The object model and events in RadGrid *provide opportunities for customization and conditional formatting of grid elements. In order to format some data based on column type, you need to use the properties of the respective column. *GridBoundColumn** for example has DataFormatString property that you can use to format the appearance of the data in the cells of that column.The formatting is based on the general formatting rules in .NET, i.e. Telerik RadGrid *uses internally the *string.Format(string, args )** function. This way you should just provide the corresponding format string in the DataFormatString property.For example the format string "{0:C}" would format the values in the cells of the column as currency.

The example below shows how to use conditional formatting in a sample mailbox implementation. Selected Items and recently received mail are marked red:

Conditional Formatting

protected void RadGrid1_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e)
{
    //Is it a GridDataItem
    if (e.Item is GridDataItem)
    {
        //Get the instance of the right type
        GridDataItem dataBoundItem = e.Item as GridDataItem;

        //Check the formatting condition
        if (int.Parse(dataBoundItem["Size"].Text) > 100)
        {
            dataBoundItem["Received"].ForeColor = Color.Red;
            dataBoundItem["Received"].Font.Bold = true;
            //Customize more...
        }
    }
}
Protected Sub RadGrid1_ItemDataBound(ByVal sender As Object, ByVal e As Telerik.Web.UI.GridItemEventArgs)
    'Is it a GridDataItem
    If (TypeOf (e.Item) Is GridDataItem) Then
        'Get the instance of the right type
        Dim dataBoundItem As GridDataItem = e.Item

        'Check the formatting condition
        If (Integer.Parse(dataBoundItem("Size").Text) > GridItemType.Footer) Then
            dataBoundItem("Received").ForeColor = Color.Red
            dataBoundItem("Received").Font.Bold = True
            'Customize more...
        End If
    End If
End Sub
note

When you apply Skin for the grid the custom style attributes set for the some of the grid rows will be overridden by the skin definitions. If you want to customize the appearance for some of the grid rows when Skin is assigned to the control, you will need to define your own CssClass for the corresponding row and apply the style preferences in its body.>

Below is an example which will alter the look and feel for items which has text Mexico in their Country column:

  <pre xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
<style type="text/css">
  .MyMexicoRowClass
  {
    background-color: aqua;
    font-size: 16px;
    font-family: Arial;
  }
</style>       
</pre>

And in the code-behind:

protected void RadGrid1_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e)
{
    if (e.Item is GridDataItem)
    {
        GridDataItem dataItem = e.Item as GridDataItem;
        if (dataItem["Country"].Text == "Mexico")
            dataItem.CssClass = "MyMexicoRowClass";
    }
}
Protected Sub RadGrid1_ItemDataBound(ByVal sender As Object, ByVal e As Telerik.Web.UI.GridItemEventArgs) Handles RadGrid1.ItemDataBound
    If (TypeOf e.Item Is GridDataItem) Then
        Dim dataItem As GridDataItem = CType(e.Item, GridDataItem)
        If (dataItem("Country").Text = "Mexico") Then
            dataItem.CssClass = "MyMexicoRowClass"
        End If
    End If
End Sub