First of all, I would like to confirm my understanding of your issue. From
your description, I understand that when you're trying to fill a typed
DataSet with DataAdapter with multiple result sets. If there is any
misunderstanding, please feel free to let me know.
In this case, two new tables are created because the DataAdapter cannot
decide which table the result should be filled to. So the resolution is to
add TableMappings to the DataAdapter. In the TableMappings property, we use
the database table name as the source, and table name in the DataSet as the
target name. Please check the following link for more information.
Also the TableMappings property can be configured from IDE as the following
"This posting is provided "AS IS" with no warranties, and confers no