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 MySqlLoaderColumnCollection myColumns and MySqlLoaderColumn 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 MySqlLoaderColumnCollection myColumns and MySqlLoaderColumn 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
Contains Method

Send Feedback