too many arguments specified

[Dimitrie1]

I have an formview with an update template. When I click update I get the error message Procedure or function Web_UpdateFolderInfoAL_CCW has too many arguments specified

unfortunately, I don't have Query Profiler to trace it.

here's my asp datasource code

 <asp:SqlDataSource ID="dsInfos" runat="server" ConnectionString="<%$ ConnectionStrings:amanda_ConnectionString %>"
            SelectCommand="Web_SelectFolderInfoAL_CCW" SelectCommandType="StoredProcedure"
            UpdateCommand="Web_UpdateFolderInfoAL_CCW" UpdateCommandType="StoredProcedure">
            
           <UpdateParameters>
                <asp:Parameter Name="folderrsn" Type="Int64" />
                <asp:Parameter Name="spayed" Type="Int32"  DefaultValue="0"/>                
                <asp:Parameter Name="not_spayed" Type="Int32" DefaultValue="0" />
                <asp:Parameter Name="breed1" Type="String" DefaultValue="" />
                <asp:Parameter Name="breed2" Type="String" DefaultValue=""/>
                <asp:Parameter Name="birthdate1" Type="String" DefaultValue=""/>
                <asp:Parameter Name="birthdate2" Type="String" DefaultValue=""/>
                <asp:Parameter Name="accept" Type="String" DefaultValue="" />
            </UpdateParameters>  [\code]

and the start of my sql code [code]
ALTER     procedure dbo.Web_UpdateFolderInfoAL_CCW (
@folderrsn bigint,
@spayed int,
@not_spayed int,
@breed1 varchar(100),
@breed2 varchar(100),
@birthdate1 varchar(20),
@birthdate2 varchar(20),
@accept varchar(3)
) as 

[\code]

 

[jbenson001]

This is the problem with using datasource controls. They make building a page easier, but it's more difficult to debug as you can see. I would use Microsoft's helper classes or, use command objects and call your stored procedures yourself. It will take a little more code, but in the long run, it will help you debug and maintain code.

 

[Dimitrie1]

thanks
I figured it out. my select had a field with a slightly different name than the update.