AspdotnetCodes.com
Search
Articles
Books
Resources
Asp.Net News
Downloads
Free Tech Magazines
Asp.Net Web Hosting
Archives
Softwares
Newsletter
Suggest Us
Link to Us
Feeds Subscription
Articles
Questions & Answers
Tips & Tricks
 How to Returns 2 select queries data from stored procedure
Posted by Ravi Kumar on  1/8/2009 3:42:10 AM Category: ADO.NET
Add to my favorites
Email to friend
Hi, I have a stored procedure and in that i have to return 2 select queries resultent to the front end i.e to asp.net 2.0 please help

Post Your Reply Post New Question

 Viewer's Reply
Get ans from SP about 2 queries
Answered By Bhavin Bhatt on 1/28/2009 12:51:08 AM
Place RETURN at the end of SP.

Select .... 1st query
Select .... 2nd query


RETURN
GO.


Use Adapter's ExecuteQuery() method and get regult on a DataSet.

DataSet dsResult=new DataSet();

then...

dsResult=Adapter.ExecuteQuery();


Regards,
ßhavin.
 
Post Your Reply If you still have problem, post it again under this reply for better response.

 
Sponsored by
Website Magazine
SearchSAP
The PHP Anthology: 101 Essential Tips, Tricks & Hacks, 2nd Edition - Free 207 Page Preview!