how to get stored procedure's batches query in different dataset
<p>I'm trying to fetch all the data from one stored procedure for different different Dataset in a single page.</p>

<pre><code>CREATE PROCEDURE [dbo].[usp_Details](@status  int, @Id int)
AS
begin

Select u.Id,u.FName,u.ImageName,u.ImagePath,u.Sex FROM [User] as u
 where u.Id IN (SELECT MyId as Id FROM Friends WHERE FriendId=@Id AND FriendStatus=0)

Select Points,FName from [User] where Id=@Id

SELECT ImagePath from [User] where Id=@Id
end
GO
</code></pre>

<p>Now, how I can bind datatable/dataset for individual query.
Example: query1 for dataset1, query2 for dataset2, query3 for dataset3</p>

<p>If this is not possible then which is the best way to avoid connecting database each time for fetching different tables.</p>
