Fill typed dataset with one stored procedure call

[Guest]

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

 

[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.

 

[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

 

[W.G. Ryan]

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