Export (0) Print
Expand All

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);

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

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

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

    row.Delete();
    // 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"));
    table.Columns.Add(dcFirstName);
    return table;
}

.NET Framework

Supported in: 4.6, 4.5, 4, 3.5, 3.0, 2.0, 1.1

.NET Framework Client Profile

Supported in: 4, 3.5 SP1

XNA Framework

Supported in: 3.0, 2.0, 1.0
Show:
© 2015 Microsoft