Fill typed dataset with one stored procedure call

G

Guest

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

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

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

W.G. Ryan

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top