How to hide a TemplateField column in a GridView

Question

How can I hide a TemplateField column in a GridView?

I tried the following:

<asp:TemplateField ShowHeader="False" Visible='<%# MyBoolProperty %>' >
<ItemTemplate>
    <asp:LinkButton ID="attachmentButton" runat="server" ... />
</ItemTemplate>

but it didn't work and gives the following error:

Databinding expressions are only supported on objects that have a DataBinding event. System.Web.UI.WebControls.TemplateField does not have a DataBinding event.

I tried also to hide it programmatically, but seems it's not possible to get a column by the name because there iss no name for TemplateField column.

naveen · Accepted Answer · 2015-07-07T01:25:45.550

60

protected void OnRowCreated(object sender, GridViewRowEventArgs e)
{
         e.Row.Cells[columnIndex].Visible = false;
}

If you don't prefer hard-coded index, the only workaround I can suggest is to provide a HeaderText for the GridViewColumn and then find the column using that HeaderText.

protected void UsersGrid_RowCreated(object sender, GridViewRowEventArgs e)
{
    ((DataControlField)UsersGrid.Columns
            .Cast<DataControlField>()
            .Where(fld => fld.HeaderText == "Email")
            .SingleOrDefault()).Visible = false;
}

edited Jul 07 '15 at 01:25

answered Feb 10 '11 at 08:47

naveen

53,448
46
161
251

4

Thanks, but I wonder how can I get its index, I don't prefer the hard-coded indexes. – Homam Feb 10 '11 at 08:49
@naveen e.Row.Cells[columnIndex].Visible = false; hides column data perfectly.... What if i also want to hide corresponding Header Template?? – Gk_999 Jul 10 '14 at 06:54
@Gk_999: It hides the header template too – naveen Jul 10 '14 at 10:38
@naveen your solution with DataControlField works also after databind the only advise is to put the title of column in this way: – Caesar Nov 28 '14 at 17:04
What if the HeaderText is localized? – A-Sharabiani Sep 05 '18 at 15:59
1

@A-Sharabiani: been a while. Will check when I get time – naveen Sep 07 '18 at 17:40
Doing it on OnDataBound event will only run it once instead of once per row. This may be prefer if the function is heavy. – Tomas Beblar Sep 25 '19 at 00:38

Chad · Answer 2 · 2012-06-29T23:03:48.470

If appears to me that rows where Visible is set to false won't be accessible, that they are removed from the DOM rather than hidden, so I also used the Display: None approach. In my case, I wanted to have a hidden column that contained the key of the Row. To me, this declarative approach is a little cleaner than some of the other approaches that use code.

<style>
   .HiddenCol{display:none;}                
</style>


 <%--ROW ID--%>
      <asp:TemplateField HeaderText="Row ID">
       <HeaderStyle CssClass="HiddenCol" />
       <ItemTemplate>
       <asp:Label ID="lblROW_ID" runat="server" Text='<%# Bind("ROW_ID") %>'></asp:Label>
       </ItemTemplate>
       <ItemStyle HorizontalAlign="Right" CssClass="HiddenCol" />
       <EditItemTemplate>
       <asp:TextBox ID="txtROW_ID" runat="server" Text='<%# Bind("ROW_ID") %>'></asp:TextBox>
       </EditItemTemplate>
       <FooterStyle CssClass="HiddenCol" />
      </asp:TemplateField>

score 10 · Answer 3 · edited Mar 29 '12 at 13:04

10

For Each dcfColumn As DataControlField In gvGridview.Columns
    If dcfColumn.HeaderText = "ColumnHeaderText" Then
        dcfColumn.Visible = false                    
    End If
Next

edited Mar 29 '12 at 13:04

abatishchev

98,240
88
296
433

answered Feb 17 '12 at 13:47

Deepak Mishra

2,984
1
26
32

score 7 · Answer 4 · edited Dec 06 '18 at 14:40

7

GridView1.Columns[columnIndex].Visible = false;

edited Dec 06 '18 at 14:40

Bugs

4,491
9
32
41

answered Nov 16 '12 at 05:24

Sandeepkumar Gupta

420
3
14

score 4 · Answer 5 · answered Feb 10 '11 at 08:39

4

try this

.hiddencol
    {
        display:none;
    }
    .viscol
    {
        display:block;
    }

add following code on RowCreated Event of GridView

