Using Stored Procedures with Datasets

When you use a stored procedure to return a dataset and that dataset returns a multiple number of tables (multiple tables are returned in the result set - you can test this in Query Analyzer), you can access each table within the dataset by index after the dataset has been filled. This reduces another trip to the server for the dataset.