To add multiple tables to one Data Set

  1. From the Data Explorer, select a data source.
  2. Drill down in the tree, then drag and drop the names of multiple tables, one at a time, onto your Windows Form or Web Form.

This creates the BdpDataAdapter for each table and one BdpConnection for that data source and displays icons for those objects in the Component Tray.

  1. Click the BdpDataAdapter icon (named bdpDataAdapter1, by default) to select it.
  2. Click the Configure Data Adapter... designer verb in the Designer Verb area at the bottom of the Object Inspector.

This displays the Data Adapter Configuration dialog.

  1. If the SQL statement that is pre-filled on the dialog is acceptable, click the DataSet tab, otherwise, modify the SQL statement, then click the DataSet tab.
  2. Select the New DataSet radio button.

Tip: You can accept the default name or change the name of the DataSet.

7. Click OK to generate the DataSet.

A DataSet icon appears in the Component Tray indicating that your DataSet has been created.

8. Repeat the Data Adapter configuration for each of the other data adapters, but select Existing Data Set on the DataSet tab when generating the DataSets for all data adapters except the first one you configure.

This generates a DataTable for each data adapter and stores them all in one DataSet.

Note: It is also possible to generate multiple DataSets, either one for each data adapter, or combinations of DataTables.

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