protected void OnRowCreated(object sender, GridViewRowEventArgs e)
{
     if (e.Row.RowType == DataControlRowType.DataRow)
     {
         e.Row.Cells[0].CssClass = "hiddencol";
     }
     else if (e.Row.RowType == DataControlRowType.Header)
     {
         e.Row.Cells[0].CssClass = "hiddencol";
     }
}

answered Feb 10 '11 at 08:39

santosh singh

27,666
26
83
129

3

this is fine if all you care about is the visibility on the screen, however if you are showing/hiding private information (IE stackoverflow real name) then you cannot just hide it on the client, it can't be sent to the client at all – Nathan Koop Jul 30 '12 at 18:32

frenchone · Answer 6 · 2015-07-02T10:14:06.670

2

Am I missing something ?

If you can't set visibility on TemplateField then set it on its content

<asp:TemplateField>
  <ItemTemplate>
    <asp:LinkButton Visible='<%# MyBoolProperty %>' ID="foo" runat="server" ... />
  </ItemTemplate>
</asp:TemplateField>

or if your content is complex then enclose it into a div and set visibility on the div

<asp:TemplateField>
  <ItemTemplate>
    <div runat="server" visible='<%# MyBoolProperty  %>' >
      <asp:LinkButton ID="attachmentButton" runat="server" ... />
    </div>
  </ItemTemplate>
</asp:TemplateField>

edited Jul 02 '15 at 10:14

answered Feb 28 '14 at 09:27

frenchone

1,547
4
19
34

Problem with that is that you cannot place a
outside of a template field.
– Fandango68 Jun 29 '15 at 04:07
1

Seemed quite obvious to me that the div was inside the templatefield. Anyway I edited to make it more obvious than obvious – frenchone Jul 02 '15 at 10:10

score 1 · Answer 7 · edited Oct 13 '18 at 09:39

protected void gvLogMessageDetail_RowDataBound(object sender, GridViewRowEventArgs e)  
    { 
      if (e.Row.RowType == DataControlRowType.Header)   
        {  
            if (rdlForImportOrExport.SelectedIndex == 1)  
            {  
                e.Row.Cells[3].Visible = false;  
                e.Row.Cells[4].Visible = false;  
                e.Row.Cells[5].Visible = false;  
            }  
            else  
            {  
                e.Row.Cells[3].Visible = true;  
                e.Row.Cells[4].Visible = true;  
                e.Row.Cells[5].Visible = true;  
            }  
        }    
        if (e.Row.RowType == DataControlRowType.DataRow) //skip header row  
        {  
            try  
            {  
                if (rdlForImportOrExport.SelectedIndex == 1)  
                {  
                    e.Row.Cells[3].Visible = false;  
                    e.Row.Cells[4].Visible = false;  
                    e.Row.Cells[5].Visible = false;  
                }  
                else  
                {  
                    e.Row.Cells[3].Visible = true;  
                    e.Row.Cells[4].Visible = true;  
                    e.Row.Cells[5].Visible = true;  
                }  
                }  
            catch  
            {  
                ClientScript.RegisterStartupScript(GetType(), "Expand", "<SCRIPT   LANGUAGE='javascript'>alert('There is binding problem in child grid.');</script>");  
            }  
        }  
    }

score 1 · Answer 8 · answered Nov 04 '14 at 23:45

A slight improvement using column name, IMHO:

    Private Sub GridView1_Init(sender As Object, e As System.EventArgs) Handles GridView1.Init
    For Each dcf As DataControlField In GridView1.Columns
        Select Case dcf.HeaderText.ToUpper
            Case "CBSELECT"
                dcf.Visible = Me.CheckBoxVisible
                dcf.HeaderText = "<small>Select</small>"
        End Select
    Next
End Sub

This allows control over multiple column. I initially use a 'technical' column name, matching the control name within. This makes it obvious within the ASCX page that it's a control column. Then swap out the name as desired for presentation. If I spy the odd name in production, I know I skipped something. The "ToUpper" avoids case-issues.

Finally, this runs ONE time on any post instead of capturing the event during row-creation.

score 0 · Answer 9 · answered Jul 04 '14 at 16:23

This can be another way to do it and validate nulls

DataControlField dataControlField = UsersGrid.Columns.Cast<DataControlField>().SingleOrDefault(x => x.HeaderText == "Email");
            if (dataControlField != null)
                dataControlField.Visible = false;

How to hide a TemplateField column in a GridView

9 Answers9

Linked