从源代码在sql查询中传递Request.QueryString整数值
本文关键字:Request QueryString 整数 源代码 sql 查询 | 更新日期: 2023-09-27 17:57:48
我正试图在源代码的查询中传递Request.QueryString整数值。我该怎么做?
http://localhost:3738/WebSite3/UserDetails.aspx?Id=43
我想在查询中传递id的值,即43
<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]** ">
使用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>
您可以使用这个:
<%=this.Request.QueryString["Id"]%>