如何在aspNet_membership中定义的UserId上使用QueryString? [英] How to use QueryString on UserId defined in aspNet_membership?

问题描述

如何在aspNet_membership中定义的UserId上使用QueryString?

我的订单表有一个来自aspNet_membership的UserId外键，uniqueidentifier.

我在下面尝试过，甚至指定了一个不起作用的UserId

How to use QueryString on UserId defined in aspNet_membership?

My order table has a foreignkey of UserId from aspNet_membership, uniqueidentifier.

I tried below,even specify a single UserId not working

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
      ConnectionString="<%$ ConnectionStrings:ASPNETDBConnectionString1 %>"
      SelectCommand="SELECT * FROM [JobList] WHERE ([UserId] = @UserId)">
      <SelectParameters>
          <asp:QueryStringParameter DefaultValue="c0502e35-ecb1-4c5c-b9a4-f681ac4dc274"
              Name="UserId" QueryStringField="UserId" Type="Object" />
      </SelectParameters>
  </asp:SqlDataSource>

推荐答案

ConnectionStrings:ASPNETDBConnectionString1 ％> " SelectCommand =" > < SelectParameters > < asp:QueryStringParameter 默认值 =" span> span> 名称 =" QueryStringField =" 类型 =" 对象" / > < /SelectParameters > < /asp:SqlDataSource >

ConnectionStrings:ASPNETDBConnectionString1 %>" SelectCommand="SELECT * FROM [JobList] WHERE ([UserId] = @UserId)"> <SelectParameters> <asp:QueryStringParameter DefaultValue="c0502e35-ecb1-4c5c-b9a4-f681ac4dc274" Name="UserId" QueryStringField="UserId" Type="Object" /> </SelectParameters> </asp:SqlDataSource>

SQL Server将uniqueidentifier(guid)字段视为字符串.要查询，您将需要使用单引号将@UserId参数包装起来

SQL Server treats a uniqueidentifier(guid) field as a string. To query you will need to use single quotes to wrap the @UserId parameter

这篇关于如何在aspNet_membership中定义的UserId上使用QueryString?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！