Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Columns Property

ForeignKeyConstraint.Columns Property

Gets the child columns of this constraint.

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

public virtual DataColumn[] Columns { get; }

Property Value

Type: System.Data.DataColumn[]
An array of DataColumn objects that are the child columns of the constraint.

The following example returns an array of DataColumn objects through the Columns property.

Private Sub GetColumns()
   Dim dataColumns() As DataColumn
   Dim relation As DataRelation
   Dim i As Integer  
   ' Get the DataRelation from a DataSet. 
   For Each relation In DataSet1.Relations
      If relation.GetType.ToString = _
        "System.Data.ForeignKeyConstraint" Then
        dataColumns = relation.ParentColumns
           For i = 0 To dataColumns.GetUpperBound(0)
              Console.WriteLine(dataColumns(i).ColumnName)
           Next i
      End If 
   Next 
End Sub

.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