Re: Error message with stored procedure

On Oct 29, 2:52 pm, "Plamen Ratchev" <Pla...@xxxxxxxxxxxxx> 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>

.