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

  • Thread starter Thread starter Bill
  • Start date Start date
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.)
 
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
 
Back
Top