DataRow::GetParentRows Method (DataRelation^, DataRowVersion)
Gets the parent rows of a DataRow using the specified DataRelation, and DataRowVersion.
Assembly: System.Data (in System.Data.dll)
Parameters
- relation
-
Type:
System.Data::DataRelation^
The DataRelation to use.
- version
-
Type:
System.Data::DataRowVersion
One of the DataRowVersion values specifying the version of the data to get.
Return Value
Type: array<System.Data::DataRow^>^An array of DataRow objects or an array of length zero.
| Exception | Condition |
|---|---|
| ArgumentException | The DataRelation does not belong to this row's DataSet. |
| ArgumentNullException | The row is null. |
| InvalidConstraintException | The relation's child table is not the table the row belongs to. |
| RowNotInTableException | The row does not belong to a DataTable. |
| VersionNotFoundException | The row does not have the requested DataRowVersion. |
In a DataSet, the collection of all parent DataRelation objects for the data set is returned by the GetParentRows method.
The DataTable also contains a collection of DataRelation objects, returned by the ParentRelations property.
Use the HasVersion property to determine whether the DataRowVersion that you want exists.
The following example uses the GetParentRows to return the child DataRow objects for every child DataRelation in a DataTable. The value of each column in the row is then printed.
Private Sub GetChildRowsFromDataRelation(table As DataTable, ver As DataRowVersion) Dim relation As DataRelation Dim arrRows() As DataRow Dim row As DataRow Dim i As Integer Dim column As DataColumn For Each relation In table.ParentRelations For Each row In table.Rows arrRows = row.GetParentRows(relation, ver) ' Print values of rows. For i = 0 To arrRows.GetUpperBound(0) For Each column in table.Columns Console.WriteLine(arrRows(i)(column.ColumnName)) Next column Next i Next row Next relation End Sub
Available since 1.1