Contains(DbLoaderColumn) Method

In This Topic

Gets a value indicating whether a DbLoaderColumn object exists in the collection.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Function Contains( _
   ByVal value As DbLoaderColumn _
) As Boolean

public bool Contains( 
   DbLoaderColumn value
)

Parameters

value: The value of the DbLoaderColumn object to find.

Return Value

true if the collection contains the DbLoaderColumn; otherwise, false.

Example

The following example searches for a DbLoaderColumn within a DbLoaderColumnCollection. If the column exists, the example displays the index of the column. If the column does not exist, the example displays an error. This example assumes that a DbLoaderColumnCollection has already been created.

csharp

public void SearchMyColumns() {
  // ...
  // create SqlLoaderColumnCollection myColumns and SqlLoaderColumn myNewColumn
  // ...
  if (!myColumns.Contains((Object) myNewColumn))
    MessageBox.Show("ERROR: no such column in the collection");
  else
    MessageBox.Show("match on column #" +
      myColumns.IndexOf((Object) myNewColumn).ToString());
}

Visual Basic

Public Sub SearchMyColumns()
  ' ...
  ' create SqlLoaderColumnCollection myColumns and SqlLoaderColumn myNewColumn
  ' ...
  If Not myColumns.Contains(CType(myNewColumn, Object)) Then
    MessageBox.Show("ERROR: no such column in the collection")
  Else
    MessageBox.Show("match on column #" & myColumns.IndexOf(CType(myNewColumn, Object)).ToString())
  End If
End Sub 'SearchMyColumns

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

DbLoaderColumnCollection Class
DbLoaderColumnCollection Members
Overload List

Send Feedback