Hi Bill,
Thank you for posting in the community!
First of all, I would like to confirm my understanding of your issue. From
your description, I understand that you need to know why we can add
multiple mappings to a DataAdapter. If there is any misunderstanding,
please feel free to let me know.
We can add multiple table mappings to a table, because a DataAdapter can
return multiple result sets in a Fill method. The SelectCommand of the
DataAdapter can be multiple SELECT SQL statements, so we have to use
several table mappings to make sure that the data from the source table can
be put to the corresponding DataSet table. Of cource, one table can only
have one table mapping in the TableMappings collection. It means that the
SourceTable property of DataTableMapping has to be unique, or an exception
with the following message will be thrown.
The DataTableMapping.SourceTable is required to be unique, 'Table' already
exists in the collection.
For more information about TableMappings of the DataAdapter, please check
the following link for reference:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/
frlrfsystemdatacommondataadapterclasstablemappingstopic.asp
Hope this helps. Does this answer your question? If anything is unclear,
please feel free to reply to the post.
Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."
