DataTable.ParentRelations Property
.NET Framework (current version)
Gets the collection of parent relations for this DataTable.
Assembly: System.Data (in System.Data.dll)
<BrowsableAttribute(False)> Public ReadOnly Property ParentRelations As DataRelationCollection
Property Value
Type: System.Data.DataRelationCollectionA DataRelationCollection that contains the parent relations for the table. An empty collection is returned if no DataRelation objects exist.
The following example uses the ParentRelations property to return each parent DataRelation in a DataTable. Each relation is then used as an argument in the GetParentRows method of the DataRow to return an array of rows. The value of each column in the row is then printed.
Private Sub GetChildRowsFromDataRelation(table As DataTable) Dim rowArray() As DataRow Dim relation As DataRelation, row As DataRow Dim column As DataColumn, i As Integer For Each relation In table.ParentRelations For Each row In table.Rows rowArray = row.GetParentRows(relation) ' Print values of rows. For i = 0 To rowArray.Length - 1 For Each column In table.Columns Console.WriteLine(rowArray(i)(column)) Next column Next i Next row Next relation End Sub
.NET Framework
Available since 1.1
Available since 1.1
Show: