Fill typed dataset with one stored procedure call

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gene - 16 Nov 2007 16:45 GMT

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

Reply to this Message

W.G. Ryan - 16 Nov 2007 18:48 GMT

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.

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

Reply to this Message

Cor Ligthert[MVP] - 17 Nov 2007 09:44 GMT

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

Reply to this Message

W.G. Ryan - 17 Nov 2007 18:23 GMT

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

> Hi Bill,
>
[quoted text clipped - 4 lines]
>
> Cor

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...