O'Reilly logo

Essential ADO.NET by Bob Beauchemin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required