Can I capture data?

[vnarod]

Can I somehow get row before update (using ExecuteNonQuery) command changes it? I need to save previous value in log table

 

[a_jam_sandwich]

Run a INSERT with the values before the update then run the update

2 Querys

Andy

 

[Nerseus]

If youre using a DataSet, you can get at both the original data and the changed data. Perform you action (INSERT, UPDATE, DELETE) but dont call AcceptChanges. Use the DataSet to figure out what the action was and how to log it.

-Nerseus