I have a stored procedure that produces a resultset from a query. If the resultset is empty it tries a second query. This results in two result sets, the first being empty. In ASP.NET the data reader sees no data, even though the second result set is populated.
Please help me either, to only return one result set (cancelling the empty one) or how to code ASP.NET (Visual Basic) to read the second result set.