I would like to create an audit trail of certian cell values that are updated.
I have an oleDataBoundAdapter which I am invoking the Adapter.Update(Dataset) method on. If I create an event handler on the RowUpdate event, is it possible to retrieve the previous value for a cell that was changed so it can be saved to an audit table?
ADAdministrator Syncfusion Team September 7, 2004 08:09 AM
Not sure what RowUpdate event you are thinking about using.
You could use grid.RowLeave and check grid.Binder.IsEditing to see if there is a change pending. If so, it would likely be easier to get values from your datasource before the change.
int position = grid.Binder.RowIndexToPosition(e.RowIndex);
CurrencyManager cm = (CurrencyManager) grid.BindingContext[grid.DataSource, grid.DataMember];
DataRowView drv = ((DataView)cm.List)[position];
//from drv, you can get fields like drv["Col1"].