This enumeration indicates the state of a row (returned by the DataRow.RowState property). Added indicates a row inserted into the DataTable but not yet committed to the data source. Deleted indicates the row was deleted, but the change has not been applied to the data source, and Modified indicates the row has been edited but the changes have not been committed. Detached indicates a new row (created with DataTable.NewRow( )) but not yet inserted into the table (with DataRowCollection.Add( )).

public enum DataRowState {

   Detached = 0x00000001,

   Unchanged = 0x00000002,

   Added = 0x00000004,

   Deleted = 0x00000008,

   Modified = 0x00000010



System.Object System.ValueType System.Enum(System.IComparable, System.IFormattable, System.IConvertible) DataRowState

Returned By


Passed To

DataSet.{GetChanges( ), HasChanges( )}, DataTable.GetChanges( )

Get ADO.NET in a Nutshell now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.