Create a History table

[dr223]

Hi,

I have a datagridview (DgvPracExcl) which at runtime allows a user to update the records to a table in the database.

Now, I want to save a history prior to the update. Therefore, create a history table..

Any ideas...

Thanks

[benuto]

my first idea is create handle keydown on datagridview.
on first keydown event store old value in memory , on enter/end edition compare with actual value, if different then log in your history...
This way you can log all rows or selected cells

Am I right?

[dglienna]

as long as the event was ONE KEYSTROKE only. not practical

[benuto]

why? any clue?

then mayby cell.enter and cell.leave?

as I see, you have got solution.

benek

[dglienna]

Trap the ENTER key, the ARROW KEYS, and most importantly handle the BACKSPACE correctly. There are many samples. Cell Enter and Leave might or might not process the data before leaving

[benuto]

then maybe cellchanged?
previous values are still in datatable, so u can compare these and logs