Do Not Display Specified Value From SQL Return In Asp.net WebForm GridView

Question

I have an asp.net application which has a gridview of all the users but i don't want the 'Admin' user to be displayed to the users.

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>

I have no code behind for this at all. Will I need some sort of stored proc or something ad if so how would I write it as stored proc's are not my strong point.

Kaushik Maheta · Accepted Answer · 2015-11-03 08:08:37Z

1

You need to add just where cluase to your select command like SELECT [Name] FROM [Users] Where [name] != 'Admin' OR SELECT [Name] FROM [Users] Where [fieldname] != 'Admin'. see below code.

<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>

answered Nov 3, 2015 at 8:08

Kaushik Maheta

1,9511 gold badge20 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

murday1983 Over a year ago

Cant believe I forgot I had the SelectCommand otherwise I wouldn't have needed to raise the question

Björn Boxstart · Accepted Answer · 2015-11-03 07:56:34Z

Just append a where clause to your SelectCommand.

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>

Collectives™ on Stack Overflow

Do Not Display Specified Value From SQL Return In Asp.net WebForm GridView

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related