Procedure or function Authorize_Member has too many arguments specified

  • Thread starter Thread starter Seth Williams
  • Start date Start date
S

Seth Williams

I have a sqlDataSource, using a stored procedure - the datasource is:
<asp:SqlDataSource ID="dsMembers" runat="server"
ConnectionString="<%$ ConnectionStrings:MainConnectionString %>"
SelectCommand="Get_MemberToUpdate"
SelectCommandType="StoredProcedure"
UpdateCommand="Authorize_Member"
UpdateCommandType="StoredProcedure">
<SelectParameters>
<asp:QueryStringParameter Name="MemberID"
QueryStringField="id" Type="Int32" />
</SelectParameters>
<UpdateParameters>
<asp:Parameter Name="memberID" Type="Int32" />
<asp:Parameter Name="Authorized" Type="Boolean" /> ' This is
a bit field in the database
</UpdateParameters>
</asp:SqlDataSource>

The DetailsView has the DataKeyNames property set correctly - - This was
working and I don't remember changing it in any way.
What could be the problem?
 
I forgot to mention that I get this error message only when Updating
Here's the sProc:
create PROCEDURE [dbo].[Authorize_Member]
@memberID INT,
@Authorized Bit
AS
BEGIN
UPDATE [dbo].[Members]
SET [Authorized] = @Authorized
WHERE MemberID=@MemberID



I have a sqlDataSource, using a stored procedure - the datasource is:
<asp:SqlDataSource ID="dsMembers" runat="server"
ConnectionString="<%$ ConnectionStrings:MainConnectionString %>"
SelectCommand="Get_MemberToUpdate"
SelectCommandType="StoredProcedure"
UpdateCommand="Authorize_Member"
UpdateCommandType="StoredProcedure">
<SelectParameters>
<asp:QueryStringParameter Name="MemberID"
QueryStringField="id" Type="Int32" />
</SelectParameters>
<UpdateParameters>
<asp:Parameter Name="memberID" Type="Int32" />
<asp:Parameter Name="Authorized" Type="Boolean" /> ' This is
a bit field in the database
</UpdateParameters>
</asp:SqlDataSource>

The DetailsView has the DataKeyNames property set correctly - - This was
working and I don't remember changing it in any way.
What could be the problem?
 
Back
Top