BindingSource, Archiving Old record before saving new changes

[Rob Dob]

Hi,

I have fields on a form bound to a BindingSource, I would like to be able
to archive the orginal record prior to saving the most recent changes to the
database. What is the recommended approach to doing this? Is there an easy
way to view both the changed and unchanged state of the same datarow.

Thanks.

 

[Brian Smith]

you can get the whole of a row with Select, thus:

myTable.Select("", "", DataViewRowState.OriginalRows);

or individual columns can be queried using:
dataRow[index, DataRowVersion.Original];

brian smith