The last step of the data adapter wizard checks that all information entered previously can be used by the adapter. It looks as follows:

The select command was correct. The wizard therefore set the SelectCommand property of the data adapter.

Table mappings is the name of the output fields when the data adapter is read into a data set. Default table mappings were generated. These can be overridden as described in section ###.

The query in the example was not updateable. Because of this, the command builder was unable to construct delete and update commands for the query as show above.

In the next picture the output from the wizard is shown:

Note that three objects are placed in the component tray above. By selecting each of the objects and right-clicking and selecting Properties you can see the properties set by the data adapter wizard. On the MpmDataAdapter other commands are also available to Configure data adapter, to Generate dataset, and finally to Preview Data.

Configure data adapter starts the wizard you have just run. Follow the links to see what the other commands can do.

See Also

Data Adapter Wizard, Connection part |  Data Adapter Wizard, Query part