To set table mappings

  1. Select the BdpDataAdapter icon in the Component Tray.
  2. Double-click the Collections field for the TableMappings property in the Object Inspector. This displays the TableMappings dialog.
  3. If you want to use an existing dataset as a model for the columns, check the Use a dataset to suggest table and column names checkbox.

This provides you with a list of column names from an existing dataset based on the schema of that dataset. The column names are not linked to anything when you use this process.

  1. If you checked the Use a dataset to suggest table and column names checkbox, you can choose the dataset from the DataSet drop down list.
  2. Select the source table from the Source table drop down list.

If there is more than one table in the data source, their names appear in the drop down list.

6. If you chose to use a dataset to suggest table and column names, and that dataset contains more than one table, you can select the table you want to use from the Dataset table drop down list.

The column names from the source table and from the dataset should appear in the Column mappings grid. As they are displayed by default, they represent the mapping from source to dataset; in other words, the data adapter reads data from each column named on the left side of the grid and stores the data in the dataset column named in the corresponding field on the right side of the grid. You can change the names on either side by typing new names or by selecting different tables. This allows you to store queried data into different dataset columns than the ones created in the dataset by default.

7. If you want to modify a mapping, type a new name in the Dataset table column next to the target Source table column.

This results in the data from the Source table column being stored in the new dataset column.

Note: If you want to reset the column names so that the dataset columns match the data source columns, you can click the Reset button.

Project Management Made Easy

Project Management Made Easy

What you need to know about… Project Management Made Easy! Project management consists of more than just a large building project and can encompass small projects as well. No matter what the size of your project, you need to have some sort of project management. How you manage your project has everything to do with its outcome.

Get My Free Ebook


Post a comment