DataRow.RowState Property

Definition

Namespace:

System.Data

Assemblies:

netstandard.dll, System.Data.Common.dll

Source:

DataRow.cs

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

C#

public System.Data.DataRowState RowState { get; }

Property Value

DataRowState

One of the DataRowState values.

Examples

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.

C#

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

Remarks

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

• AcceptChanges()
• BeginEdit()
• Add(DataRow)
• CancelEdit()
• DataTable
• DataRowView
• Delete()
• EndEdit()
• NewRow()
• SetAdded()
• SetModified()