不要在Asp.net WebForm GridView中显示SQL返回的指定值
本文关键字:返回 SQL 显示 Asp net GridView WebForm | 更新日期: 2023-09-27 18:20:15
我有一个asp.net
应用程序,它包含所有用户的gridview
,但我不希望向用户显示"Admin"用户。
HTML
<asp:GridView ID="tblUsers" runat="server" AutoGenerateColumns="False" CellPadding="4" DataSourceID="SqlUsers" GridLines="None" Width="15%">
<AlternatingRowStyle BackColor="White" />
<Columns>
<asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
</Columns>
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<RowStyle BackColor="#EFF3FB" />
</asp:GridView>
<asp:SqlDataSource ID="SqlUsers" runat="server" ConnectionString="<%$ ConnectionStrings:PaydayLunchConnectionString1 %>" SelectCommand="SELECT [Name] FROM [Users]"></asp:SqlDataSource>
我完全没有这方面的代码。我需要某种存储过程吗?如果需要的话,我会如何将其写为存储过程不是我的强项。
您需要将where cluase添加到您的选择命令中,如select[Name]FROM[Users]where[Name]!='Admin'或SELECT[Name]FROM[Users]Where[fieldname]!='管理员。请参阅下面的代码。
<asp:GridView ID="tblUsers" runat="server" AutoGenerateColumns="False" CellPadding="4" DataSourceID="SqlUsers" GridLines="None" Width="15%">
<AlternatingRowStyle BackColor="White" />
<Columns>
<asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
</Columns>
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<RowStyle BackColor="#EFF3FB" />
</asp:GridView>
<asp:SqlDataSource ID="SqlUsers" runat="server" ConnectionString="<%$ ConnectionStrings:PaydayLunchConnectionString1 %>" SelectCommand="SELECT [Name] FROM [Users] Where [name] != 'Admin'"></asp:SqlDataSource>
只需在SelectCommand中附加一个where子句。
HTML
<asp:GridView ID="tblUsers" runat="server" AutoGenerateColumns="False" CellPadding="4" DataSourceID="SqlUsers" GridLines="None" Width="15%">
<AlternatingRowStyle BackColor="White" />
<Columns>
<asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
</Columns>
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<RowStyle BackColor="#EFF3FB" />
</asp:GridView>
<asp:SqlDataSource
ID="SqlUsers"
runat="server"
ConnectionString="<%$ ConnectionStrings:PaydayLunchConnectionString1 %>"
SelectCommand="SELECT [Name] FROM [Users] WHERE [name] <> 'Admin'"></asp:SqlDataSource>