Thanks Eric. Could you give me a simple example of a SP that returns two result sets? Oh an by the way my dataset is a typed dataset, is the adapter smart enough to figure out which result set to use in which table?

Thanks,
Einar

>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