DataTableMappingCollection.Item[] Property

Definition

Namespace:

System.Data.Common

Assemblies:

netstandard.dll, System.Data.Common.dll

Gets or sets the DataTableMapping object specified.

Overloads

Item[Int32]	Gets or sets the DataTableMapping object at the specified index.
Item[String]	Gets or sets the DataTableMapping object with the specified source table name.

Item[Int32]

Source:

DataTableMappingCollection.cs

Gets or sets the DataTableMapping object at the specified index.

C#

[System.ComponentModel.Browsable(false)]
public System.Data.Common.DataTableMapping this[int index] { get; set; }

Parameters

index

Int32

The zero-based index of the DataTableMapping object to return.

Property Value

DataTableMapping

The DataTableMapping object at the specified index.

Attributes

BrowsableAttribute

Examples

The following example creates a DataTableMappingCollection collection, adds DataTableMapping objects to the collection, and displays a list of the mapped source tables.

C#

public void CreateTableMappings()
{
    DataTableMappingCollection mappings =
        new DataTableMappingCollection();
    mappings.Add("Categories","DataCategories");
    mappings.Add("Orders","DataOrders");
    mappings.Add("Products","DataProducts");
    string message = "TableMappings:\n";
    for(int i=0;i < mappings.Count;i++)
    {
        message += i.ToString() + " "
            + mappings[i].ToString() + "\n";
    }
    Console.WriteLine(message);
}

Item[String]

Source:

DataTableMappingCollection.cs

Gets or sets the DataTableMapping object with the specified source table name.

C#

[System.ComponentModel.Browsable(false)]
public System.Data.Common.DataTableMapping this[string sourceTable] { get; set; }

Parameters

sourceTable

String

The case-sensitive name of the source table.

Property Value

DataTableMapping

The DataTableMapping object with the specified source table name.

Attributes

BrowsableAttribute

Examples

The following example searches for a DataTableMapping object with the given source table name within a DataTableMappingCollection collection. If the DataTableMapping 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 DataTableMappingCollection collection has been created.

C#

public void FindDataTableMapping()
{
    // ...
    // create mappings
    // ...
    if (!mappings.Contains("Categories"))
        Console.WriteLine("Error: no such table in collection");
    else
        Console.WriteLine
            ("Name: " + mappings["Categories"].ToString() + "\n"
            + "Index: " + mappings.IndexOf("Categories").ToString());
}