ITableMapping Interface
Collapse the table of content
Expand the table of content

ITableMapping Interface

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

For a list of all members of this type, see ITableMapping Members.

[Visual Basic]
Public Interface ITableMapping
public interface ITableMapping
public __gc __interface ITableMapping
public interface ITableMapping

Classes that Implement ITableMapping

Class Description
DataTableMapping Contains a description of a mapped relationship between a source table and a DataTable. This class is used by a DataAdapter when populating a DataSet.


The ITableMapping interface allows an inheriting class to implement a TableMapping class, which associates a data source column with a DataSet column. For more information, see Setting Up DataTable and DataColumn Mappings.

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

Classes that inherit ITableMapping must implement the inherited members, and typically define additional members to add provider-specific functionality. For example, the ITableMapping interface defines the DataSetTable property. In turn, the DataTableMapping class inherits this property, and also defines the GetDataTableBySchemaAction method.

Notes to Implementers:  When you inherit from the ITableMapping interface, you should implement the following constructors:

Item Description
DataTableMapping() Initializes a new instance of the TableMapping class.
TableMapping(string sourceTable, string dataSetTable) Initializes a new instance of the TableMapping class with a source when given a source table name and a DataTable name.
TableMapping(string sourceTable, string dataSetTable, DataColumnMapping[] columnMappings) Initializes a new instance of the TableMapping class when given a source table name, a DataTable name, and an array of ColumnMapping objects.


[Visual Basic, C#, C++] The following example creates an instance of the derived class, DataTableMapping, and adds it to a DataTableMappingCollection collection. It then informs the user that the mapping was added to the collection and displays the parent mapping.

[Visual Basic] 
Public Sub AddDataTableMapping()
    ' ...
    ' create myTableMappings
    ' ...
    Dim myNewMapping As New DataTableMapping("Categories", "DataCategories")
    myTableMappings.Add(CType(myNewMapping, Object))
    MessageBox.Show("Table " + myNewMapping.ToString() + " added to " _
       + "table mapping collection " + myTableMappings.ToString())
End Sub

public void AddDataTableMapping() {
   // ...
   // create myTableMappings
   // ...
   DataTableMapping myNewMapping =
      new DataTableMapping("Categories","DataCategories");
   myTableMappings.Add((Object) myNewMapping);
   MessageBox.Show("Table " + myNewMapping.ToString() + " added to " +
      "table mapping collection " + myTableMappings.ToString());

void AddDataTableMapping() {
   // ...
   // create myTableMappings
   // ...
   DataTableMapping* myNewMapping =
      new DataTableMapping(S"Categories",S"DataCategories");
   MessageBox::Show(String::Concat( S"Table ", myNewMapping->ToString(), S" added to ",
      S"table mapping collection ", myTableMappings->ToString() ));

[JScript] No example is available for JScript. To view a Visual Basic, C#, or C++ example, click the Language Filter button Language Filter in the upper-left corner of the page.


Namespace: System.Data

Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, .NET Compact Framework

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

See Also

ITableMapping Members | System.Data Namespace | ITableMappingCollection

© 2015 Microsoft