in a stored procedure i have two select statements i try to retrieve information from this stored procedure using .Net C# application's SqlDataReader's Read() method but for field related to second query it throws a exception saying index out of range can we somehow have read out from two statements using data readers Read() method?