CODEWITHSUNDEEP
c#asp.netsql
Arbaaz
Arbaaz

Reputation: 121

Passing Request.QueryString integer value in a sql query from source code

I am trying to pass Request.QueryString integer value in a query from source code. How do i do it? 

http://localhost:3738/WebSite3/UserDetails.aspx?Id=43

I want to pass id's value i.e 43 in query

 <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:SLIITComDBConnectionString %>" 

    SelectCommand="SELECT Album.AlbumID, Album.DefaultPhotID, Album.AlbumName, PhotAlbum.Photo FROM Album INNER JOIN PhotAlbum ON Album.DefaultPhotID = PhotAlbum.PhotoID where album.userid= **Request.QueryString[id]** ">

Upvotes: 1

Views: 1327

Answers (2)

Microsoft DN
Microsoft DN

Reputation: 10030

You can use this:

 <%=this.Request.QueryString["Id"]%>

Upvotes: 0

Hary
Hary

Reputation: 5818

Use QueryStringParameter

<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
    ConnectionString="<%$ ConnectionStrings:SLIITComDBConnectionString %>" 

SelectCommand="SELECT Album.AlbumID, Album.DefaultPhotID, Album.AlbumName, PhotAlbum.Photo FROM Album INNER JOIN PhotAlbum ON Album.DefaultPhotID = PhotAlbum.PhotoID where album.userid= @userid ">
   <SelectParameters>
      <asp:QueryStringParameter Name="userid" Type="String"  QueryStringField="id" />
   </SelectParameters>
</asp:SqlDataSource>

Upvotes: 4

Related Questions