GridView - Procedure or function has too many arguments specified

Question

I have this Stored Procedure:

USE [Events2]
GO
/****** Object:  StoredProcedure [dbo].[spUpdateRegistrantPaper]    Script Date: 11/20/2015 7:02:31 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[spUpdateRegistrantPaper]
    -- Add the parameters for the stored procedure here
        @RegistrantId int,
        @LocalNumber int,
        @LocalUnionEmail nvarchar(50),
        @DistrictId int,
        @CompletedByFirstName nvarchar(20),
        @CompletedByLastName nvarchar(25),
        @CompletedByPhone nvarchar(15),
        @FirstName nvarchar(20),
        @LastName nvarchar(25),
        @Position nvarchar(15),
        @Email nvarchar(50),
        @ShirtSize nvarchar(50),
        @Comments nvarchar(300)
AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

    -- Insert statements for procedure here
    UPDATE Registrant SET
        LocalNumberId = @LocalNumber,
        LocalUnionEmail = @LocalUnionEmail,
        DistrictId = @DistrictId,
        CompletedByFirstName = @CompletedByFirstName,
        CompletedByLastName = @CompletedByLastName,
        CompletedByPhone = @CompletedByPhone,
        FirstName = @FirstName,
        LastName = @LastName,
        Position = @Position,
        Email = @Email,
        ShirtSize = @ShirtSize,
        Comments = @Comments
        WHERE RegistrantId = @RegistrantId
END

And I have a GridView with an Edit and Update button.

But I am getting this error:

Procedure or function spUpdateRegistrantPaper has too many arguments specified.

I don't see why...??? What can I do to fix this?

EDIT

Here is full asp.net code:

<%@ Page Title="" Language="C#" MasterPageFile="~/admin/admin.master" AutoEventWireup="true" CodeFile="viewregistrantpaper.aspx.cs" Inherits="viewreg" %>




View Registrant

Andrei · Accepted Answer

Notice that you are using a lot of BoundFields in your GridView. The thing to know about these fields is that their values are added to the update/insert commands automatically. So for instance:

This will result in param LocalNumberId being added to the call of your stored proc. Since you already have just LocalNumber as a param, LocalNumberId turns out as an unexpected. Thus you have all parameters you explicitly declared in UpdateParameters tag as well as others which are in a BoundField.

Your options that I see here:

Make sure BoundFields represent accurately params you want in the stored proc, rename columns or stored proc params as needed.
Get rid of bound fields, use TemplateFields with Eval instead. Simple example:

Instead of
You would have
```
    
        <%# Eval("LocalNumberId") %>
    
```
Manually write call to the stored proc as UpdateCommand, using only params you require

GridView - Procedure or function has too many arguments specified

Answers (1)

Related Questions