DataRowState Enumeration
Gets the state of a DataRow object.
This enumeration has a FlagsAttribute attribute that allows a bitwise combination of its member values.
Assembly: System.Data (in System.Data.dll)
| Member name | Description | |
|---|---|---|
| Added | The row has been added to a DataRowCollection, and AcceptChanges has not been called. | |
| Deleted | ||
| Detached | The row has been created but is not part of any DataRowCollection. A DataRow is in this state immediately after it has been created and before it is added to a collection, or if it has been removed from a collection. | |
| Modified | The row has been modified and AcceptChanges has not been called. | |
| Unchanged | The row has not changed since AcceptChanges was last called. |
The following example first creates a new DataTable with one column, 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 myTable = MakeTable(); DataRow myRow; // Create a new DataRow. myRow = myTable.NewRow(); // Detached row. Console.WriteLine("New Row " + myRow.RowState); myTable.Rows.Add(myRow); // New row. Console.WriteLine("AddRow " + myRow.RowState); myTable.AcceptChanges(); // Unchanged row. Console.WriteLine("AcceptChanges " + myRow.RowState); myRow["FirstName"] = "Scott"; // Modified row. Console.WriteLine("Modified " + myRow.RowState); myRow.Delete(); // Deleted row. Console.WriteLine("Deleted " + myRow.RowState); } private DataTable MakeTable(){ // Make a simple table with one column. DataTable dt = new DataTable("myTable"); DataColumn dcFirstName = new DataColumn("FirstName", Type.GetType("System.String")); dt.Columns.Add(dcFirstName); return dt; }
Available since 1.1