Multiply datasets

[carlblanchard]

OK

ive got the following, which is part of my helper class
USP_GetItemPrice is a parent stored proc is runs 3 other stored procs so i get 3 sets of data back

how do i get data from the 2nd and 3rd data set with the below

Pritty Urgent if any one can help

Dim MyConnection = OpenDataBase()
            Dim MyCommand As SqlCommand = New SqlCommand
            MyCommand.Connection = MyConnection
            MyCommand.CommandText = "USP_GetItemPrice"
            MyCommand.CommandType = CommandType.StoredProcedure
            MyCommand.Parameters.Add("@p_Product", product)
            MyCommand.Connection.Open()
 
            Dim myReader As SqlClient.SqlDataReader = MyCommand.ExecuteReader
            Dim readerData As Decimal
 
            While myReader.Read
                readerData = myReader("Cost")
            End While
 
            Return readerData
            MyCommand.Connection.Close()