Hi Mike,

It is not working, the datatable or the listobject already been changed even set to rowchange mode.

thanks

I tested this out and it works fine for me. Can you provide a small sample project demonstrating the issue you are experiencing? Perhaps something else in your application is forcing an update.

Hi,

I'm sorry, I think I misunderstood the issue. The behavior you are getting here is correct. The UpdateMode property controls when the grid calls EndEdit and thus commits the changes into the row. But the values of each field as still written to the data source when you leave a cell.

If you want to get the original values from the rows, you can use the DataTable's GetChanges method.

Hi,

No, it won't work for datatable to getchanges, cuz there is no changes at all before the row update. It will simply return nothing. I m confused by the rowupdate mode caused the update to the datasource and the event didnt even supply the before update value for evaluation.

Any idea how can i accomplish that ?

thanks

caspers said:

No, it won't work for datatable to getchanges, cuz there is no changes at all before the row update

I'm not sure I follow you here. The whole crux of this discussion is that there ARE changes. The grid has already written the changes to the DataTable, so if the DataTable is not returning any changes at that point, then something is seriously wrong with the DataTable implementation.

I could use the DataRowVersion.Current instead of original for the most latest value before the row committed to datatable since the original is giving the very 1st value before calling acceptchanges.

Thanks for your help.

Okay, I did a little more research into this, and it looks like the indexer in the fields for a DataRow has some overloads which takes a DataRowVersion.

So if you do this, you get the modified value:

        void ultraGrid1_BeforeRowUpdate(object sender, CancelableRowEventArgs e)
        {            
            DataRowView drv = e.Row.ListObject as DataRowView;
            Debug.WriteLine(drv.Row["String 1"], "Original Value");
        }

But if you want the original value, you can do this:

        void ultraGrid1_BeforeRowUpdate(object sender, 
CancelableRowEventArgs e)

        {            

            DataRowView drv = e.Row.ListObject as DataRowView;

            Debug.WriteLine(drv.Row["String 1", DataRowVersion.Original], "Real Original Value");

        }

sorry not to make myself clear.

datatable getchanges will only return something if there is AT LEAST 1 row changes has been committed to it. For the case that if I make changes on multiple cells for the 1st time before the BeforeRowUpdate event, the row is not committed to the datatable, so datatable getchanges will return nothing back. Yet, the datatable values have been changed though.

For instance, follow the steps with my attached project given earlier, when you make changes on the 1st row and then click on 2nd row, the values of the datatable have changed but datatable getchanges return as NOTHING.

Thanks