Change in Typed Datasets between 1.x and 2.x

I know/gather that the changes between typed datasets between 1.x and 2.x are
pretty significant, but there's one specific thing I could do in 1.x and I
can't figure out how to do it in 2.x, or if it is still possible.

There is a stored procedure that returns multiple result sets (4 in
particular). In 1.x, I could drag and drop the stored procedure from Server
Explorer and it would create 4 'tables' for me, and then I'd make my edits,
etc.

In 2.x, it only shows the first table.

There are many ways that I know will give me workarounds to get to the end
result, and I've taken care of this specific case already, I guess I'd just
like to know if there's a quick way to get the 1.x functionality for future
cases.

TIA,
jdn

Shawn
Mon Jul 17 15:34:17 CDT 2006

Hello jdn,

Just like 1.x, you need to use a DataAdapter and TableMappings to do this.
There is (sadly) on support for it in TableAdapters. See my post here where
I vent a bit on it:

http://adoguy.com/viewrant.aspx?id=2057


Thanks,
Shawn Wildermuth
Speaker, Author and C# MVP
http://adoguy.com

> I know/gather that the changes between typed datasets between 1.x and
> 2.x are pretty significant, but there's one specific thing I could do
> in 1.x and I can't figure out how to do it in 2.x, or if it is still
> possible.
>
> There is a stored procedure that returns multiple result sets (4 in
> particular). In 1.x, I could drag and drop the stored procedure from
> Server Explorer and it would create 4 'tables' for me, and then I'd
> make my edits, etc.
>
> In 2.x, it only shows the first table.
>
> There are many ways that I know will give me workarounds to get to the
> end result, and I've taken care of this specific case already, I guess
> I'd just like to know if there's a quick way to get the 1.x
> functionality for future cases.
>
> TIA,
> jd

jdn
Mon Jul 17 16:08:02 CDT 2006

I suspected as much. Thanks.

jdn

"Shawn Wildermuth (C# MVP)" wrote:

> Hello jdn,
>
> Just like 1.x, you need to use a DataAdapter and TableMappings to do this.
> There is (sadly) on support for it in TableAdapters. See my post here where
> I vent a bit on it:
>
> http://adoguy.com/viewrant.aspx?id=2057
>
>
> Thanks,
> Shawn Wildermuth
> Speaker, Author and C# MVP
> http://adoguy.com
>
> > I know/gather that the changes between typed datasets between 1.x and
> > 2.x are pretty significant, but there's one specific thing I could do
> > in 1.x and I can't figure out how to do it in 2.x, or if it is still
> > possible.
> >
> > There is a stored procedure that returns multiple result sets (4 in
> > particular). In 1.x, I could drag and drop the stored procedure from
> > Server Explorer and it would create 4 'tables' for me, and then I'd
> > make my edits, etc.
> >
> > In 2.x, it only shows the first table.
> >
> > There are many ways that I know will give me workarounds to get to the
> > end result, and I've taken care of this specific case already, I guess
> > I'd just like to know if there's a quick way to get the 1.x
> > functionality for future cases.
> >
> > TIA,
> > jdn
>
>
>