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

DataColumnCollection.Contains Method

Checks whether the collection contains a column with the specified name.

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

'Declaration
Public Function Contains ( _
	name As String _
) As Boolean

Parameters

name
Type: System.String

The ColumnName of the column to look for.

Return Value

Type: System.Boolean
true if a column exists with this name; otherwise, false.

Use the Contains method to confirm the existence of a column before you perform additional operations on the column. The method returns false when two or more columns have the same name but different namespaces. The call does not succeed if there is any ambiguity when matching a column name to exactly one column.

The following example uses the Contains method and the CanRemove method to determine whether the column can be removed. If so, the column is removed.

Private Sub RemoveColumn(columnName As String, table As DataTable)
    Dim columns As DataColumnCollection = table.Columns

    If columns.Contains(columnName) Then  
        If columns.CanRemove(columns(columnName)) Then 
            columns.Remove(columnName)
        End If 
    End If 
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