Validate Inline Insert and Update

[Jidesh Guptha]

Hi,

I am using the Inline insert and update feature of RadGrid, I have to validate the values entered if its blank i have to set the old value. Pls help me how to go about it.

regards
Jidesh

[Veli]

Hello Jidesh,

You can use RadGrid's UpdateCommand to extract your edited values, check if any of them is null and restore the previous saved values:

protected void RadGrid1_UpdateCommand(object sender, GridCommandEventArgs e)
{
    GridEditableItem editItem = (GridEditableItem)e.Item;

    //extract the edited values in a Hashtable
    Hashtable values = new Hashtable();
    editItem.ExtractValues(values);

    //get the saved old values before editing
    Hashtable oldValues = (Hashtable)editItem.SavedOldValues;

    //will hold the names of all fields that have null values
    List<object> nullFieldNames = new List<object>();

    //get the field names  that have null values
    foreach (DictionaryEntry entry in values)
    {
        if (entry.Value == null)
        {
            nullFieldNames.Add(entry.Key);
        }
    }

    //replace null with the original values
    foreach (object key in nullFieldNames)
    {
        values[key] = oldValues[key];
    }

    //at this point Hashtable "values" contains the edited values
    //as well as the original values for all fields that had null
}

Veli
the Telerik team

[Mark]

How can you do the same thing but not using the updatecommand.

I have my own command "SaveAll" which is saving multiple rows at a time, how do i get the SavedOldValues for these rows?

Currently the SavedOldValues just has null for the values.

[Veli]

Hi Mark,

Using the same approach, only you need to loop over all the edited items in RadGrid:

protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)
{
    if (e.CommandName == "SaveAll")
    {
        foreach (GridItem item in RadGrid1.EditItems)
        {
            GridEditableItem editItem = (GridEditableItem)item;

            //extract the edited values in a Hashtable
            Hashtable values = new Hashtable();
            editItem.ExtractValues(values);

            //get the saved old values before editing
            Hashtable oldValues = (Hashtable)editItem.SavedOldValues;

            //will hold the names of all fields that have null values
            List<object> nullFieldNames = new List<object>();

            //get the field names  that have null values
            foreach (DictionaryEntry entry in values)
            {
                if (entry.Value == null)
                {
                    nullFieldNames.Add(entry.Key);
                }
            }

            //replace null with the original values
            foreach (object key in nullFieldNames)
            {
                values[key] = oldValues[key];
            }

            //at this point Hashtable "values" contains the edited values
            //as well as the original values for all fields that had null
        }
    }
}

Veli
the Telerik team