GridView Hide Column by code

Question

I want to hide ID column in my GridView  I knew the code   GridView1 Columns 0  Visible   false    but the surprise was that my count property for my GridView columns is 0     while I can see data in the GridView  so any ideas   Thank you   Update   here is the complete code for the method which populate the GridView  public DataSet GetAllPatients         SqlConnection connection   new SqlConnection this ConnectionString        String sql    SELECT  ID   Name   Age   Phone   MedicalHistory   Medication   Diagnoses  FROM  dbo   AwadyClinc PatientTbl order by ID desc        SqlCommand command   new SqlCommand sql  connection        SqlDataAdapter da   new SqlDataAdapter command        DataSet ds   new DataSet         da Fill ds        return ds

User · Answer

If you wanna hide that column while grid populating  you can do it in aspx page itself like this   lt asp BoundField DataField  test  HeaderText  test  Visible  False    gt

User · Answer

This was the code that worked for me when the column Id is unknown and the AutoGenerateColumns    true     lt    Page Language  C     gt   lt    Import Namespace  System Data    gt   lt    Import Namespace  System Drawing    gt   lt html gt   lt head runat  server  gt       lt script runat  server  gt          protected void Page Load object sender  EventArgs eventArgs                        DataTable data   new DataTable                data Columns Add  Id   typeof int                data Columns Add  Notes   typeof string                data Columns Add  RequestedDate   typeof DateTime                for  int idx   0  idx  lt  5  idx                                  DataRow row   data NewRow                    row  Id     idx                  row  Notes     string Format  Note  0    idx                   row  RequestedDate     DateTime Now Subtract new TimeSpan idx  0  0  0  0                    data Rows Add row                             listData DataSource   data              listData DataBind                       private void GridView RowDataBound object sender  GridViewRowEventArgs e                        foreach  TableCell tableCell in e Row Cells                                DataControlFieldCell cell    DataControlFieldCell tableCell                  if  cell ContainingField HeaderText     Id                                         cell Visible   false                      continue                                    if  cell ContainingField HeaderText     Notes                                         cell Width   400                      cell BackColor   Color Blue                      continue                                    if  cell ContainingField HeaderText     RequestedDate                                         cell Width   130                      continue                                                  lt  script gt   lt  head gt   lt body gt       lt form runat  server  gt           lt asp GridView runat  server  ID  listData  AutoGenerateColumns  True  HorizontalAlign  Left              PageSize  20  OnRowDataBound  GridView RowDataBound  EmptyDataText  No Data Available               Width  95   gt           lt  asp GridView gt       lt  form gt   lt  body gt   lt  html gt

User · Answer

private void Registration Load object sender  EventArgs e                                   hiding data grid view coloumn                         datagridview1 AutoGenerateColumns   true                              datagridview1 DataSource  dataSet                              datagridview1 DataMember    users       users is table name                             datagridview1 Columns 0  Visible   false   hiding 1st coloumn coloumn                             datagridview1 Columns 2  Visible   false  hiding 2nd coloumn                             datagridview1 Columns 3  Visible   false  hiding 3rd coloumn                           end of hiding datagrid view coloumns

User · Answer

Please use this code  This make invisible column if empty         protected void gridview1 DataBound object sender  EventArgs e                Boolean hasData   false          for  int col   0  col  lt  gridview1 HeaderRow Cells Count  col                          for  int row   0  row  lt  gridview1 Rows Count  row                                  if   String IsNullOrEmpty gridview1 Rows row  Cells col  Text                       amp  amp   String IsNullOrEmpty HttpUtility HtmlDecode gridview1 Rows row  Cells col  Text  Trim                                           hasData   true                      break                                               if   hasData                                gridview1 HeaderRow Cells col  Visible   false                  for  int hiddenrows   0  hiddenrows  lt  gridview1 Rows Count  hiddenrows                                          gridview1 Rows hiddenrows  Cells col  Visible   false                                               hasData   false

User · Answer

Since you want to hide your column you can always hide the column in preRender event of the gridview   This helps you with reducing one operation for every rowdatabound event per row   You will need only one operation for prerender event    protected void gvVoucherList PreRender object sender  EventArgs e                try                       int RoleID   Convert ToInt32 Session  RoleID                  switch  RoleID                                case 6  gvVoucherList Columns 11  Visible   false                      break                  case 1  gvVoucherList Columns 10  Visible   false                      break                            if hideActionColumn     ActionSM                                 gvVoucherList Columns 10  Visible   false                  hideActionColumn   string Empty                                  catch  Exception Ex

User · Answer

If you want to hide a column by its name instead of its index in GridView  After creating DataTable or Dataset  you have to find the index of the column by its name then save index in global variable like ViewStae  Session and etc and then call it in RowDataBound  like the example   string headerName    Id           DataTable dt                   for  int i 0 i lt dt Columns Count i                          if  dt Columns i  ColumnName    headerName                                ViewState  CellIndex     i                                   GridView RowDataBound object sender  GridViewRowEventArgs e         if  e Row RowType    DataControlRowType Header    e Row RowType    DataControlRowType DataRow    e Row RowType    DataControlRowType Footer                 int index   Convert ToInt32 ViewState  CellIndex              e Row Cells index  Visible   false

User · Answer

What most answers here don t explain is - what if you need to make columns visible again and invisible  all based on data dynamically  After all  shouldn t GridViews be data centric   What if you want to turn ON or OFF columns based on your data   My Gridview   lt asp GridView ID  gvLocationBoard  runat  server  AllowPaging  True  AllowSorting  True  ShowFooter  false  ShowHeader  true  Visible  true  AutoGenerateColumns  false  CellPadding  4  ForeColor   333333  GridLines  None              DataSourceID  sdsLocationBoard  OnDataBound  gvLocationBoard DataBound  OnRowDataBound  gvLocationBoard RowDataBound  PageSize  15  OnPreRender  gvLocationBoard PreRender  gt               lt RowStyle BackColor   F7F6F3  ForeColor   333333    gt               lt Columns gt                   lt asp TemplateField HeaderText  StudentID  SortExpression  StudentID  Visible  False  gt                       lt ItemTemplate gt                           lt asp Label ID  Label2  runat  server  Text   lt    Eval  StudentID     gt   gt  lt  asp Label gt                       lt  ItemTemplate gt                   lt  asp TemplateField gt                   lt asp TemplateField HeaderText  Student  SortExpression  StudentName  gt                       lt ItemTemplate gt                           lt asp Label ID  Label3  runat  server  Text   lt    Eval  StudentName     gt   gt  lt  asp Label gt                       lt  ItemTemplate gt                   lt  asp TemplateField gt                   lt asp TemplateField HeaderText  Status  SortExpression  CheckStatusName  ItemStyle-HorizontalAlign  Center  gt                       lt ItemTemplate gt                           lt asp HiddenField ID  hfStatusID  runat  server  Value   lt    Eval  CheckStatusID     gt     gt                           lt asp Label ID  Label4  runat  server  Text   lt    Eval  CheckStatusName     gt   gt  lt  asp Label gt                       lt  ItemTemplate gt                   lt  asp TemplateField gt                   lt asp TemplateField HeaderText  RollCallPeriod0  Visible  False  gt                       lt ItemTemplate gt                           lt asp CheckBox ID  cbRollCallPeriod0  runat  server    gt                           lt asp HiddenField ID  hfRollCallPeriod0  runat  server  Value   lt    Eval  RollCallPeriod     gt     gt                       lt  ItemTemplate gt                       lt HeaderStyle Font-Size  Small    gt                       lt ItemStyle HorizontalAlign  Center    gt                   lt  asp TemplateField gt                   lt asp TemplateField HeaderText  RollCallPeriod1  Visible  False  gt                       lt ItemTemplate gt                           lt asp CheckBox ID  cbRollCallPeriod1  runat  server    gt                           lt asp HiddenField ID  hfRollCallPeriod1  runat  server  Value   lt    Eval  RollCallPeriod     gt     gt                       lt  ItemTemplate gt                       lt HeaderStyle Font-Size  Small    gt                       lt ItemStyle HorizontalAlign  Center    gt                   lt  asp TemplateField gt             etc     Note the   RollCallPeriodn   where  n  is a sequential number   The way I do it  is to by design hide all columns that I know are going to be ON  visible  true   or OFF  visible  false   later  and depending on my data   In my case I want to display Period Times up to a certain column  So for example  if today is 9am then I want to show periods 6am  7am  8am and 9am  but not 10am  11am  etc   On other days I want to show ALL the times  And so on   So how do we do this   Why not use PreRender to  reset  the Gridview   protected void gvLocationBoard PreRender object sender  EventArgs e        GridView gv    GridView sender      int wsPos   3      for  int wsCol   0  wsCol  lt  19  wsCol                  gv Columns wsCol   wsPos  HeaderText    RollCallPeriod    wsCol ToString   0 00             gv Columns wsCol   wsPos  Visible   false            Now turn ON the columns you need based on finding the Start of the HeaderText and make the column visible if the header text is not the default     protected void gvLocationBoard DataBound object sender  EventArgs e                  Show the headers for the Period Times directly from sdsRollCallPeriods         DataSourceSelectArguments dss   new DataSourceSelectArguments            DataView dv   sdsRollCallPeriods Select dss  as DataView          DataTable dt   dv ToTable   as DataTable          if  dt    null                        int wsPos   0              int wsCol   3     start of PeriodTimes column in gvLocationBoard             foreach  DataRow dr in dt Rows                                gvLocationBoard Columns wsCol   wsPos  HeaderText   dr ItemArray 1  ToString                    gvLocationBoard Columns wsCol   wsPos  Visible    gvLocationBoard Columns wsCol   wsPos  HeaderText StartsWith  RollCallPeriod                     wsPos    1                                  I won t reveal the SqlDataSource here  but suffice to say with the PreRender  I can reset my GridView and turn ON the columns I want with the headers I want   So the way it works is that everytime you select a different date or time periods to display as headers  it resets the GridView to the default header text and Visible  false  status before it builds the gridview again  Otherwise  without the PreRender  the GridView will have the previous data s headers as the code behind wipes the default settings

User · Answer

This helped for me  this myGridview Columns 0  Visible   false    Here 0 is the column index i want to hide

User · Answer

There is a small change to happen  it will not come under rowdatabound  first all the rows should get bound  only then could we hide that  So it will be a separate method after the grid is dataBound

User · Answer

Here i am binding the gridview with dataset like this-  GVAnswer DataSource   DS Tables 0   GVAnswer DataBind      Then after   Then we count the number of rows like this in the for loop  for  int i   0  i  lt  GVAnswer Rows Count  i           Then after we find the header we want make visible false  GVAnswer HeaderRow Cells 2  Visible   false    then after we make the visibility false of that particular cell   The complete code is give like this    public void FillGVAnswer int QuestionID        try                 OBJClsQuestionAnswer   new ClsQuestionAnswer            DS   new DataSet            DS   OBJClsQuestionAnswer GetAnswers QuestionID            GVAnswer DataSource   DS Tables 0           GVAnswer DataBind            if  DS Tables 0  Rows Count  gt  0                           for  int i   0  i  lt  GVAnswer Rows Count  i                                   GVAnswer HeaderRow Cells 2  Visible   false                  GVAnswer HeaderRow Cells 3  Visible   false                  GVAnswer HeaderRow Cells 6  Visible   false                   GVAnswer HeaderRow Cells 8  Visible   false                   GVAnswer HeaderRow Cells 10  Visible   false                   GVAnswer HeaderRow Cells 11  Visible   false                      GVAnswer Rows i  Cells 1  Visible   false                  if  GVAnswer Rows i  Cells 4  Text     T                                         GVAnswer Rows i  Cells 4  Text    Text                                     else                                       GVAnswer Rows i  Cells 4  Text    Image                                     if  GVAnswer Rows i  Cells 5  Text     View Image                                         HtmlAnchor a   new HtmlAnchor                        a HRef      ImageHandler aspx ACT AIMG amp AID     GVAnswer Rows i  Cells 2  Text                      a Attributes Add  rel    lightbox                        a InnerText   GVAnswer Rows i  Cells 5  Text                       GVAnswer Rows i  Cells 5  Controls Add a                                      if  GVAnswer Rows i  Cells 7  Text     Yes                                         j                        ViewState  CheckHasMulAns     j    To Chek How Many answer Of a particulaer Question Is Right                                    GVAnswer Rows i  Cells 8  Visible   false                  GVAnswer Rows i  Cells 3  Visible   false                  GVAnswer Rows i  Cells 10  Visible   false                  GVAnswer Rows i  Cells 6  Visible   false                  GVAnswer Rows i  Cells 11  Visible   false                  GVAnswer Rows i  Cells 2  Visible   false                                     catch  Exception ex                string err   ex Message          if  ex InnerException    null                        err   err        Inner Exception  -     ex InnerException Message                    string addInfo    Error in getting Answers    - gt             ClsExceptionPublisher objPub   new ClsExceptionPublisher            objPub Publish err  addInfo

User · Answer

GridView Columns Count will always be 0 when your GridView has its AutoGenerateColumns property set to true  default is true    You can explicitly declare your columns and set the AutoGenerateColumns property to false  or you can use this in your codebehind   GridView Rows 0  Cells Count   to get the column count once your GridView data has been bound  or this    protected void GridView RowDataBound object sender  GridViewRowEventArgs e        e Row Cells index  Visible   false      to set a column invisible using your GridView s RowDataBound event

User · Answer

Some of the answers I ve seen explain how to make the contents of a cell invisible  but not how to hide the entire column  which is what I wanted to do   If you have AutoGenerateColumns    false  and are actually using BoundField for the column you want to hide  Bala s answer is slick   But if you are using TemplateField for the column  you can handle the DataBound event and do something like this   protected void gridView DataBound object sender  EventArgs e        const int countriesColumnIndex   4       if  someCondition    true                   Hide the Countries column         this gridView Columns countriesColumnIndex  Visible   false            This may not be what the OP was looking for  but it s the solution I was looking for when I found myself asking the same question

User · Answer

You can hide a specific  column by querying the datacontrolfield collection for the desired column header text and setting its visibility to true     DataControlField gridView Columns                 Cast lt DataControlField gt                    Where fld   gt   fld HeaderText     Title                    SingleOrDefault    Visible   false

[c#] GridView Hide Column by code

Examples related to c#

Examples related to asp.net