DataRow::GetParentRows Method (DataRelation^)
.NET Framework (current version)
Gets the parent rows of a DataRow using the specified DataRelation.
Assembly: System.Data (in System.Data.dll)
Parameters
- relation
-
Type:
System.Data::DataRelation^
The DataRelation to use.
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. |
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.
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) 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) ' 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
.NET Framework
Available since 1.1
Available since 1.1
Show: