Relationships in Datasets

A dataset can contain related tables like a relational database. The object that facilitates a relationship between data tables is a DataRelation object. The following topics provide information about ADO.NET DataRelation objects, how to create them, and how to use them to work with data in related tables.

Note

Your computer might show different names or locations for some of the Visual Studio user interface elements in the following instructions. The Visual Studio edition that you have and the settings that you use determine these elements. For more information, see Customizing Development Settings in Visual Studio.

In This Section

Reference

  • DataRelation
    Represents a parent/child relationship between two T:System.Data.DataTable objects.

  • GetChildRows
    Gets the child rows of a T:System.Data.DataRow.

  • GetParentRow
    Gets the parent rows of a T:System.Data.DataRow.

  • Rule
    Indicates the action that occurs when a ForeignKeyConstraint is enforced.

  • Unique
    Gets or sets a value indicating whether the values in each row of the column must be unique.

  • Constraint
    Represents a constraint that can be enforced on one or more DataColumn objects.