DataColumnMappingCollection.IndexOf Method

Definition

Namespace:

System.Data.Common

Assembly:

System.Data.Common.dll

Gets the location of the specified DataColumnMapping within the collection.

Overloads

IndexOf(String)	Gets the location of the DataColumnMapping with the specified source column name.
IndexOf(Object)	Gets the location of the specified Object that is a DataColumnMapping within the collection.

IndexOf(String)

Source:

DataColumnMappingCollection.cs

Gets the location of the DataColumnMapping with the specified source column name.

public:
 virtual int IndexOf(System::String ^ sourceColumn);

public int IndexOf (string? sourceColumn);

abstract member IndexOf : string -> int
override this.IndexOf : string -> int

Public Function IndexOf (sourceColumn As String) As Integer

Parameters

sourceColumn

String

The case-sensitive name of the source column.

Returns

Int32

The zero-based location of the DataColumnMapping with the specified case-sensitive source column name.

Implements

IndexOf(String)

Examples

The following example searches for a DataColumnMapping object with the given source column name within a DataColumnMappingCollection collection. If the DataColumnMapping exists, the example displays the name and the index of the mapping. If the mapping does not exist, the example displays an error. This example assumes that a DataColumnMappingCollection collection has been created.

public void FindDataColumnMapping()
{
    // ...
    // create columnMappings
    // ...
    if (!columnMappings.Contains("Description"))
    {
        Console.WriteLine("Error: no such table in collection.");
    }
    else
    {
        Console.WriteLine("Name {0}",
            columnMappings["Description"].ToString());
        Console.WriteLine("Index: {0}",
            columnMappings.IndexOf("Description").ToString());
    }
}

Public Sub FindDataColumnMapping()
    ' ...
    ' create columnMappings
    ' ...
    If Not columnMappings.Contains("Description") Then
        Console.WriteLine("Error: no such table in collection.")
    Else
       Console.WriteLine("Name: {0}", _
           columnMappings("Description").ToString())
       Console.WriteLine("Index: {0}", _
           columnMappings.IndexOf("Description").ToString())
    End If
End Sub

See also

• ADO.NET Overview

IndexOf(Object)

Source:

DataColumnMappingCollection.cs

Gets the location of the specified Object that is a DataColumnMapping within the collection.

public:
 virtual int IndexOf(System::Object ^ value);

public int IndexOf (object? value);

abstract member IndexOf : obj -> int
override this.IndexOf : obj -> int

Public Function IndexOf (value As Object) As Integer

Parameters

value

Object

An Object that is the DataColumnMapping to find.

Returns

Int32

The zero-based location of the specified Object that is a DataColumnMapping within the collection.

Implements

IndexOf(Object)

Examples

The following example searches for a DataColumnMapping within the collection. If the mapping exists in the collection, it is removed. If the mapping does not exist within the collection, it is added to the collection and its index is displayed. The example assumes that a DataColumnMappingCollection collection and a DataColumnMapping object have been created.

public void ChangedMyMind()
{
    // ...
    // create mappings and mapping
    // ...
    if (mappings.Contains((Object) mapping))
    {
        mappings.Remove((Object) mapping);
    }
    else
    {
        mappings.Add((Object) mapping);
        Console.WriteLine("Index of new mapping: " +
            mappings.IndexOf((Object) mapping));
    }
}

Public Sub ChangedMyMind()
    ' ...
    ' create mappings and mapping
    ' ...
    If mappings.Contains(CType(mapping, Object)) Then
        mappings.Remove(CType(mapping, Object))
    Else
        mappings.Add(CType(mapping, Object))
        Console.WriteLine("Index of new mapping: " & _
           mappings.IndexOf(CType(mapping, Object)).ToString())
    End If
End Sub

See also

• ADO.NET Overview