Radgrid Column Format String pronlem....

[Moksha]

Hi ...

I have set column formatstring ="0####0.00".

When my Value of column is Null or blank then column value should be 0.00 but it dispaly blank. can you please suggest me soluction for same.

[Princy]

Hello Moksha,

One option is setting the call value like below when the cell  is blank.

C#:

protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
   {
      if (e.Item is GridDataItem)
       {
           GridDataItem item = (GridDataItem)e.Item;
           if (item["ColumnUniqueName"].Text == " ")
             item["ColumnUniqueName"].Text = "0.00";
       }
   }

Thanks,
Princy.

[Moksha]

Hi Princy,

In my case this case grid id dynamically created so column name is different for different options.

[Princy]

Hello Moksha,

If so try the following code snippet.

protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
   {
       if (e.Item is GridDataItem)
       {
           GridDataItem item = (GridDataItem)e.Item;
           foreach (GridColumn col in RadGrid1.Columns)
           {
               if (item[col.UniqueName].Text == " ")
                   item[col.UniqueName].Text = "0.00";
           }
           foreach (GridColumn col in RadGrid1.MasterTableView.AutoGeneratedColumns)//if columns are AutoGenerated
           {
               if (item[col.UniqueName].Text ==" ")
                   item[col.UniqueName].Text = "0.00";
           }
        }
  }

Thanks,
Princy.