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:
isiran wrote:
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?
Post the code - because we can only guess at the cause of the problem.
isiran wrote:
I don't know what's happend there cause I check every parameters by breakpoint and saw that every parameters were passed
Yes, but how many times? The error says "too many" which suggests that the problem isn't that the values are being passed as parameters but "too many" are being passed.
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