I have a dataset with two tables. I know I can fill the tables independently using a a data adaper for each of the tables. Something like this:

MyDataSet myDataSet = new MyDataSet();

SqlDataAdapter adapter1 = new SqlDataAdapter("SP1", sqlConnection);
adapter1.Fill(myDataSet, myDataSet.Table1.TableName);

SqlDataAdapter adapter2 = new SqlDataAdapter("SP2", sqlConnection);
adapter2.Fill(myDataSet, myDataSet.Table2.TableName);

(I think that code would compile <s>)

Anywho is there a way to construct a stored procedure to return multiple "datasets" so that I can fill both Table1 and Table2 using one stored procedure? (maybe Table1 is the parent table and Table2 is the child table)

How do you do this?

Thanks,
Einar