Procedure has too many arguments specified

Question

0.00/5 (No votes)

See more:

0 down vote favorite

I'm working on a web application using asp.net on my gridview im using a command field edit button that calls a stored procedure for updating the data but while updating

I'm getting the following error:

Procedure or function updateprofile has too many arguments specified.

Description:
An unhandled exception occurred during the execution of the current web request.
Please review the stack trace for more information about the error and where it
originated in the code.

Exception Details:
System.Data.SqlClient.SqlException: Procedure or function updateprofile has too many
arguments specified.

This is my stored procedure:

SQL

ALTER procedure [dbo].[updateprofile] 
   @pid int, 
   @pfirstname varchar(50), 
   @plastname varchar(50), 
   @padress varchar(50),
   @pemail varchar(50),
   @ptelephone varchar(50), 
   @pbirthday date 
as begin 
   update profile 
   set firstname = @pfirstname, @plastname = lastname,
       @padress = adress, @pemail = email, @ptelephone = telephone,
       birthday = @pbirthday 
   where id = @pid end

And this is my asp code:

C#

SelectCommand="selectAllProfile" SelectCommandType="StoredProcedure"     
UpdateCommand="updateprofile" UpdateCommandType="StoredProcedure"
DeleteCommand="deleteprofile" DeleteCommandType="StoredProcedure"

<updateparameters>
  <asp:Parameter Name="pid" Type="Int32" />
  <asp:Parameter Name="pfirstname" Type="String" /> 
  <asp:Parameter Name="plastname" Type="String" />
  <asp:Parameter Name="padress" Type="String" /> 
  <asp:Parameter Name="pemail" Type="String" /> 
  <asp:Parameter Name="ptelephone" Type="String" /> 
  <asp:Parameter DbType="Date" Name="pbirthday" /> 
</updateparameters>

btw im facing the same error for the delete command

Awaiting your reply

Your help is much appreciated :)

Posted 18-Aug-13 23:45pm

Jocelyne El Khoury

Updated 18-Aug-13 23:47pm

ArunRajendra

v2

Add a Solution

Comments

ArunRajendra 19-Aug-13 5:53am

First check if you can execute the stored procedure directly.

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Pheonyx · Answer 1 · 2013-08-18T23:51:00

Just an observation, and this could be because you typed this? But the following:

SQL

firstname = @pfirstname, @plastname = lastname,
       @padress = adress, @pemail = email, @ptelephone = telephone,
       birthday = @pbirthday

should that not be:

SQL

firstname = @pfirstname, lastname = @plastname,
       adress = @padress, email = @pemail, telephone = @ptelephone,
       birthday = @pbirthday

Jocelyne El Khoury · Answer 2 · 2013-08-18T23:55:00

Solution 2

i've fixed it and i'm still getting the same error !

Posted 18-Aug-13 23:55pm

Jocelyne El Khoury

Jocelyne El Khoury · Answer 3 · 2013-08-19T00:09:00

Solution 3

the stored procedure is working perfectly

Posted 19-Aug-13 0:09am

Jocelyne El Khoury

Procedure has too many arguments specified

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us