Stored Procedure has too many parameters

Question

Posibale Duplicate Getting 'too many parameters passed' to stored procedure on ASPX page

I'm using a SqlDataSource control for some update and delete functionality within a GridView. I keep getting the runtime error Procedure or function spUpdateTest has too many arguments specified. When I run the stored procedure in SQL Server it works fine. When I click on the delete portion of the GridView, that works. However, when I try to update I get the above error.

You can see the six parameters in the SqlDataSource. Now here is my stored procedure

create proc spUpdateTest  
 @PatientId int  
,@RaceId int  
,@CountyId int  
,@Gender varchar(50)  
,@DateOfBirth date  
,@SesId int  
as  
begin  
update t  
set  t.raceid = @RaceId  
 ,t.countyId = @CountyId  
 ,t.gender = @Gender  
 ,t.DateOfBirth = @DateOfBirth  
 ,t.SocioEconomicStatusId = @SesId  
from test as t  
where t.patientId = @PatientId  
end

both have six parameters. GridView for good measure in case it makes a difference

I don't know if it means anything, but I do have one field, DateEnrolled which is not meant to be edited by the user and is saved to the database as GetDate() whenever a Test object is added to the database.

C#

public static void UpdateTest(int PatientId, int raceID, int countyId, string gender
            , DateTime dateOfBirth, int sesId)
        {
            using (SqlConnection con = new SqlConnection(TestDataAccessLayer.ConnectionString))
            {
                using (SqlCommand cmd = new SqlCommand("spUpdateTest", con))
                {
                    con.Open();
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.Parameters.AddWithValue("@RaceDescription", raceID);
                    cmd.Parameters.AddWithValue("@CountyName", countyId);
                    cmd.Parameters.AddWithValue("@Gender", gender);
                    cmd.Parameters.AddWithValue("@DateOfBirth", dateOfBirth);
                    cmd.Parameters.AddWithValue("@SesDescription", sesId);
                    cmd.Parameters.AddWithValue("@PatientId", PatientId);
                    cmd.ExecuteNonQuery();
                }
            }
        }

this works

public static void DeleteTest(int PatientId)
        {
            using (SqlConnection con = new SqlConnection(TestDataAccessLayer.ConnectionString))
            {
                using (SqlCommand cmd = new SqlCommand("spDeleteTest", con))
                {
                    con.Open();
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.Parameters.AddWithValue("@PatientId", PatientId);
                    cmd.ExecuteNonQuery();
                }
            }
        }

Where is this mysterious extra parameter coming from that I don't know about?

Stored Procedure has too many parameters

Answers (1)

Related Questions