DataViewRowState Enum

Definition

Namespace:

System.Data

Assemblies:

netstandard.dll, System.Data.Common.dll

Describes the version of data in a DataRow.

This enumeration supports a bitwise combination of its member values.

C#

[System.Flags]
public enum DataViewRowState

Inheritance

Object

ValueType

Enum

DataViewRowState

Attributes

FlagsAttribute

Fields

Name	Value	Description
None	0	None.
Unchanged	2	An unchanged row.
Added	4	A new row.
Deleted	8	A deleted row.
ModifiedCurrent	16	A current version of original data that has been modified (see ModifiedOriginal).
CurrentRows	22	Current rows including unchanged, new, and modified rows. By default, DataViewRowState is set to CurrentRows.
ModifiedOriginal	32	The original version of the data that was modified. (Although the data has since been modified, it is available as ModifiedCurrent).
OriginalRows	42	Original rows including unchanged and deleted rows.

Examples

In the following example DataTable is created with a single column. The data is changed, and the RowStateFilter of the DataView is set to display different row sets, depending on the DataViewRowState.

C#

static private void DemonstrateRowState()
{
    // Create a DataTable with one column.
    DataTable dataTable = new DataTable("dataTable");
    DataColumn dataColumn = new DataColumn("dataColumn");
    dataTable.Columns.Add(dataColumn);

    // Add ten rows.
    DataRow dataRow;
    for (int i = 0; i < 10; i++)
    {
        dataRow = dataTable.NewRow();
        dataRow["dataColumn"] = "item " + i;
        dataTable.Rows.Add(dataRow);
    }
    dataTable.AcceptChanges();

    // Create a DataView with the table.
    DataView dataView = new DataView(dataTable);

    // Change one row's value:
    dataTable.Rows[1]["dataColumn"] = "Hello";

    // Add one row:
    dataRow = dataTable.NewRow();
    dataRow["dataColumn"] = "World";
    dataTable.Rows.Add(dataRow);

    // Set the RowStateFilter to display only added and modified rows.
    dataView.RowStateFilter = DataViewRowState.Added
        | DataViewRowState.ModifiedCurrent;

    // Print those rows. Output = "Hello" "World";
    PrintView(dataView, "ModifiedCurrent and Added");

    // Set filter to display on originals of modified rows.
    dataView.RowStateFilter = DataViewRowState.ModifiedOriginal;
    PrintView(dataView, "ModifiedOriginal");

    // Delete three rows.
    dataTable.Rows[1].Delete();
    dataTable.Rows[2].Delete();
    dataTable.Rows[3].Delete();

    // Set the RowStateFilter to display only Added and modified rows.
    dataView.RowStateFilter = DataViewRowState.Deleted;
    PrintView(dataView, "Deleted");

    //Set filter to display only current.
    dataView.RowStateFilter = DataViewRowState.CurrentRows;
    PrintView(dataView, "Current");

    // Set filter to display only unchanged rows.
    dataView.RowStateFilter = DataViewRowState.Unchanged;
    PrintView(dataView, "Unchanged");

    // Set filter to display only original rows.
    dataView.RowStateFilter = DataViewRowState.OriginalRows;
    PrintView(dataView, "OriginalRows");
}

static private void PrintView(DataView dataView, string label)
{
    Console.WriteLine("\n" + label);
    for (int i = 0; i < dataView.Count; i++)
    {
        Console.WriteLine(dataView[i]["dataColumn"]);
    }
}

Remarks

The DataViewRowState values are used either to retrieve a particular version of data from a DataRow, or to determine what versions exist.

Set the RowStateFilter property of the DataView to specify which version or versions of data you want to view.

You can use the Boolean operator Or with the values to get more than one version.

The DataTable uses DataViewRowState in the Select method.

Applies to

See also

• DataRow
• DataView
• Select()