You have a batch SQL query that returns multiple result sets and you need to work with the result sets in ADO.NET.
Use the techniques shown in this solution to use a batch query with both a
DataSet and with a
The solution defines a SQL batch query statement that selects the top three rows of each
DataAdapter is used to load the multiple result sets into a
DataSet. The data values in the
DataSet are accessed through the collection of
DataTable objects in the
DataSet and output...