SqlDataSource strange behaviour

Question

For the life of me, I can't understand this problem. Basically, I have a SqlDataSource which is refusing to return data if there are ANY select parameters. For instance;

<asp:SqlDataSource ID="sdsSubscriptions" runat="server"
    ConnectionString='<%$ ConnectionStrings:DBConnectionString %>'
    SelectCommand="SELECT ID, Description FROM Subscription.[Subscriptions">
    <SelectParameters>
        <asp:Parameter Name="UserID" Type="Int32" Direction="Input" />
    </SelectParameters>
</asp:SqlDataSource>

The above does not work. If I remove the SelectParameters, it does work.

In my actual web site, the UserID parameter is used. I arrived at the above code after reducing it to find the problem.

Does anyone know why this might be happening? Thanks

abatishchev · Accepted Answer · 2011-02-01 11:02:07Z

1

If SelectCommand contains no parameters, you should not specify any SelectParameters.

answered Feb 1, 2011 at 11:02

abatishchev

101k88 gold badges303 silver badges443 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Barguast Over a year ago

Doesn't make a difference in this case - if I add 'WHERE @UserID IS NULL OR @UserID IS NOT NULL' it still doesn't work.

Collectives™ on Stack Overflow

SqlDataSource strange behaviour

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related