Fill typed dataset with one stored procedure call

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to fill a strongly typed dataset with multipe tables single
stored procedure command?
 
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.
 
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
 
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

Similar Threads

Filling a muti-table typed dataset using a stored procedure 5
Fill strongly type dataset from stored procedure 7
Can Strongly Typed DataSet contains Stored Procedure Wrappers? 3
Strongly typed datasets: Can table adapter handle multiple resultsets? 5
Calling Oracle 10g stored procedures from .Net 2.0 4
Come ADO experts!!! 2
Fill DataSet tables from one SPROC 2
Typed DataSets in MS Access with Stored Procedures 1

Back
Top