Essential ADO.NET

6.6. Table and Column Mappings

DataTables and DataColumns in a DataSet are assigned default names when Fill is called. These names usually correspond to the names in the SQL SELECT command. By using DataTableMappingCollection, you can apply a collection of names before calling Fill. For example, the table named authors in the database can be mapped to Addison-Wesley Authors in the DataSet. When the Addison-Wesley Authors DataTable is specified in the Fill statement as the table name, the Command with CommandText select * from authors produces the specified table.

Each DataTableMapping in the DataSet's DataTableMappingCollection contains a collection of DataColumnMappings. This collection can map individual columns by name or position in the ...