Click here to Skip to main content
11,640,626 members (58,719 online)
Rate this: bad
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
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
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 @).

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

  Print Answers RSS
0 Mika Wendelius 370
1 OriginalGriff 205
2 Afzaal Ahmad Zeeshan 130
3 CPallini 125
4 DamithSL 105
0 Mika Wendelius 370
1 OriginalGriff 205
2 CPallini 125
3 DamithSL 105
4 Afzaal Ahmad Zeeshan 70

Advertise | Privacy | Mobile
Web03 | 2.8.150731.1 | Last Updated 19 Nov 2012
Copyright © CodeProject, 1999-2015
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