Thank you so much for your reply Mike.

 I have checked. UpdateMode property of wingrid is already set to OnRowChangeOrLostFocus. I have also tried changing it to OnRowChange. In both cases when I capture BeforeRowUpdate() event of grid, values in dataset are updated. I was thinking about getting the data again from database but it is not a workable solution because changing a row more than once without saving to database will cause problems.

I have also tried dropping a new grid so that may be I have chaged some property while attampting to get previous value. It shows the same behaviour. Am I missing somethig else?

You help is highly appreciated and acknowledged.

I'm not sure why that's not working. How are you accessing the value of the underlying data row inside BeforeRowUpdate? Are you using the ListObject as I suggested? 

What kind of data source are you using for the grid? Is it a DataTable?  I think the DataTable tracks changes so you might be able to get the old values from that, even if they have been updated by the grid.

I ran into the same issue as the OP and found out that when you're using a custom datasource, your custom object must implement IEditableObject.

The grid updates the cell value to the underlying object before BeforeRowUpdate is raised.  I am guessing this has to do with how BindingManager works (per Mike? or someone from Infragistics I think) with position changes which is mentioned in this forum somewhere.  Another workaround would be to catch BeforeCellUpdate.  I used it before but was trying to find a simpler way.  Now my UI code is simpler but custom object is more complex.  Pick your poison...

[UPDATE]

I realized after posting that my scenario is with respect to canceling an update in BeforeRowUpdate, which will not work without IEditableObject support.

[Update2]

I am getting some other issues implementing IEditableObject:

ex)

• Setting e.Cancel = true in BeforeRowUpdate for an AddRow, used to remove the row, now it doesn't.
• Also, I have TemplateAddRow on the bottom and either it comes and goes or the * icon is not correctly being set.  This does not occur when IEditableObject is not used.

So for now, I am going back to handling BeforeCellUpdate event.

p.s. Is there a code sample out there that implements IEditableObject which works correctly with UltraWinGrid?

yep, this is horrible, no matter what I set the grid's update mode as, the underneath datatable changed right away after the cell update event.

Any solution to prevent the grid to update the datasource ?

thanks

With the UpdateMode set to OnRowChangeOrLostFocus, and with a grid bound to a datatable, I have run into 2 scenarios if I place a breakpoint in the BeforeRowUpdate event and then make a change to a cell.  After changing the value of a cell, if I click on some other control (ie the grid loses focus), the .Value property reflects the previous cell value, and the .Text property reflects the current cell value (with formatting) - However, if I click onto some other row in the grid, the .Value property and the .Text property both reflect the current cell value.  I have set up a simple test form, and I cannot replicate my issue.  So there must be some properties we are setting in our base class that is causing this erratic behavior, but I don't know what property I could possible set to cause it.

So my problem is that I cannot reliably get the current value, and your problem is that you cannot seem to get the previous value.  With regard to your problem, the only way that I have reliably been able to trap the previous values of a grid row prior to update is to capture them in the AfterRowActivate event in some structure that is visible to the entire form, and then use those values in the BeforeRowUpdate event.  If you extend the grid, or if all of your forms are using a base class that you inherit from, you can set this up pretty easily in a standard way.