GridBoundColumn - do not show zero for number columns?

[Paweł]

Let's have the following pseudo-code:

<telerik:RadGrid>
        <Columns>
            <telerik:GridBoundColumn DataField="SomeInt32Column" />
        </Columns>
</telerik:RadGrid>

The default behaviour is:
if null - show empty string
else - show number

What i would like to get is:
if null or zero - show empty string
else - show number

I was trying to accomplish it with DataFormatString, but without success so far. Is there a silmple way to do this?

[Shinu]

Hi Pawet,

Try the following code snippet to achieve the desired scenario.

ASPX:

 <telerik:GridBoundColumn DataField="RollNo"  HeaderText="RollNo"     UniqueName="RollNo">
                    </telerik:GridBoundColumn>

CS:

  protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
    {
        if (e.Item is GridDataItem)
        {
            GridDataItem dataitem = (GridDataItem)e.Item;
            string strVal = dataitem["RollNo"].Text.ToString();
            if((strVal=="0")||(strVal==null))
            {
                dataitem["RollNo"].Text ="&nbsp";
            }
        }

    }

Thanks
Shinu.

[Paweł]

Thanks, Shinu.
That will certainly help, although I hoped that there is a cleaner way to do it. Thanks anyway!