Can we populate several tables in a .net DataSet using only one sp

From: Andrew (Andrew_at_discussions.microsoft.com)
Date: 09/16/04 

Date: Thu, 16 Sep 2004 07:59:05 -0700

Hi, friends,

I have a .net DataSet that has 7 tables in a hierarchy structure. I want to
populate this dataset using a stored procedure (sp).

However, when I used TableMapping of sqlDataAdapter wizard, it can only map
the sp to only one table. But, the sp really has fields for all the rest of
tables.

Can we populate several tables in a .net DataSet using only one sp? Any
reference papers?

Thanks a lot.

Relevant Pages

  • RE: Can we populate several tables in a .net DataSet using only one sp
    ... Assuming you are returning mutliple results sets from one stored procedure ... You can modify or extract the code the wizard is generating and change the ... > Can we populate several tables in a .net DataSet using only one sp? ...
    (microsoft.public.sqlserver.programming)
  • DataSet, Stored Procedures and Return Values
    ... I have a stored procedure that is used to fill a .NET dataset (using an ... The stored procedure also has a return value. ... but I'm not sure what happens to the spocs return value. ... this value after filling the DataSet? ...
    (microsoft.public.data.ado)