DataRowState DataRowState DataRowState DataRowState Enum


Gets the state of a DataRow object.

This enumeration has a FlagsAttribute attribute that allows a bitwise combination of its member values.

public enum class DataRowState
public enum DataRowState
type DataRowState = 
Public Enum DataRowState


Added Added Added Added 4

The row has been added to a DataRowCollection, and AcceptChanges() has not been called.

Deleted Deleted Deleted Deleted 8

The row was deleted using the Delete() method of the DataRow.

Detached Detached Detached Detached 1

The row has been created but is not part of any DataRowCollection. A DataRow is in this state immediately after it has been created and before it is added to a collection, or if it has been removed from a collection.

Modified Modified Modified Modified 16

The row has been modified and AcceptChanges() has not been called.

Unchanged Unchanged Unchanged Unchanged 2

The row has not changed since AcceptChanges() was last called.


The following example first creates a new DataTable with one column, then creates a single DataRow. As the DataRow is created, added, modified, and deleted, its RowState is printed.

private void DemonstrateRowState() {
   //Run a function to create a DataTable with one column.
   DataTable myTable = MakeTable();
   DataRow myRow;

   // Create a new DataRow.
   myRow = myTable.NewRow();
   // Detached row.
   Console.WriteLine("New Row " + myRow.RowState);

   // New row.
   Console.WriteLine("AddRow " + myRow.RowState);

   // Unchanged row.
   Console.WriteLine("AcceptChanges " + myRow.RowState);

   myRow["FirstName"] = "Scott";
   // Modified row.
   Console.WriteLine("Modified " + myRow.RowState);

   // Deleted row.
   Console.WriteLine("Deleted " + myRow.RowState);

private DataTable MakeTable(){
   // Make a simple table with one column.
   DataTable dt = new DataTable("myTable");
   DataColumn dcFirstName = new DataColumn("FirstName", Type.GetType("System.String"));
   return dt;
Private Sub DemonstrateRowState()
    'Run a function to create a DataTable with one column.
    Dim dataTable As DataTable = MakeTable()
    Dim dataRow As DataRow

    ' Create a new DataRow.
    dataRow = dataTable.NewRow()
    ' Detached row.
    Console.WriteLine(String.Format("New Row {0}", dataRow.RowState))

    ' New row.
    Console.WriteLine(String.Format("AddRow {0}", dataRow.RowState))

    ' Unchanged row.
    Console.WriteLine(String.Format("AcceptChanges {0}", dataRow.RowState))

    dataRow("FirstName") = "Scott"
    ' Modified row.
    Console.WriteLine(String.Format("Modified {0}", dataRow.RowState))

    ' Deleted row.
    Console.WriteLine(String.Format("Deleted {0}", dataRow.RowState))
End Sub

Private Function MakeTable() As DataTable
    ' Make a simple table with one column.
    Dim dt As New DataTable("dataTable")
    Dim firstName As New DataColumn("FirstName", _
    Return dt
End Function


The DataRowState enumeration is returned by the RowState property of the DataRow class.

Applies to

See Also