Accessing datarow information from deleted datarow

[dgerdner]

I have a datagrid bound to a datatable, and allow the user to make changes to the data in the grid. When the choose to "Save" changes I assumed I could loop through the datatable, and make database calls based on the DataRowState.

This works find for Inserts and Updates, but when I try to get the primary key column on a Deleted row, I receive this error:

"Deleted row information cannot be accessed through the row"

Certainly this is a common methodology. How can I get information on a delted datarow?

 

[SHelton]

You have to specify DataRowVersion.Original if the row is deleted:

dr["Column1", DataRowVersion.Original].ToString();