Gets the child rows of this DataRow using the specified DataRelation and the specified DataRowVersion
[Visual Basic] Overloads Public Function GetChildRows( _ ByVal relation As DataRelation, _ ByVal version As DataRowVersion _ ) As DataRow () [C#] public DataRow[] GetChildRows( DataRelation relation, DataRowVersion version ); [C++] public: DataRow* GetChildRows( DataRelation* relation, DataRowVersion version ) []; [JScript] public function GetChildRows( relation : DataRelation, version : DataRowVersion ) : DataRow[];
An array of DataRow objects.
Exception Type | Condition |
---|---|
RowNotInTableException | The row doesn't belong to the table. |
ArgumentNullException | The relation is a null reference (in Visual Basic Nothing). |
ArgumentException | The relation and row don't belong to the same table. |
VersionNotFoundException | The row doesn't have the requested DataRowVersion. |
In a DataSet, the collection of all DataRelation objects for the data set is returned by the GetChildRelations method.
The DataTable also contains a collection of DataRelation objects, also returned by the ChildRelations property.
Use the HasVersion property to determine if the desired DataRowVersion exists.
The following example uses the GetChildRows to return the child DataRow objects for every child DataRelation in a DataTable. The value of each column in the row is then printed.
[Visual Basic]
Private Sub GetChildRowsFromDataRelation(myTable As DataTable, ver As DataRowVersion) Dim dr As DataRelation Dim arrRows() As DataRow Dim r As DataRow Dim i As Integer Dim dc As DataColumn For Each dr In myTable.ChildRelations For Each r In myTable.Rows arrRows = r.GetChildRows(dr, ver) ' Print values of rows. For i = 0 To UBound(arrRows) For Each dc In myTable.Columns Console.WriteLine(arrRows(i)(dc)) Next dc Next i Next r Next dr End Sub
DataRow Class | DataRow Members | System.Data Namespace | DataRow.GetChildRows Overload List | ChildRelations | DataRelation | DataRowVersion | GetParentRow | GetParentRows | Relations