n a stored procedure return multiple tables
Can a stored procedure return multiple tables i.e two select statements in one procedure.
how can u put those tables into dataset at a time .
n a stored procedure return multiple tables
Hot Topic
- Understanding the role of form="unqualified"
- Problem with HttpServerUtility Class
- Can't get a new table into my dataset
- Email Proxy Error with MailMessage
- Timer function with millaseconds elapsed (in dos/command-line)
- DataGrid and Popup Window/Box
- Restoring NTFS encrypted file
- the root element is missing
- setting up proxy settings HELP PLZ
- Dynamic SQL generation is not supported against multiple base tables
.NET Development
- Problem in Update and Delete while using SqlDataSource Control
- SSL on TCP Socket, how in .NET 1.1?
- .NET remoting error:
- Web service connection problem
- Loading UserControl from code without @reference
- RSACryptoServiceProvider & Bad Key Exception
- Simulating HTTP Post
- Update not writing default values to the database
- Accessing Cryptographic Tokens
- Cannot view XML input using XSL style sheet
Can a stored procedure return multiple tables i.e two select statements in one procedure.
how can u put those tables into dataset at a time .
n a stored procedure return multiple tables
Donna M. Singel
Each result set must be mapped to a table in your dataset when using a DataAdapter.
However, in ADO.Net 2.0 this approach has been left in favor of table adapters.
Each table adapter can be assigned a stored procedure in which you should do only one SELECT statement.
In your scenario this would mean a round-trip to the database for each table.
I myself liked the DataAdapter approach better as you need less round-trips to the database and IMHO this results in better performance.
Kevin LZJ
Here's a good link to read up on it as pertains to the specifics of your intentions:
http://www.plus2net.com/sql_tutorial/sql_left_join.php
best of luck