FormView error:  too many arguments specified

Posted on 2006-03-31
Last Modified: 2008-01-16
I put a formview on my webpage so I can insert and edit records.  It does not work properly... I get an error stating that it has too many arguments, but I can't figure out what is wrong.  There is no clear message, it's just vague - the stored procedure takes exactly as many parameters as I am passing in.  I must be missing something, but I can't figure it out.  I have worked with the formview and changed the parameters.  I have exactly aligned the parameters of the SP with the parameters passed from the formview. It just doesn't work.

Here is the exact error that I receive:
"Procedure or function INS_SERVICECALLS_InsertNewServiceCall has too many arguments specified."

I have tried to put the Stank on this error, but in the end I had no luck.  Any help you can give is greatly appreciated.

- Stank Stank
Question by:stankstank
    LVL 21

    Accepted Solution

    see whether the following discussion helps you


    Author Comment

    I would really like to know how to fix this - the biggest problem is that I don't exactly understand what is going on.  Please help!

    Author Comment

    Unfortunately that wasn't the fix - here is my insert block (html):

                                            <asp:Parameter Name="Office_ID" Type="Int32" />
                                            <asp:Parameter Name="FK_Technician_ID" Type="Int32" />
                                            <asp:Parameter Name="FK_Priority_ID" Type="Int32" />
                                            <asp:Parameter Name="FK_Category_ID" Type="Int32" />
                                            <asp:Parameter Name="FK_Status_ID" Type="Int32" />
                                            <asp:Parameter Name="FK_Contact_ID" Type="Int32" />

    // Please note - they are all prefixed with 'FK_' because I was trying to standardize the names because of this error.  It did not fix the problem.


    Author Comment

    Ok, I have eliminated the problem.  My stored procedure sends back a column called 'Contact'.  it is not needed for updating, because the contactID is for this (which is also returned).  

    I don't understand why select/update are so closely tied together.  Is it is the same with insert?

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Today is the age of broadband.  More and more people are going this route determined to experience the web and it’s multitude of services as quickly and painlessly as possible. Coupled with the move to broadband, people are experiencing the web via …
    Introduction This article shows how to use the open source plupload control to upload multiple images. The images are resized on the client side before uploading and the upload is done in chunks. Background I had to provide a way for user…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now