Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.