I am trying to update the OrderDetails.aspx file to display more additional order information including Billing Address, Shipping Address, Tracking Number, etc.

I have created new parameters and am having the values outputted to them via the OrdersDetail stored procedure.  I have also updated the OrderDB.vb class accordingly.  Everything seems to be moving smoothly except that the 'items ordered' list is not appearing. 

This is the code I have in OrderDetails.aspx to display the grid:
' Bind Items to GridControl
GridControl1.DataSource = myOrderDetails.OrderItems
GridControl1.DataBind()

My Stored Procedure is as follows:

CREATE Procedure dbo.CMRC_OrdersDetail
(
    @OrderID    int,
    @CustomerID int,
    @OrderDate  datetime OUTPUT,
    @OrderTotal money OUTPUT,
    @ShipFirstName    nvarchar(30) OUTPUT,
    @ShipLastName     nvarchar(30) OUTPUT,
    @ShipAddress1     nvarchar(50) OUTPUT,
    @ShipAddress2     nvarchar(50) OUTPUT,
    @ShipCity         nvarchar(30) OUTPUT,
    @ShipState        nvarchar(2) OUTPUT,
    @ShipZip          nvarchar(10) OUTPUT,
    @BillFirstName    nvarchar(30) OUTPUT,
    @BillLastName     nvarchar(30) OUTPUT,
    @BillAddress1     nvarchar(50) OUTPUT,
    @BillAddress2     nvarchar(50) OUTPUT,
    @BillCity         nvarchar(30) OUTPUT,
    @BillState        nvarchar(2) OUTPUT,
    @BillZip          nvarchar(10) OUTPUT,
    @Shipper          nvarchar(10) OUTPUT,
    @TrackingNumber   nvarchar(10) OUTPUT
)

AS

/* Return the order dates from the Orders
    Also verifies the order exists for this customer. */
SELECT
    @OrderDate = OrderDate,
    @Shipper = CMRC_Orders.Shipper,
    @TrackingNumber = CMRC_Orders.Notes,
    @ShipFirstName = toycsk.CMRC_ShippingInfo.ShipFirstName,
    @ShipLastName = toycsk.CMRC_ShippingInfo.ShipLastName,
    @ShipAddress1 = toycsk.CMRC_ShippingInfo.ShipAddress1,
    @ShipAddress2 = toycsk.CMRC_ShippingInfo.ShipAddress2,
    @ShipCity = toycsk.CMRC_ShippingInfo.ShipCity,
    @ShipState = toycsk.CMRC_ShippingInfo.ShipState,
    @ShipZip = toycsk.CMRC_ShippingInfo.ShipZip,
    @BillFirstName = toycsk.CMRC_BillingInfo.BillFirstName,
    @BillLastName = toycsk.CMRC_BillingInfo.BillLastName,
    @BillAddress1 = toycsk.CMRC_BillingInfo.BillAddress1,
    @BillAddress2 = toycsk.CMRC_BillingInfo.BillAddress2,
    @BillCity = toycsk.CMRC_BillingInfo.BillCity,
    @BillState = toycsk.CMRC_BillingInfo.BillState,
    @BillZip = toycsk.CMRC_BillingInfo.BillZip
   
FROM   
    CMRC_Orders

  INNER JOIN toycsk.CMRC_ShippingInfo ON CMRC_Orders.ShipID = toycsk.CMRC_ShippingInfo.ShipID
  INNER JOIN toycsk.CMRC_BillingInfo ON CMRC_Orders.BillID = toycsk.CMRC_BillingInfo.BillID

   
WHERE  
    CMRC_Orders.OrderID = @OrderID
    AND
    CMRC_Orders.CustomerID = @CustomerID

IF @@Rowcount = 1
BEGIN

/* First, return the OrderTotal out param */
SELECT 
    @OrderTotal = Cast(SUM(CMRC_OrderDetails.Quantity * CMRC_OrderDetails.UnitCost) as
money)
   
FROM   
    CMRC_OrderDetails
   
WHERE  
    OrderID= @OrderID

END
GO

Is there something wrong with my stored procedure or does anyone know any other reason why I may be running into this problem?

Thanks.

I think the core to this question is how you are calling the SQL and populating the Table....I'm not sure where your output parameters are being accessed etc....however, that being said, I'm going to suggest an alternative:

I suggest you look at utilizing SQLXML to return XML from SQL Server.  It's obvious that you're dealing with hierarchical data here and that is XML's main job.  When you get your XML back from SQL Server, I would then suggest de-serializing it into a custom object that you make that has all the single parameters (OrderDate, PONumber etc) and an array of line items.  When you deserialize the output and have a single instance of this order object, you can then bind your datagrid to order.lineitems (this is an IEnumerable array).  I think object databinding is overlooked far too much and the combination of object binding and de/serialization make your ASP.NET code minimal in terms of transferring data between presentation and SQL.  Let me know if you want to go this route and need further help with this.