[Solved] Batch edit update from code behind

[Alyssa]

Hi,
How to do batch edit update from code behind and not through allowautomaticupdates.

[Princy]

Hi Alyssa,

You can use the OnBatchEditCommand event of the radgrid to obtain the required scenario. Using the GridBatchEditingCommandType we can identify the events. Please try the following code snippet.

ASPX:

<telerik:RadGrid ID="RadGrid1" runat="server" OnBatchEditCommand="RadGrid1_BatchEditCommand">
 <MasterTableView EditMode="Batch" CommandItemDisplay="Top" DataKeyNames="ID">
    <BatchEditingSettings OpenEditingEvent="Click" />

C#:

protected void RadGrid1_BatchEditCommand(object sender, GridBatchEditingEventArgs e)
{
    foreach (GridBatchEditingCommand command in e.Commands)
    {
        if ((command.Type == GridBatchEditingCommandType.Update))
        {
            Hashtable newValues = command.NewValues;
            Hashtable oldValues = command.OldValues;
            string ID = newValues["ID"].ToString();
            string Name = newValues["Name"].ToString();

            try
            {
               //Code to Update
            }
            catch (Exception ex)
            {
              // Exception Message
            }
        }
    }
}

Thanks,
Princy