RowState Property

DataRow.RowState Property


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

Namespace:   System.Data
Assembly:  System.Data (in System.Data.dll)

public DataRowState RowState { get; }

Property Value

Type: System.Data.DataRowState

One of the DataRowState values.

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.

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;

.NET Framework
Available since 1.1
Return to top
© 2015 Microsoft