How to hide and show column in gridview

Question

I have written below lines of code in order to hide and show column in gridview based on the condition.

 <asp:TemplateField HeaderText="FirstName" Visible='<%# Eval("FirstName") != null ? true:false %>'>
    <ItemTemplate>
       <asp:Label ID="lblFirstName" runat="server" Text='<%#Eval("FirstName") %>'></asp:Label>
    </ItemTemplate>
 </asp:TemplateField>

It's not working!

Are you sure that `FirstName` is `null` and not an empty string? — Ben, Aug 06 '15 at 06:26
Most likely FirstName will be String.Empty and not null. Also change true:false to "true" : "false" — Martin, Aug 06 '15 at 06:31
Note that a template field will be evaluated for each row. You may have rows where First name is populated and rows when it is not. What is your expectation then? Look at other GridView events to handle this like `bound` and `rowDataBound`. You could have a variable that tracks if FirstName is ever populated. Update this in the `rowDataBound` event. Then in the `bound` event, check the variable and set the column visibility accordingly. — Jon P, Aug 06 '15 at 06:59

Krunal Mevada · Answer 1 · 2015-08-06T12:33:08.410

1

Update in code as below :

<asp:TemplateField HeaderText="FirstName" Visible='<%= !string.IsNullOrEmpty(Eval("FirstName")) ? "true" : "false" %>'>
    <ItemTemplate>
         <asp:Label ID="lblFirstName" runat="server" Text='<%#Eval("FirstName") %>'></asp:Label>
    </ItemTemplate>
</asp:TemplateField>

Edit

<asp:TemplateField HeaderText="FirstName" Visible='<%# !string.IsNullOrEmpty(Eval("FirstName")) ? "true" : "false" %>'>
    <ItemTemplate>
         <asp:Label ID="lblFirstName" runat="server" Text='<%#Eval("FirstName") %>'></asp:Label>
    </ItemTemplate>
</asp:TemplateField>

edited Aug 06 '15 at 12:33

answered Aug 06 '15 at 06:38

Krunal Mevada

1,637
1
17
28

It throws Cannot create an object of type 'System.Boolean' from its string representation '<%= !string.IsNullOrEmpty(Eval("FirstName")) ? "true" : "false" %>' for the 'Visible' property. – Aug 06 '15 at 06:46
1

`'<%# !string.IsNullOrEmpty(Eval("FirstName")) ? "true" : "false" %>'` – Krunal Mevada Aug 06 '15 at 12:26

score 0 · Accepted Answer · answered Aug 06 '15 at 07:37

Grid View

<asp:GridView ID="GridDisplay" runat="server" AutoGenerateColumns="False" BorderStyle="Groove"
                BorderWidth="1px" BorderColor="ActiveCaptionText" Width="100%" EmptyDataText="No Record Found"
                AllowPaging="True" OnPageIndexChanging="GridDisplay_PageIndexChanging" AllowSorting="True"
                OnRowEditing="GridDisplay_RowEditing" OnRowDeleting="GridDisplay_RowDeleting"
                CssClass="listbooking ListingTable">
                <Columns>
                    <asp:TemplateField HeaderText="Booking Code">
                        <ItemTemplate>
                            <%# Eval("id")%>
                        </ItemTemplate>
                        <HeaderStyle Width="5%" />
                    </asp:TemplateField>
                    <asp:TemplateField HeaderText="Property Code">
                        <ItemTemplate>
                            <%# Eval("property_id")%>
                        </ItemTemplate>
                        <HeaderStyle Width="5%" />
                    </asp:TemplateField>
                    <asp:TemplateField HeaderText="Name">
                        <ItemTemplate>
                            <%# Eval("sales_username")%>
                        </ItemTemplate>
                        <HeaderStyle Width="18%" />
                    </asp:TemplateField>                                         
                </Columns>              
            </asp:GridView>

i am trying to hide 2 columns(name).

During Binding the grid data

this.GridDisplay.Columns[2].Visible = false;

How to hide and show column in gridview

2 Answers2