Accessing Delete Row Information
Posted: Thursday, October 28, 2004 3:06 PM
by
datasetfaq
Filed under: Typed Datasets, Untyped Datasets
I recently had the need to access the information in a row marked as “Deleted“ in a DataSet as part of the update process. The first attempted netted a DeletedRowInaccessibleException exception. It is not possible to access the current information for a data row once the row has been deleted.
However, the very notion that there is 'current' information is a clue to the solution. If it were possible to specify the version of the information to be retrieve, then it would be possible to use the original information. As it turns out, this can be done through the indexer on a DataRow. While the normal access mechanism for a DataRow would be
row[”ColumnName”]
to retrieve the original information in a deleted row, the desired version must be specified, as seen here
row[”ColumnName”, DataRowVersion.Original]