C#-App: Audit trail of records updated using DGV bound to a dataset.

[mnarewec]

Hi Team
I am instructed to keep an audit trail of when a record is updated/deleted/ or inserted.

The user is using a datagridview to update tables which is bound to a dataset.
. How can I capture these audit trail individually by still using datagridview and the dataset update method?

Your help will be greately appreciated.

Marsh

[kenobewan]

What have you tried? One way is to write the user and time to DB...

[mnarewec]

Thanks
I want to capture user, time, values before the update, values after the update, of each record that was updated into the dB. Therefore, 3 months down the line I would want to find out who deleted the record, I can pin point the user who did it to the record.

When doing the Update, Delete, and Insert on a single record at a time then it is easier. However, I want to find out how when using DGV and Dataset I can capture audit of records individually.