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!
-
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!
#1. maybe, the parameters that you are sending from code are more than the actual parameters of stored procedure. OR #2. try to call the stored procedure with fully qualified name. (eg: dbo.myStoredProcedure or mydb.dbo.myStoredProcedure ) OR #3. check-out this article[^] if you are using Datagrid view or ObjectDataSource Hope it helps...
Thanks and Regards, Michael Sync ( Blog: http://michaelsync.net) If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Why vote? Plz Read it here. Thank you. :)