Procedure or function SP_UpGridDateDetails has too many arguments specified.

Question

5.00/5 (1 vote)

See more:

Hello friends,

I am getting "Procedure or function SP_UpGridDateDetails has too many arguments specified." error when i am updating the grid.

My code like this...
In Data Access Layer..

foreach (CO_TR_Registration objCO_TR_Registration in ObjGridCO_TR_Registration)
               {


                   objSqlCommand.Parameters.Add("@regId", SqlDbType.VarChar).Value = (objCO_TR_Registration.RegistrationID);
                   objSqlCommand.Parameters.Add("@VlFNo", SqlDbType.VarChar).Value = (objCO_TR_Registration.VLFNO).TrimEnd() ;
                   objSqlCommand.Parameters.Add("@Stud_name", SqlDbType.VarChar).Value = objCO_TR_Registration.Name;
                   objSqlCommand.Parameters.Add("@FHG", SqlDbType.VarChar).Value = objCO_TR_Registration.FHG;
                   objSqlCommand.Parameters.Add("@FHG_Name", SqlDbType.VarChar).Value = objCO_TR_Registration.FatherName;
                   objSqlCommand.Parameters.Add("@MaritalStatus", DbType.String).Value = objCO_TR_Registration.MaritalStatus;
                   objSqlCommand.ExecuteNonQuery();

               }

and stored procedure..

VB

UPDATE [KMDCModified].[dbo].[Register]
   SET


       [VLFNo]=@VlFNo
      ,[stud_name] = @Stud_name
      ,[FHG] = @FHG
      ,[FHG_Name] = @FHG_Name

      ,[maritalstatus] = @maritalstatus

 WHERE regid=@regId

in secong loop its getting error

Posted 22-Jun-11 21:17pm

jagadeesh123qqq

Updated 22-Jun-11 21:18pm

walterhevedeich

v2

Add a Solution

Comments

walterhevedeich 23-Jun-11 3:19am

Can you post the whole script of the stored procedure?

jagadeesh123qqq 23-Jun-11 3:20am

ALTER PROC [dbo].[SP_UpGridDateDetails]
(
@regId int,

@VlFNo Varchar(15),
@Stud_name varchar(100),
@FHG char,
@FHG_Name Varchar(100),

@MaritalStatus char

)
AS
BEGIN

UPDATE [KMDCModified].[dbo].[Register]
SET

[VLFNo]=@VlFNo
,[stud_name] = @Stud_name
,[FHG] = @FHG
,[FHG_Name] = @FHG_Name

,[maritalstatus] = @maritalstatus

WHERE regid=@regId

END

jagadeesh123qqq 23-Jun-11 3:36am

Hi,
Have u got?

jagadeesh123qqq 23-Jun-11 3:19am

ALTER PROC [dbo].[SP_UpGridDateDetails]
(
@regId int,

@VlFNo Varchar(15),
@Stud_name varchar(100),
@FHG char,
@FHG_Name Varchar(100),

@MaritalStatus char

)
AS
BEGIN

UPDATE [KMDCModified].[dbo].[Register]
SET

[VLFNo]=@VlFNo
,[stud_name] = @Stud_name
,[FHG] = @FHG
,[FHG_Name] = @FHG_Name

,[maritalstatus] = @maritalstatus

WHERE regid=@regId

END

1 solution

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)

OriginalGriff · Answer 1 · 2011-06-22T21:39:00

As it is the second loop round that gives the error it is fairly obvious: Don't use

objSqlCommand.Parameters.Add("@...", SqlDbType.VarChar).Value = ...);

in your loop unless you also create a new objSqlCommand in the loop as well.

Otherwise, you already have a parameter of that name, with a value, which can only get confusing.

BTW: Parameters.Add is depreciated in favour of Parameters.AddWithValue, which does not require the datatype.