Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C#
I am using a stored procedure for insertion, updation, retrieval of data.
Sometimes it is showing unexpected errors. First it works smoothly, but I think I need to fix some settings.
It is showing errors like "Procedure or function declares too many arguments", "@Date is not supplied".
How can i solve it ?
Posted 19-Nov-12 2:50am
v4
Comments
Darkjo at 19-Nov-12 8:53am
   
In order to have more details, can you show us the procedure please?
__TR__ at 19-Nov-12 8:55am
   
Looking at your error message it looks like the parameters you are passing from your code is not matching with the parameters in your stored procedure.

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

First check number of parameter name and value is same or not.
Second check you provided parameter name (which you sending from your application at the time of calling sp), it must be same as SP parameter name (check you have provide @).
  Permalink  
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



Advertise | Privacy | Mobile
Web01 | 2.8.140926.1 | Last Updated 19 Nov 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100