asp.net.ph

DataRelation Constructor ( String, DataColumn [ ], DataColumn [ ] )

System.Data Namespace   DataRelation Class


Initializes a new instance of the DataRelation class using the specified DataRelation name and matched arrays of parent and child DataColumn objects.

[ VB ]
Overloads Public Sub New ( _
   ByVal relationName As String, _
   ByVal parentColumns ( ) As DataColumn, _
   ByVal childColumns ( ) As DataColumn _
)

[ C# ]
public DataRelation (
   string relationName,
   DataColumn [ ] parentColumns,
   DataColumn [ ] childColumns
);

[ C++ ]
public: DataRelation (
   String* relationName,
   DataColumn* parentColumns [ ],
   DataColumn* childColumns [ ]
);

[ JScript ]
public function DataRelation (
   relationName : String,
   parentColumns : DataColumn [ ],
   childColumns : DataColumn [ ]
);

Parameters

relationName
The name of the relation. If a null reference or an empty string ( "" ), a default name will be given when the created object is added to the DataRelationCollection.
parentColumns
An array of parent DataColumn objects.
childColumns
An array of child DataColumn objects.

Exceptions


Exception Type Condition
ArgumentNullException Occurs when Either one or both of the DataColumns is a null reference ( Nothing ).
InvalidConstraintException Occurs when
  • the columns have differing data types
  • one or both of the arrays are not composed of distinct columns from the same table.
  • the tables do not belong to the same DataSet

Example

The following example initializes a new DataRelation using this constructor, and adds it to the DataRelationCollection of a DataSet.

DataColumn parentCols [ ];
parentCols [ 0 ] = ds.Tables [ "Categories" ].Columns [ "CategoryID" ];

DataColumn childCols [ ];
childCols [ 0 ] = ds.Tables [ "Products" ].Columns [ "CategoryID" ];

DataRelation categoryId = new DataRelation ( "categoryId", parentCols, childCols );

// add the relation to the DataSet.
ds.Relations.Add ( categoryId );
  C# VB

See Also

DataRelation Members   DataRelation Constructor Overload List   DataColumn   ForeignKeyConstraint   RelationName Skip Navigation Links




Home
Suggested Reading


Previous page Back to top Next page

© 2000-2010 Rey Nuñez All rights reserved.

If you have any question, comment or suggestion
about this site, please send us a note

You can help support asp.net.ph