This documentation is archived and is not being maintained.

DataSet.Relations Property

Get the collection of relations that link tables and allow navigation from parent tables to child tables.

[Visual Basic]
Public ReadOnly Property Relations As DataRelationCollection
public DataRelationCollection Relations {get;}
public: __property DataRelationCollection* get_Relations();
public function get Relations() : DataRelationCollection;

Property Value

A DataRelationCollection that contains a collection of DataRelation objects; otherwise a null value if no DataRelation objects exist.


[Visual Basic] The following example prints the column name of all child tables through the Relations property.

[Visual Basic] 
Private Sub PrintChildRelationRows()
   ' Declare variable to hold the row values.
   Dim strRowVals As String
   Dim myDataSet As DataSet
   ' Get the DataSet of a DataGrid that is displaying data of at least two
   ' tables.
   Dim myTable As DataTable = CType(DataGrid1.DataSource, DataTable)
   ' Navigate using the Relations.
   Dim myRel As DataRelation
   Dim row As DataRow
   Dim col As DataColumn
   ' Print the names of each column in each table through the Relations.
   For Each myRel In myDataSet.Relations
      For Each col in myRel.ChildTable.Columns
          strRowVals &= col.ColumnName & " "
    ' Display results.
   End Sub

[C#, C++, JScript] No example is available for C#, C++, or JScript. To view a Visual Basic example, click the Language Filter button Language Filter in the upper-left corner of the page.


Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, .NET Compact Framework

See Also

DataSet Class | DataSet Members | System.Data Namespace | DataRelation | DataTable | DataRelationCollection