Insert into DB using stored procedure
<p>I have a FormView that has it's default mode set to "insert".  There are a bunch of controls on the form that the user enters data.  Once I press the insert button, I get this error: Procedure or function sp_fc_vm_insertDebtorContact has too many arguments specified</p>

<p>I am pretty sure the stored procedure is correct so I am wondering if it is my code.  Here is the SqlDataSource code:</p>

<blockquote>
<pre><code>    &lt;asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="&lt;%$ ConnectionStrings:AuditDevConnectionString2 %&gt;"            

        InsertCommand="sp_fc_vm_insertDebtorContact" 
        InsertCommandType="StoredProcedure" 
        SelectCommand="sp_fc_vm_insertDebtorContact" 
        SelectCommandType="StoredProcedure" &gt;
        &lt;InsertParameters&gt;
            &lt;asp:QueryStringParameter DefaultValue="0" Name="DebtorKey" 
            QueryStringField="DebtorKey" Type="Int32" /&gt;
            &lt;asp:Parameter Name="LastName" /&gt;
            &lt;asp:Parameter Name="FirstName" /&gt;
            &lt;asp:Parameter Name="Title" /&gt;
            &lt;asp:Parameter Name="Authority" DefaultValue="0" /&gt;
            &lt;asp:Parameter Name="Extension" /&gt;
            &lt;asp:Parameter Name="Email" /&gt;
            &lt;asp:Parameter Name="Comments" /&gt;
            &lt;asp:Parameter Name="Phone" /&gt;
            &lt;asp:Parameter Name="Attention" DefaultValue="0" /&gt;
            &lt;asp:Parameter Name="Fax" /&gt;
            &lt;asp:Parameter Name="Ownership" DefaultValue="0" /&gt;
            &lt;asp:Parameter Name="Guarantor" DefaultValue="0" /&gt;
            &lt;asp:Parameter Name="Notices" DefaultValue="0" /&gt;
            &lt;asp:Parameter Name="Addr1" /&gt;
            &lt;asp:Parameter Name="Addr2" /&gt;
            &lt;asp:Parameter Name="City" /&gt;
            &lt;asp:Parameter Name="State" /&gt;
            &lt;asp:Parameter Name="ZipCode" /&gt;
            &lt;asp:Parameter Name="CellPhone" /&gt;
            &lt;asp:Parameter Name="Country" /&gt;
        &lt;/InsertParameters&gt;
    &lt;/asp:SqlDataSource&gt;
</code></pre>
</blockquote>

<p>Here is the stored procedure -</p>

<pre><code>ALTER proc [dbo].[sp_fc_vm_insertDebtorContact] (@DebtorKey int,  @LastName varchar(50), 
      @FirstName varchar(20), @Title nvarchar(30), @Authority bit, @Extension nvarchar(10), @Email nvarchar(50),
      @Comments ntext, @Phone nvarchar(20), @Attention bit, @Fax nvarchar(20), @Ownership money, @Guarantor bit,
      @Notices bit, @Addr1 nvarchar(30), @Addr2 nvarchar(30), @City nvarchar(30), @State nvarchar(30),  
      @ZipCode nvarchar(10), @CellPhone varchar(20), @Country nvarchar(30))

AS

INSERT INTO [FSDev].dbo.Contacts (ClientKey, DebtorKey, lastname, NameKey, firstname, title, authority, extention,
Email, Notes, Phone, attention, Fax, brokerskey, inactive, [ownership], guarantor, notices, addr1, addr2,
city, [state], zipcode, cellphone, country)

VALUES (0, @DebtorKey, @LastName, LEFT(UPPER(@FirstName)+UPPER(@LastName),20), @FirstName, @Title, @Authority,
@Extension, @Email, @Comments, @Phone, @Attention, @Fax, 0, 0, @Ownership, @Guarantor, 0, @Addr1, @Addr2,
@City, @State, @ZipCode, @CellPhone, @country)
</code></pre>

<p>The stored procedure works fine in SQL, so I guess I am doing something wrong.</p>
