Can multiple DataSet tables be returned on a single Stored Procedure call to SQL Server?

B

Bill

I am having some serious performance problems resulting from too many round
trips on the wire in order to populate several tables in an ADO.NET DataSet.
I would like to make ONE stored procedure call that will return all of the
table data. (I am using SQL Server 2000)

If this is doable, does anyone have an example of how to do it? (For
example, a call that will return -- say -- 100 PO header record and
associated detail items in two tables.)
 
C

Cor Ligthert

Hi Bill,

When you want an answer from the experts in this, ask this in the newsgroup

microsoft.public.dotnet.framework.adonet

I hope this helps?

Cor
 

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

Can multiple DataSet tables be returned from a single Stored Procedure call to SQL Server? 1
Can SqlDataReader be used against stored procedures that return multiple resultsets? 1
Can't create persistent ## tables with ADP call to a stored procedure(!?) 2
DataSet as argument for Sql server stored procedure 3
Best way to call a SQL Server Stored Procedure from within Excel 2
T-SQL - How can I name result sets returned by my Stored Procedure?? 2
DataSet from Stored Procedure 5
Multiple select statements in a single stored procedure. 2

Top