The DataRow class represents a single record in a
database. You can access the columns of the record using the indexer,
which is also the indexer for the class. You can retrieve or set a
column value using a zero-based index or the column name. Using the
name is slightly slower because it requires a behind-the-scenes
hashtable lookup. The indexer has two overloads that allow you to
specify the row version to retrieve using the
DataRowVersion enumeration. For example:
Console.Write(row["ID"], DataRowVersion.Original);
retrieves the original data source value, even if it has been
modified. If you omit the version, you receive the current
(DataRowVersion.Current ) value.
Alternatively, you can get or set values for all the rows at one time
using the ItemArray property. The
ItemArray is a one-dimensional array, in which
each item contains the value for a field, in the same order as the
DataRow . The ItemArray
doesn't include the names of the field. You can also
retrieve the state of the row (indicating if it has been added,
deleted, and so on), using the RowState property.
The DataRow allocates space for error information.
You can set or retrieve a string that describes an error using the
SetColumnError( ) or GetColumnError(
) methods. To determine if the row has any errors, simply
inspect the Boolean HasErrors property or retrieve
the DataColumn objects with errors using the
GetColumnsInError( ) method.
The GetParentRow( ) and GetChildRows(
) methods allow you to retrieve related rows if you have
defined a parent-child relationship using a
DataRelation object.
The DataRow also includes methods for managing the
editing process, including BeginEdit( ) ,
EndEdit( ) , and CancelEdit( )
. BeginEdit( ) suspends row validation until
either EndEdit( ) or CancelEdit(
) is called, allowing the rows to temporarily violate
referential integrity.
public class DataRow {
// Protected Constructors
protected internal DataRow( DataRowBuilder builder);
// Public Instance Properties
public bool HasErrors{get; }
public object[ ] ItemArray{set; get; }
public string RowError{set; get; }
public DataRowState RowState{get; }
public DataTable Table{get; }
public object this[string columnName, DataRowVersion version]{get; }
public object this[DatraColumn column, DataRowVersion version]{get; }
public object this[string columnName]{set; get; }
public object this[int columnIndex]{set; get; }
public object this[int columnIndex, DataRowVersion version]{get; }
public object this[DataColumn column]{set; get; }
// Public Instance Methods
public void AcceptChanges( );
public void BeginEdit( );
public void CancelEdit( );
public void ClearErrors( );
public void Delete( );
public void EndEdit( );
public DataRow[ ] GetChildRows( DataRelation relation);
public DataRow[ ] GetChildRows(DataRelation relation, DataRowVersion version);
public DataRow[ ] GetChildRows( string relationName);
public DataRow[ ] GetChildRows(string relationName, DataRowVersion version);
public string GetColumnError( DataColumn column);
public string GetColumnError( int columnIndex);
public string GetColumnError( string columnName);
public DataColumn[ ] GetColumnsInError( );
public DataRow GetParentRow( DataRelation relation);
public DataRow GetParentRow(DataRelation relation, DataRowVersion version);
public DataRow GetParentRow( string relationName);
public DataRow GetParentRow(string relationName, DataRowVersion version);
public DataRow[ ] GetParentRows( DataRelation relation);
public DataRow[ ] GetParentRows(DataRelation relation, DataRowVersion version);
public DataRow[ ] GetParentRows( string relationName);
public DataRow[ ] GetParentRows(string relationName, DataRowVersion version);
public bool HasVersion( DataRowVersion version);
public bool IsNull( DataColumn column);
public bool IsNull(DataColumn column, DataRowVersion version);
public bool IsNull( int columnIndex);
public bool IsNull( string columnName);
public void RejectChanges( );
public void SetColumnError(DataColumn column, string error);
public void SetColumnError(int columnIndex, string error);
public void SetColumnError(string columnName, string error);
public void SetParentRow( DataRow parentRow);
public void SetParentRow(DataRow parentRow, DataRelation relation);
// Protected Instance Methods
protected void SetNull( DataColumn column);
