Yes as long as the db you're using supports batching - which, if it supports
Stored Procs is almost a certainty.
Add the multiple select commands in the proc and then just set the
tableMappings collection of the dataset to map the query table names to the
datasets table names.