Fill typed dataset with one stored procedure call

microsoft.public.dotnet.framework.adonet

16 Nov 2007 4:45 PM

Gene

Is it possible to fill a strongly typed dataset with multipe tables single
stored procedure command?

16 Nov 2007 6:48 PM

W.G. Ryan

Yes as long as the db you're using supports batching - which, if it supports
Stored Procs is almost a certainty.

Add the multiple select commands in the proc and then just set the
tableMappings collection of the dataset to map the query table names to the
datasets table names.
Show quote

"Gene" <G***@discussions.microsoft.com> wrote in message
news:02554346-E949-485C-949B-9F15230BFC43@microsoft.com...
> Is it possible to fill a strongly typed dataset with multipe tables single
> stored procedure command?
>

17 Nov 2007 9:44 AM

Cor Ligthert[MVP]

Hi Bill,

I remember me that you was always writing about mapping. Why not now, that
is the first requirement in my idea, I leave it to you.

:-)

Cor

17 Nov 2007 6:23 PM

W.G. Ryan

I may be misunderstanding you my friend, I did write about tablemappingss -
but I waited until the second paragraph. ;-)
Show quote

"Cor Ligthert[MVP]" <notmyfirstn***@planet.nl> wrote in message
news:107307A7-3AB3-4E6E-B647-1E3C1B5B2A1B@microsoft.com...
> Hi Bill,
>
> I remember me that you was always writing about mapping. Why not now, that
> is the first requirement in my idea, I leave it to you.
>
> :-)
>
> Cor