DataRelation Constructor (String, DataColumn, DataColumn)
Initializes a new instance of the DataRelation class using the specified DataRelation name, and parent and child DataColumn objects.
Namespace: System.Data
Assembly: System.Data (in System.Data.dll)
public DataRelation( string relationName, DataColumn parentColumn, DataColumn childColumn )
Parameters
- relationName
- Type: System.String
The name of the DataRelation. If null or an empty string (""), a default name will be given when the created object is added to the DataRelationCollection.
- parentColumn
- Type: System.Data.DataColumn
The parent DataColumn in the relationship.
- childColumn
- Type: System.Data.DataColumn
The child DataColumn in the relationship.
| Exception | Condition |
|---|---|
| ArgumentNullException | One or both of the DataColumn objects contains null. |
| InvalidConstraintException | The columns have different data types -Or- The tables do not belong to the same DataSet. |
The following example creates a new DataRelation and adds it to the DataRelationCollection of a DataSet.
private void CreateRelation() { // Code to get the DataSet not shown here. // Get the DataColumn objects from two DataTable // objects in a DataSet. DataColumn[] parentCols = new DataColumn[] {DataSet1.Tables["Customers"].Columns["CustID"], DataSet1.Tables["Customers"].Columns["OrdID"]}; DataColumn[] childCols= new DataColumn[] {DataSet1.Tables["Orders"].Columns["CustID"], DataSet1.Tables["Orders"].Columns["OrdID"]}; // Create DataRelation. DataRelation CustOrderRel = new DataRelation( "CustomersOrders", parentCols, childCols); // Add the relation to the DataSet. DataSet1.Relations.Add(CustOrderRel); }
Windows 8, Windows Server 2012, Windows 7, Windows Vista SP2, Windows Server 2008 (Server Core Role not supported), Windows Server 2008 R2 (Server Core Role supported with SP1 or later; Itanium not supported)
The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.
