Procedure or function 'bla' expects parameter '@OrderNumber', which was not supplied.
-
Hi, Breaking my head, over this error, for which the reason according to all google results I have been able to find, is usually a simple omission of SelectCommandType="StoredProcedure", or some simple typo. If this is the case for me, I am just not seeing it.
The address shows that the necessary parameter values are being passed to the page: "http://address/folder/OrderPicking.aspx?_afp\_nr=**1586474**_&_wh\_nr=**02**_" Any and all help much appreciated. Regards, Johan
My advice is free, and you may get what you paid for.
-
Hi, Breaking my head, over this error, for which the reason according to all google results I have been able to find, is usually a simple omission of SelectCommandType="StoredProcedure", or some simple typo. If this is the case for me, I am just not seeing it.
The address shows that the necessary parameter values are being passed to the page: "http://address/folder/OrderPicking.aspx?_afp\_nr=**1586474**_&_wh\_nr=**02**_" Any and all help much appreciated. Regards, Johan
My advice is free, and you may get what you paid for.
Try omitting the "@" from the name
-
Try omitting the "@" from the name
Hi, Thanks for your reply. I omitted the @ characters, but unfortunately still no sigare. Regards, Johan
My advice is free, and you may get what you paid for.
-
Hi, Breaking my head, over this error, for which the reason according to all google results I have been able to find, is usually a simple omission of SelectCommandType="StoredProcedure", or some simple typo. If this is the case for me, I am just not seeing it.
The address shows that the necessary parameter values are being passed to the page: "http://address/folder/OrderPicking.aspx?_afp\_nr=**1586474**_&_wh\_nr=**02**_" Any and all help much appreciated. Regards, Johan
My advice is free, and you may get what you paid for.
That code looks like it should work. You could try adding a handler for the
Selectingevent[^], and examine theCommandproperty of the SqlDataSourceSelectingEventArgs[^] to see what parameters are set. Or, if you have access, use SQL Server Profiler[^] to see exactly what your application is sending to SQL Server. NB: It's generally recommended that you don't usesp_to prefix the name of your stored procedures: Is the sp_ prefix still a no-no? - SQLPerformance.com[^]
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
