[Solved] how to log "oldvalue" and "newvalue" when grid inserted/deleted/updated

[Andrey]

    Hello.
I used RadGrid with declarative binding to SqlDataSource.
I need to store old and new values in log table when I make insert/delete/update operation.
I can handle RadGrid_UpdateCommand event like this:

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;

    //insert  data to Database
    //...
}

but this event fires before real operation in database and I don`t know if there is an error in current operation in DB or not.
Can anybody help?

[Pavlina]

Hello Andrey,

Please find attached to this message a simple working project that demonstrates how you can achieve the desired functionality. Give it a try and let me know if it helps.

Best wishes,
Pavlina
the Telerik team

[Andrey]

  Thanks, Pavlina. It`s really help me!