DataRelationCollection.AddRange Method (DataRelation())


The .NET API Reference documentation has a new home. Visit the .NET API Browser on to see the new experience.

Copies the elements of the specified DataRelation array to the end of the collection.

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

Public Overridable Sub AddRange (
	relations As DataRelation()


Type: System.Data.DataRelation()

The array of DataRelation objects to add to the collection.

If BeginInit has been called, AddRange does not add any objects to the collection until EndInit is called. At the time that EndInit is called, the collection will be populated with the items specified in the most recent call to AddRange. If AddRange is called multiple times within a BeginInit / EndInit sequence, only those items specified in the most recent call to AddRange are added.

Public Shared Sub AddRelations(dataSet As DataSet)
	Dim customerOrders As DataRelation = _
        New DataRelation("CustomerOrders", _
	    dataSet.Tables("Customers").Columns("customerId"), _
	Dim orderDetails As DataRelation = _
        New DataRelation("OrderDetail", _
	    dataSet.Tables("Orders").Columns("orderId"), _

	dataSet.Relations.AddRange(New DataRelation() _
        {customerOrders, orderDetails})

	' Display names of all relations.
	Dim relation As DataRelation
	For Each relation In dataSet.Relations
End Sub

.NET Framework
Available since 1.1
Return to top