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
Introduction to Web Applications Development
Everything You Know About CSS Is Wrong! - Free 37 Page Preview!
SearchSAP