Help With Assigning Variables To From A SQL Query

I’ve reconfigured Microsoft’s IBS Store shopping cart to function within a small e-commerce website. What I am trying to do is to modify the code slightly in order to use a third party credit card processing center. The situation is this: once the customer clicks the final "check out" button, a stored procedure writes all of the product ordering information into the database. I, then, capture what they're wanting to purchase with the following SQL statement:





Dim strSQL as String = "Select orderID, modelNumber from orderDetails" & _


"where CustomerID = " & User.Identity.Name & _


"And orderid = (SELECT MAX(orderid)FROM orderDetails" & _


"where CustomerID = " & User.Identity.Name & ")"





What I would like to do is assign specific values to variables based off of the above query. For example:





Dim orderItem as String = (all of the modelNumbers from the query)


Dim orderIdItem as String = (all of the orderIDs from the query)





How do I do this?? Any help is much appreciated! Thanks in advance.





Ron