Problems using SQL in conjuction with ASP.NET

Question

Sorry I am new to this, but heres what I'm trying to do.

This is what I currently have

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT * FROM [Products]"></asp:SqlDataSource>

but what Im trying to do is this

SELECT * FROM [Products] WHERE category = categorylabel.Text

I have a column in my database called category, and I want only the data thats category type matches a category in a hidden label (or a session) called categorylabel.Text to do this, the label gets updated with the session. It may be unncessary but I couldnt think of how else to do it.

So how would I go about using my session, to make the SqlDataSource1 only display the data in the Products database that has a category matching that session?

Thanks a lot for the help!

Christos · Accepted Answer · 2014-04-27 21:28:31Z

1

Try this one:

<asp:SqlDataSource ID="SqlDataSource1" 
                   runat="server" 
                   ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
                   SelectCommand="SELECT * FROM [Products] WHERE category=@category">
    <SelectParameters>
        <asp:ControlParameter ControlID="categorylabel" Name="category" PropertyName="Text" Type="String" />
    </SelectParameters>
</asp:SqlDataSource>

edited Apr 27, 2014 at 21:28

answered Apr 27, 2014 at 21:14

Christos

54.1k9 gold badges82 silver badges114 bronze badges

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

Collectives™ on Stack Overflow

Problems using SQL in conjuction with ASP.NET

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related