sqldatasource keeps telling me parameter is missing, but it is not.

Question

User297437924 posted

I have a sql data source with parameters as follows:

<SelectParameters>
                    <asp:Parameter DefaultValue="0" Name="IDst" Type="Int32" />
                    <asp:SessionParameter DefaultValue="0" Name="videoid" SessionField="videoid_zUser" Type="Int32" />
                    <asp:SessionParameter DefaultValue="0" Name="currentwatcherid" SessionField="watcherid" Type="Int32" />
                      <asp:SessionParameter DefaultValue="0" Name="showFirstAndLastName" SessionField="showFirstAndLastName" Type="Boolean" />
                                        <asp:Parameter DefaultValue="true"  Name="OnlyShowOtherDocsIfHaveto" Type="Boolean" />
                </SelectParameters>

This calls a sql server procedure whose arguments are:

ALTER PROCEDURE [dbo].[GetHighlightAnswersGivenVideoid]
@IDst int,
@videoid int,
@showfirstandlastname bit,
@currentwatcherid int,
@OnlyShowOtherDocsIfHaveto bit

When the page calls it, though, I get the following message:

Database Error: Please wait a few seconds, and try again -- Procedure or function 'GetHighlightAnswersGivenVideoid' expects parameter 
'@OnlyShowOtherDocsIfHaveto', which was not supplied.

I don't understand this.  The parameter is obviously supplied, and I've done a global search through the solution and this is the only call in this page

Answer 1

User-1716253493 posted

Have you set selectcommandtype to sp?

SelectCommandType="StoredProcedure"

Answer 2

User297437924 posted

I just found out that my parameter had a space between it and the quotes around it.  That was the problem.   The code I show above was not the code causing the error.

Thanks.