in my experience, there is no way to update both tables by using the commandbuilder.getInsertcommand or commandbuilder.getUpdatecommand because dataadapter is assigned to only 1 table so it can update, delete or insert only one table at one time, other than the selecting sancerio you mentioned...