if your dataset has 2 tables, you can set the TableName property:

SqlDataAdapter adapter1 = new SqlDataAdapter("YourSPThatReturnsMultipleResultSets", sqlConnection);
adapter1.Fill(myDataSet);
myDataSet.Tables[0].TableName = "Table1Name";
myDataSet.Tables[1].TableName = "Table2Name";

>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