ADO.NET Data Row Version values

DataRowVersion value	Description
Current	The current values for the row. This row version does not exist for rows with a RowState of Deleted.
Default	The default row version for a particular row. The default row version for an Added, Modified, or Unchanged row is Current. The default row version for a Deleted row is Original. The default row version for a Detached row is Proposed.
Original	The original values for the row. This row version does not exist for rows with a RowState of Added.
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.

ADO.NET Row State Versus Row Versions

Row state indicates the status of a row whereas Row versions maintain the values stored in a row as it is modified, including current, original, and default values.

Example :

Once you have made a modification to a column in a row, row will have a row state of Modified, and two row versions: Current, which contains the current row values, and Original, which contains the row values before the column was modified.

What are various value of RowState of ADO.NET DataRow object ?

Values of RowState of ADO.NET DataRow object :

Sl No	RowState value	Description
1	Unchanged	No changes have been made.
2	Added	The row has been added to the table
3	Modified	Some element of the row has been changed.
4	Deleted	The row has been deleted from a table
5	Detached	The row is not part of any DataRowCollection.

Explain RowState property in ADO.NET DataRow object ?

RowState property of DataRow object determines the current state of the row. Various RowState values are : Unchanged , Added , Modified , Deleted , Detached