CODEWITHSUNDEEP
asp.netsqllinq
Arbaaz
Arbaaz

Reputation: 121

How to pass session value in a query from .aspx code?

I want to pass session value from .aspx code , i.e the source code of the web

<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
        SelectCommand="SELECT Album.AlbumID, Album.DefaultPhotID, Album.AlbumName, PhotAlbum.Photo FROM Album INNER JOIN PhotAlbum ON Album.DefaultPhotID = PhotAlbum.PhotoID where userid=<%  Session["UserId"] %>">
    </asp:SqlDataSource>

I am doubtful if this code will work.

Upvotes: 0

Views: 1085

Answers (1)

Hary
Hary

Reputation: 5818

Use SessionParameter with SelectParameters to pass Session values

MSDN Doc

<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
    ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
    SelectCommand="SELECT Album.AlbumID, Album.DefaultPhotID, Album.AlbumName, PhotAlbum.Photo FROM Album INNER JOIN PhotAlbum ON Album.DefaultPhotID = PhotAlbum.PhotoID where userid=@userid">
<SelectParameters>
         <asp:SessionParameter Name="userid" Type="String"  SessionField="UserId" />
</SelectParameters>
   </asp:SqlDataSource>

Upvotes: 1

Related Questions