Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
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
[C#]
public interface ITableMapping
[C++]
public __gc __interface ITableMapping
[JScript]
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.

Remarks

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.

Example

[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

[C#] 
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());
}

[C++] 
void AddDataTableMapping() {
   // ...
   // create myTableMappings
   // ...
   DataTableMapping* myNewMapping =
      new DataTableMapping(S"Categories",S"DataCategories");
   myTableMappings->Add(static_cast<Object*>(myNewMapping));
   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.

Requirements

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

Show:
© 2015 Microsoft