I could possibly say yes or no, but that would not really help you. One DataAdapter can have multiple result sets and a DataSet can be filled by multiple DataAdapters.
I suggest you read the following MSDN article:
Populating a DataSet from a DataAdapter[
^]. It even has a section Multiple Result Sets and Populating a DataSet from Multiple DataAdapters.
Here is some additional reading on the
DataAdapter[
^] and more specific, the
SqlDataAdapter[
^]. Those links should provide you with any questions you might have on DataAdapters. You can even follow other links in the article for even more information.
Another interesting read is
DataSets, DataTables and DataViews[
^].
I think you should manage, but would you find yourself in need of an example,
Inserting relational data using DataSet and DataAdapter[
^] is a great article for that.
Hope it helps! :)
Submit an article or tip