Allows you to create a relationship (a DataRelation object) that maintains information about parent-child records in two data tables in a dataset. You can use the relation object in code at run time to get child records for a specific parent record.
Creating a relationship also creates a foreign-key constraint that is added to the child table. A foreign-key constraint can implement referential integrity between parent and child tables.
This dialog box appears when you drag a Relation object from the DataSet tab of the Toolbox or when you select a relation line in a dataset and choose Edit Relation from the Data menu. You can only create a relation if there is more than one table defined in the dataset.
Allows you to name the relationship. For example, if you are relating a Customers table to an Orders table, you could name the relation CustomersOrders.
Specifies the table to act as parent table from the list of available tables in the dataset.
Specifies the table to act as child table from the list of available tables in the dataset.
Specifies the column or columns that constitute the primary key in the parent table. If the parent table has multiple columns that make up the key, select each part of the key in a separate row of the grid.
Specifies the column or columns in the child table that form a foreign key pointing to the parent table. If the parent table has only one primary key column, select the column in the child table that corresponds to it. If the parent table has multiple columns that make up the key, select all the child columns that constitute parts of the parent-table key.
Creates both a relation and foreign key constraint (see below for descriptions).
A ForeignKeyConstraint restricts the action performed when a value in a column (or columns) is either deleted or updated.
A DataRelation is used to relate two DataTable objects to each other through DataColumn objects.
Specifies how changes are made to child records when a parent record is updated to maintain referential integrity. For more information about the options you can select, see the Rule enumeration.
Specifies how changes are made to child records when a parent record is deleted to maintain referential integrity. For more information about the options you can select, see the Rule enumeration.
Specifies how changes are made to child records when changes to a parent record are accepted or rejected to maintain referential integrity. For more information about the options you can select, see the Rule enumeration.
Toggles the Nested property and controls how this relationship is rendered as XML. For more information, see Nesting DataRelations (ADO.NET).
