How to hide GridView Coumn[1]?

Question

I am trying to hide the gridview coumn[1]. But it shows error like

Index was out of range. Must be non-negative and less than the size of
the collection parameter name:index.

How can I perform this. I surfed a lot in internet but I didnt get a proper solution. My code I mentioned below.It is a web based platform.

protected void Page_Load(object sender, EventArgs e)
 {
   if (!IsPostBack)
     {
      qry = "select Id,Name,Age,Sex,Dob from Sample where Code='123';
      dr = conn.query(qry);
      GridView1.DataSource = dr;
      GridView1.DataBind();
      GridView1.Columns[1].Visible = false;
      }
 }

In this same way column[0] is hiding. My grid view is

 <asp:GridView ID="GridView1" HorizontalAlign="Center" runat="server" 
      onrowcommand="GridView1_RowCommand">
    <Columns>
       <asp:TemplateField>
          <ItemTemplate>
             <asp:LinkButton ID="LinkButton1" runat="server"
                   CommandArgument='<%# Eval("ID")%>'>Delete</asp:LinkButton>
             </ItemTemplate>
         </asp:TemplateField>
    </Columns>
</asp:GridView>

@Șhȇkhaṝ,column1 value will add from database(from query result) — Semil Sebastian, Feb 12 '15 at 04:15

score 1 · Accepted Answer · edited May 23 '17 at 11:49

1

You need to use RowDataBound to hide a column. You can use the code below

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

Similar question on SO

GridView Hide Column by code

edited May 23 '17 at 11:49

Community

1
1

answered Feb 12 '15 at 03:55

शेखर

17,412
13
61
117

I want to do it in page load – Semil Sebastian Feb 12 '15 at 03:56
That's hiding the individual cells, not the entire column, so it's not *exactly* what is being asked for, is it? – Eilon Feb 12 '15 at 03:56
@Eilon row data bound will be called for each row rather than individual cell. – शेखर Feb 12 '15 at 03:59
@Șhȇkhaṝ, it works only if only the RowDataBound triggered. I want to hide the first column when the page is load – Semil Sebastian Feb 12 '15 at 04:03
So why don't you add this event in your grid? – शेखर Feb 12 '15 at 04:08
@SaraJohn by the way why do you want to hide the column? – शेखर Feb 12 '15 at 04:10
@Șhȇkhaṝ yes it will be called once for each row, but my point is that hiding the cells within each row is not the same as hiding the entire column, thought on the surface it might appear to render the same UI. – Eilon Feb 12 '15 at 04:11
@Eilon as I don't see the `second column` there in the grid this might cause the error. – शेखर Feb 12 '15 at 04:13
@Șhȇkhaṝ, It is an ID, I am using this as command argument..But i dont want to display it – Semil Sebastian Feb 12 '15 at 04:13
@SaraJohn I don't see the second column in your grid. You can also use [DataKeyName](http://www.codeproject.com/Articles/23833/DataKeyNames) instead of hiding the column. – शेखर Feb 12 '15 at 04:15

How to hide GridView Coumn[1]?

1 Answers1