ASP.NET从Gridview中显示特定值 [英] ASP.NET display specific value from Gridview

问题描述

我想在gridview中为特定用户显示值。在测试查询中它工作正常，但没有在页面上显示值。怎么了？

 <   asp：GridView     ID   =   GridView1    runat   =  server    AutoGenerateColumns   =  False    DataSourceID   =  SqlDataSource1    宽度  = < span class =code-keyword> 698px    OnSelectedIndexChanged   =  GridView1_SelectedIndexChanged    DataKeyNames   =  Idoferty >  
 <  列 >  
 <   asp：BoundField     DataField   =   Idoferty    HeaderText   =  Idoferty   所以， rtExpression   =  Idoferty    /  >  
 <   /列 >  
 <   / asp：GridView  >  
 <   asp：SqlDataSource     ID   =  SqlDataSource1    runat   =  server    ConnectionString   =  <％ $ ConnectionStrings：ofety_stopowiczeV1ConnectionString％>     SelectCommand   = < span class =code-keyword> SELECT [Idoferty] FROM [rezerwacje] WHERE（[user] = @user） >  
 <   SelectParameters  >  
 <   asp：SessionParameter    < span class =code-attribute>名称  =  user    SessionField   =  User.Identity.Name   类型  = 字符串    /  >  
 <   / SelectParameters  >  
 <   / asp：SqlDataSource  >  

SELECT语句

  SELECT  [Idoferty]  FROM  [ rezerwacje]  WHERE （[ user ] =  @ user ）

解决方案

ConnectionStrings：ofety_stopowicz eV1ConnectionString％> SelectCommand = SELECT [Idoferty] FROM [rezerwacje] WHERE（[user] = @user） >
< SelectParameters >
< asp：SessionParameter 名称 = user SessionField = User.Identity.Name 类型 = 字符串 / >
< / SelectParameters < span class =code-keyword>>
< / asp：SqlDataSource >

SELECT语句

  SELECT  [Idoferty]  FROM  [rezerwacje]  WHERE （[用户] =  @ user ）

你的 SessionField 是错误的还是 Session 。

确保您设置的会话是 User.Identity.Name

I want to show value in gridview for specific user. In 'Test Query' it works fine, but didn't show value on page. What's wrong?

        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" Width="698px" OnSelectedIndexChanged="GridView1_SelectedIndexChanged" DataKeyNames="Idoferty">
            <Columns>
                <asp:BoundField DataField="Idoferty" HeaderText="Idoferty" SortExpression="Idoferty" />
            </Columns>
        </asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ofety_stopowiczeV1ConnectionString %>" SelectCommand="SELECT [Idoferty] FROM [rezerwacje] WHERE ([user] = @user)">
                <SelectParameters>
                    <asp:SessionParameter Name="user" SessionField="User.Identity.Name" Type="String" />
                </SelectParameters>
            </asp:SqlDataSource>

SELECT statement

SELECT [Idoferty] FROM [rezerwacje] WHERE ([user] = @user)

解决方案

ConnectionStrings:ofety_stopowiczeV1ConnectionString %>" SelectCommand="SELECT [Idoferty] FROM [rezerwacje] WHERE ([user] = @user)"> <SelectParameters> <asp:SessionParameter Name="user" SessionField="User.Identity.Name" Type="String" /> </SelectParameters> </asp:SqlDataSource>

SELECT statement

SELECT [Idoferty] FROM [rezerwacje] WHERE ([user] = @user)

Either your SessionField is wrong or there is no data in Session.
Make sure the Session you set is User.Identity.Name.

这篇关于ASP.NET从Gridview中显示特定值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！