procedure or function "procedure name" has too many argument specified
-
I have a winApplication which has a form. In that form I have a sql data adapter which contains 4 command for select,update,delete,insert. When I execute insert command, with passing 9 parameters values, by use of executenonguery function I receive "procedure or function "procedure name" has too many argument specified" error massage at line of executing.:( What should I do? I don't know what's happend there cause I check every parameters by breakpoint and saw that every parameters were passed! :confused:
-
I have a winApplication which has a form. In that form I have a sql data adapter which contains 4 command for select,update,delete,insert. When I execute insert command, with passing 9 parameters values, by use of executenonguery function I receive "procedure or function "procedure name" has too many argument specified" error massage at line of executing.:( What should I do? I don't know what's happend there cause I check every parameters by breakpoint and saw that every parameters were passed! :confused:
You have asked this question already[^] I have given you suggestions already, including to post the code so we can see it.
isiran wrote:
What should I do? I don't know what's happend there cause I check every parameters by breakpoint and saw that every parameters were passed!
And I've told you already that it is obvious that every paramter is passed because the error message tells you that "too many" parameters have been passed. This suggests that you are passing more parameters than was expected. You have to help us to help you. We can't guess what is in your code. You have to show us.
Upcoming events: * Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ... "I wouldn't say boo to a goose. I'm not a coward, I just realise that it would be largely pointless." My website
-
You have asked this question already[^] I have given you suggestions already, including to post the code so we can see it.
isiran wrote:
What should I do? I don't know what's happend there cause I check every parameters by breakpoint and saw that every parameters were passed!
And I've told you already that it is obvious that every paramter is passed because the error message tells you that "too many" parameters have been passed. This suggests that you are passing more parameters than was expected. You have to help us to help you. We can't guess what is in your code. You have to show us.
Upcoming events: * Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ... "I wouldn't say boo to a goose. I'm not a coward, I just realise that it would be largely pointless." My website
Colin Angus Mackay wrote:
This suggests that you are passing more parameters than was expected.
Attempting to bribe the SQL Server? ;P
Vasudevan Deepak Kumar Personal Homepage Tech Gossips
-
I have a winApplication which has a form. In that form I have a sql data adapter which contains 4 command for select,update,delete,insert. When I execute insert command, with passing 9 parameters values, by use of executenonguery function I receive "procedure or function "procedure name" has too many argument specified" error massage at line of executing.:( What should I do? I don't know what's happend there cause I check every parameters by breakpoint and saw that every parameters were passed! :confused: