How to hide columns in an ASP NET GridView with auto-generated columns

Question

GridView1 Columns Count is always zero even SqlDataSource1 DataBind     But Grid is ok  I can do  for  int i   0  i  lt  GridView1 HeaderRow Cells Count i      I rename request headers here but  GridView1 Columns i  Visible   false    I can t use it because of GridView1 Columns Count is 0   So how can I hide them

User · Accepted Answer

Try putting the e Row Cells 0  Visible   false  inside the RowCreated event of your grid   protected void bla RowCreated object sender  GridViewRowEventArgs e        e Row Cells 0  Visible   false     hides the first column     This way it auto-hides the whole column   You don t have access to the generated columns through grid Columns i  in your gridview s DataBound event

User · Answer

I found Steve Hibbert s response to be very helpful  The problem the OP seemed to be describing is that of an AutoGeneratedColumns on a GridView   In this instance you can set which columns will be  visible  and which will be hidden when you bind a data table in the code behind   For example  A Gridview is on the page as follows    lt asp GridView ID  gv  runat  server  AutoGenerateColumns  False   gt   lt  asp GridView gt    And then in the code behind a PopulateGridView routine is called during the page load event   protected void PopulateGridView         DataTable dt   GetDataSource        gv DataSource   dt      foreach  DataColumn col in dt Columns                BoundField field   new BoundField            field DataField   col ColumnName          field HeaderText   col ColumnName          if  col ColumnName EndsWith  ID                          field Visible   false                    gv Columns Add field             gv DataBind        In the above the GridView AutoGenerateColumns is set to False and the codebehind is used to create the bound fields  One is obtaining the datasource as a datatable through one s own process which here I labeled GetDataSource    Then one loops through the columns collection of the datatable  If the column name meets a given criteria  you can set the bound field visible property accordingly  Then you bind the data to the gridview  This is very similar to AutoGenerateColumns  True  but you get to have criteria for the columns  This approach is most useful when the criteria for hiding and un-hiding is based upon the column name

User · Answer

As said by others  RowDataBound or RowCreated event should work but if you want to avoid events declaration and put the whole code just below DataBind function call  you can do the following   GridView1 DataBind   If GridView1 Rows Count  gt  0 Then     GridView1 HeaderRow Cells 0  Visible   False     For i As Integer   0 To GridView1 Rows Count - 1         GridView1 Rows i  Cells 0  Visible   False     Next End If

User · Answer

In the rowdatabound method for 2nd column  GridView gv    sender as GridView   gv HeaderRow Cells 2  Visible   false  e Row Cells 2  Visible   false

User · Answer

You have to perform the GridView1 Columns i  Visible   false  after the grid has been databound

User · Answer

nCdy  index of cell should be replaced by an integer  corresponding to the index number of the cell that you wish to hide in the  Cells collection   For example  suppose that your GridView presents the following columns   CONTACT NAME     CONTACT NUMBER     CUSTOMERID     ADDRESS LINE 1     POST CODE  And you want the CUSTOMERID column not to be displayed  Since collections indexes are 0-based  your CUSTOMERID column s index is            That s right  2   Very good  Now    guess what you should put in there  to replace  index of cell

User · Answer

I was having the same problem - need my GridView control s AutogenerateColumns to be  true   due to it being bound by a SQL datasource  and thus I needed to hide some columns which must not be displayed in the GridView control   The way to accomplish this is to add some code to your GridView s   RowDataBound  event  such as this  let s assume your GridView s ID is    MyGridView     protected void MyGridView RowDataBound object sender  GridViewRowEventArgs e        if  e Row RowType    DataControlRowType DataRow                e Row Cells  lt index of cell gt   Visible   false            That ll do the trick just fine   -

User · Answer

Try this to hide columns in an ASP NET GridView with auto-generated columns  both RowDataBound RowCreated work too   Protected Sub GridView1 RowDataBound sender As Object  e As GridViewRowEventArgs  Handles GridView1 RowDataBound      If e Row RowType   DataControlRowType DataRow Or           e Row RowType   DataControlRowType Header Then      apply to datarow and header           e Row Cells e Row Cells Count - 1  Visible   False    last column         e Row Cells 0  Visible   False     first column      End If End Sub  Protected Sub GridView1 RowCreated sender As Object  e As GridViewRowEventArgs  Handles GridView1 RowCreated      If e Row RowType   DataControlRowType DataRow Or           e Row RowType   DataControlRowType Header Then          e Row Cells e Row Cells Count - 1  Visible   False         e Row Cells 0  Visible   False      End If End Sub

User · Answer

Note  This solution only works if your GridView columns are known ahead of time   It sounds like you re using a GridView with AutoGenerateColumns true  which is the default  I recommend setting AutoGenerateColumns false and adding the columns manually    lt asp GridView runat  server  ID  MyGridView      AutoGenerateColumns  false  DataSourceID  MySqlDataSource  gt       lt Columns gt           lt asp BoundField DataField  Column1    gt           lt asp BoundField DataField  Column2    gt           lt asp BoundField DataField  Column3    gt       lt  Columns gt   lt  asp GridView gt    And only include a BoundField for each field that you want to be displayed  This will give you the most flexibility in terms of how the data gets displayed

User · Answer

Iterate through the GridView rows and make the cells of your target columns invisible  In this example I want to keeps columns 4-6 visible as is  so we skip those   foreach  GridViewRow row in yourGridView Rows            for  int i   0  i  lt  rows Cells Count  i                   switch  i                       case 4             case 5             case 6                continue                    row Cells i  Visible   false                  Then you will need to remove the column headers separately  keep in mind that removing header cells changes the length of the GridView after each removal    grdReportRole HeaderRow Cells RemoveAt 0

User · Answer

The Columns collection is only populated when AutoGenerateColumns false  and you manually generate the columns yourself   A nice work-around for this is to dynamically populate the Columns collection yourself  before setting the DataSource property and calling DataBind     I have a function that manually adds the columns based on the contents of the DataTable that I want to display   Once I have done that  and then set the DataSource and called DataBind    I can use the Columns collection and the Count value is correct  and I can turn the column visibility on and off as I initially wanted to   static void AddColumnsToGridView GridView gv  DataTable table        foreach  DataColumn column in table Columns                BoundField field   new BoundField            field DataField   column ColumnName          field HeaderText   column ColumnName          gv Columns Add field

User · Answer

Similar to accepted answer but allows use of ColumnNames and binds to RowDataBound     Dictionary lt string  int gt   headerIndiciesForAbcGridView   null   protected void abcGridView RowDataBound object sender  GridViewRowEventArgs e        if   headerIndiciesForAbcGridView    null     builds once per http request               int index   0           headerIndiciesForAbcGridView     Table   GridView sender  Controls 0   Rows 0  Cells              Cast lt TableCell gt                 ToDictionary c   gt  c Text  c   gt  index                e Row Cells  headerIndiciesForAbcGridView  theColumnName    Visible   false      Not sure if it works with RowCreated

[asp.net] How to hide columns in an ASP.NET GridView with auto-generated columns?

Examples related to asp.net

Examples related to gridview