The , at the end of your parameter indicates that you have more
parameters. Are you sure that for every parameter in your sproc you have
a matching parameter in your code?
Note that parameters are handled in order not by name.

Regards,

Gerhard Wentink

-----Oorspronkelijk bericht-----
Van: Robert Sindall [mailto:rsindall@z...] 
Verzonden: vrijdag 28 februari 2003 13:29
Aan: ASPX_Professional
Onderwerp: [aspx_professional] Procedure 'A' expects parameter 'B',
which was not supplied


Procedure 'OrdersDetail' expects parameter '@S...', which was not
supplied.
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
'OrdersDetail' expects parameter '@S...', which was not supplied.

Source Error:

Line 264:
Line 265:            Dim parameterOrderStatus As New
SqlParameter("@Status",
SqlDbType.NVarChar, 10)
Line 266:            parameterOrderStatus.Direction 
ParameterDirection.Output
Line 267:
myCommand.SelectCommand.Parameters.Add(parameterOrderStatus)

BUT!!! my SP says:

@State		nvarchar(50) OUTPUT,