IColumnMapping Interface

 

Associates a data source column with a DataSet column, and is implemented by the DataColumnMapping class, which is used in common by .NET Framework data providers.

Namespace:   System.Data
Assembly:  System.Data (in System.Data.dll)

public interface IColumnMapping

NameDescription
System_CAPS_pubpropertyDataSetColumn

Gets or sets the name of the column within the DataSet to map to.

System_CAPS_pubpropertySourceColumn

Gets or sets the name of the column within the data source to map from. The name is case-sensitive.

The IColumnMapping interface enables an inheriting class to implement a Column Mapping class, which associates a data source column with a DataSet column. For more information, see DataAdapter DataTable and DataColumn Mappings.

An application does not create an instance of the IColumnMapping interface directly, but creates an instance of a class that inherits IColumnMapping.

Classes that inherit IColumnMapping must implement all inherited members, and typically define additional members to add provider-specific functionality. For example, the IColumnMapping interface defines the DataSetColumn property. In turn, the DataColumnMapping class inherits this property, and also defines the GetDataColumnBySchemaAction method.

Notes to Implementers:

When you inherit from the IColumnMapping interface, you should implement the following constructors:

Item

Description

ColumnMapping()

Initializes a new instance of the ColumnMapping class.

ColumnMapping(string sourceColumn, string dataSetColumn)

Initializes a new instance of the ColumnMapping class with a source with the specified source column name and DataSet column name.

The following example creates an instance of the derived class, DataColumnMapping, and adds it to a DataColumnMappingCollection collection. It then tells the user that the mapping was added to the collection and shows the parent for the mapping.


public void AddDataColumnMapping() {
   // ...
   // create columnMappings
   // ...
   DataColumnMapping mapping =
      new DataColumnMapping("Description","DataDescription");
   columnMappings.Add((Object) mapping);
   Console.WriteLine("Column {0} added to column mapping collection {1}.", 
       mapping.ToString(), columnMappings.ToString());
}

.NET Framework
Available since 1.1
Return to top
Show: