Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
DataRelation Constructor (String, DataColumn, DataColumn)

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.

ExceptionCondition
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);
}

.NET Framework

Supported in: 4.6, 4.5, 4, 3.5, 3.0, 2.0, 1.1

.NET Framework Client Profile

Supported in: 4, 3.5 SP1

XNA Framework

Supported in: 3.0, 2.0, 1.0
Show:
© 2015 Microsoft