DataRow.RowState Property


Gets the current state of the row with regard to its relationship to the DataRowCollection.

 property System::Data::DataRowState RowState { System::Data::DataRowState get(); };
public System.Data.DataRowState RowState { get; }
member this.RowState : System.Data.DataRowState
Public ReadOnly Property RowState As DataRowState

Property Value

One of the DataRowState values.


The following example first creates a new DataTable with one column, and 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 table = MakeTable();
       DataRow row;

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

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

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

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

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

   private DataTable MakeTable()
       // Make a simple table with one column.
       DataTable table = new DataTable("table");
       DataColumn dcFirstName = new DataColumn(
           "FirstName", Type.GetType("System.String"));
       return table;
Private Sub DemonstrateRowState()
    ' Run a function to create a DataTable with one column.
    Dim table As DataTable = MakeTable()
    Dim row As DataRow 
    ' Create a new DataRow.
    row = table.NewRow()
    ' Detached row.
    Console.WriteLine("New Row " & row.RowState)
    ' New row.
    Console.WriteLine("AddRow " & row.RowState)
    ' Unchanged row.
    Console.WriteLine("AcceptChanges " & row.RowState)
    row("FirstName") = "Scott"
    ' Modified row.
    Console.WriteLine("Modified " & row.RowState)
    ' Deleted row.
    Console.WriteLine("Deleted " & row.RowState)
 End Sub
 Private Function MakeTable() As DataTable
    ' Make a simple table with one column.
    Dim table As New DataTable("table")
    Dim dcFirstName As New DataColumn( _
        "FirstName", Type.GetType("System.String"))
    MakeTable = table
 End Function


The value of the RowState depends on two factors: the kind of operation has been performed on the row, and whether AcceptChanges has been called on the DataRow.

Applies to

See also