How to force empty grid cells to a value

[Herman Gouw]

Hi,
I have to modifiy a working web application which I did back in 2009.

The application has some RadGrids which only accept numeric value on their cells.

Currently it is possible to leave the cells blank.

Can you please show me how to force empty grid cells to a certain value (in this case 0)?

The RadGrid cells are created as follows:

protected void rgOutages_ItemCreated(object sender, GridItemEventArgs e)

{

    if (e.Item is GridEditableItem && e.Item.IsInEditMode)

    {

        GridEditableItem item = (GridEditableItem)e.Item;

        GridNumericColumnEditor editor = (GridNumericColumnEditor)item.EditManager.GetColumnEditor("Unit_Outage_CountInflexible");

        editor.NumericTextBox.EmptyMessage = "0";

        editor.NumericTextBox.MaxLength = 8;

        editor.NumericTextBox.MaxValue = 999;

        editor.NumericTextBox.MinValue = 0;

        editor.NumericTextBox.NumberFormat.AllowRounding = true;

        editor.NumericTextBox.NumberFormat.DecimalDigits = 0;

        editor.NumericTextBox.Width = Unit.Percentage(100);

    }

}

[Shinu]

Hello Herman,

One suggestion is you can access the cell and set the text as shown below.
C#"

protected void RadGrid1_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e)
{
 if (e.Item is GridDataItem)
  {
     TableCell cell = (e.Item as GridDataItem)["UniqueName"];
     cell.Text = "0";
  }
}

-Shinu.

[Herman Gouw]

Hi,

Thanks for your reply but this is not really what I had in mind.
What needed is ... when the user blanks out any of the cell, I would like to force the empty cell to have a certain value (i.e. 0).

Regards,
Herman

[Veli]

Hi Herman,

In this case, you can use the OnValueChanging client event of the textboxes in your cells to reset the value to 0 if it is empty:

protected void rgOutages_ItemCreated(object sender, GridItemEventArgs e)
{
    if (e.Item is GridEditableItem && e.Item.IsInEditMode)
    {
        GridEditableItem item = (GridEditableItem)e.Item;
        GridNumericColumnEditor editor = (GridNumericColumnEditor)item.EditManager.GetColumnEditor("UnitPrice");
        //editor.NumericTextBox.EmptyMessage = "0";
        editor.NumericTextBox.MaxLength = 8;
        editor.NumericTextBox.MaxValue = 999;
        editor.NumericTextBox.MinValue = 0;
        editor.NumericTextBox.NumberFormat.AllowRounding = true;
        editor.NumericTextBox.NumberFormat.DecimalDigits = 0;
        editor.NumericTextBox.Width = Unit.Percentage(100);
        editor.NumericTextBox.ClientEvents.OnValueChanging = "numericValueChaning";
    }
}

<script type="text/javascript">
    function numericValueChaning(sender, args)
    {
        if (!args.get_newValue())
        {
            args.set_newValue("0");
        }
    }
</script>

Veli
the Telerik team