This documentation is archived and is not being maintained.

DataRelationCollection.Add Method (String, DataColumn, DataColumn, Boolean)

Creates a DataRelation with the specified name, parent and child columns, with optional constraints according to the value of the createConstraints parameter, and adds it to the collection.

Namespace: System.Data
Assembly: System.Data (in

public virtual DataRelation Add (
	string name,
	DataColumn parentColumn,
	DataColumn childColumn,
	bool createConstraints
public DataRelation Add (
	String name, 
	DataColumn parentColumn, 
	DataColumn childColumn, 
	boolean createConstraints
public function Add (
	name : String, 
	parentColumn : DataColumn, 
	childColumn : DataColumn, 
	createConstraints : boolean
) : DataRelation
Not applicable.



The name of the relation.


The parent column of the relation.


The child column of the relation.


true to create constraints; otherwise false. (The default is true).

Return Value

The created relation.

When a DataRelation object is added to the collection, ForeignKeyConstraint and UniqueConstraint objects are created by default if they do not already exist. To prevent this, you can set createConstraints to false.

Windows 98, Windows Server 2000 SP4, Windows CE, Windows Millennium Edition, Windows Mobile for Pocket PC, Windows Mobile for Smartphone, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition

The Microsoft .NET Framework 3.0 is supported on Windows Vista, Microsoft Windows XP SP2, and Windows Server 2003 SP1.

.NET Framework

Supported in: 3.0, 2.0, 1.1, 1.0

.NET Compact Framework

Supported in: 2.0, 1.0

XNA Framework

Supported in: 1.0