Hi,

I have no problem for the rest of the pages when i reused the sorce code of commerce starter kit but i got the following errors when everytime I Clicked order details on Order List page. Please advise.


Server Error in '/MusicStore' Application.

Procedure or function OrdersDetail has too many arguments specified.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Procedure or function OrdersDetail has too many arguments specified.

Source Error:

Line 121: ' Create and Fill the DataSet
Line 122: Dim myDataSet As New DataSet()
Line 123: myCommand.Fill(myDataSet, "OrderItems")
Line 124:
Line 125: ' ship date is null if order doesn't exist, or belongs to a different user

Source File: C:\Inetpub\wwwroot\MusicStore\Components\OrdersDB.vb Line: 123

Stack Trace:

[SqlException: Procedure or function OrdersDetail has too many arguments specified.] System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +629 System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +9 System.Data.Common.DbDataAdapter.Fill(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +118 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +102 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +36 MusicStore.MusicStore.OrdersDB.GetOrderDetails(Int32 orderID, String customerID) in C:\Inetpub\wwwroot\MusicStore\Components\OrdersDB.vb:123 MusicStore.OrderDetailsPage.Page_Load(Object sender, EventArgs e) in C:\Inetpub\wwwroot\MusicStore\OrderDetails.aspx.vb:44 System.Web.UI.Control.OnLoad(EventArgs e) +67 System.Web.UI.Control.LoadRecursive() +73 System.Web.UI.Page.ProcessRequestMain() +394

Hi there,
Firstly I'm a novice (at this 3 months) so this could be total BS but I'm sure
some one will correct me if I'm wrong.
Check the output parameters in your stored procedure against the ones required
for the dataset, one could be missing.

Hope this is of some help.

Paul

Hi,

Thanks a lot of your information. It's solved my problem.

lINN