IndexOf(DbLoaderColumn) Method

In This Topic

Gets the location in the collection of the DbLoaderColumn object.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Function IndexOf( _
   ByVal value As DbLoaderColumn _
) As Integer

public int IndexOf( 
   DbLoaderColumn value
)

Parameters

value: The DbLoaderColumn object to find.

Return Value

The zero-based location of the DbLoaderColumn in the collection.

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

Reference

DbLoaderColumnCollection Class
DbLoaderColumnCollection Members
Overload List
Contains Method

Send Feedback