Posted by JJ297 on 10/29/07 19:06

On Oct 29, 2:52 pm, "Plamen Ratchev" <Pla...@SQLStudio.com> wrote:
> This error message appears when you try to call a stored procedure and
> supply more parameters than those declared for that procedure. Look at the
> code where you call the UpdateResources procedure and check that you pass
> the correct parameter list.
>
> HTH,
>
> Plamen Ratchevhttp://www.SQLStudio.com

I've checked everything and can't figure it out. Here's the code on
the other page any suggestions?

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:TrainUserConnectionString %>"
SelectCommand="GetResourceLibraryInfo"
SelectCommandType="StoredProcedure" UpdateCommand="UpdateResources"
UpdateCommandType="StoredProcedure">
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList1" DefaultValue="1"
Name="Type" PropertyName="SelectedValue"
Type="String" />
</SelectParameters>
<UpdateParameters>
<asp:Parameter Name="titleID" Type="Int32" />
<asp:Parameter Name="title" Type="String" />
<asp:Parameter Name="description" Type="String" />
<asp:Parameter Name="quantityowned" Type="Int32" />
</UpdateParameters>
</asp:SqlDataSource>

• Next in forum: Re: Error message with stored procedure
• Prev in forum: Re: Error message with stored procedure
• Thread view: Re: Error message with stored procedure

[Reply to this message]