ADO.NET Questions and Answers

What are the different row versions available in table?

There are four types of Rowversions.

Current:

The current values for the row. This row version does not exist for rows with a RowState of Deleted.

Default :

The row the default version for the current DataRowState. For a DataRowState value of Added,

Modified or Current, the default version is Current. For a DataRowState of Deleted, the version is Original.
For a DataRowState value of Detached, the version is Proposed.
Original:The row contains its original values.
Proposed:
The proposed values for the row. This row version exists during an edit operation on a row, or for a
row that is not part of a DataRowCollection.