Updating dataset that has many tables

In instances where a dataset has only one table, you can perform CRUD operations by creating the relevant command objects and assigning them to the SelectCommand, InsertCommand, DeleteCommand and UpdateCommand properties of the data adapter. After the necessary changes have been made to the data set, calling the Update command of the data adapter will commit the changes to the database.

In cases where the data set has two or more related tables (using the DataRelation object), what is the correct - and/or most efficient - way of doing this? Relevant code examples or links to articles will be appreciated.

See this demo , you can perform some tests on it . http://www.vbforums.com/showthread.p...hreadid=253655