How to hide a column GridView but still access its value

Question

I have a GridView with a DataSource  SQL Database   I want to hide a column  but still be able to access the value when I select the record  Can someone show me how to do this   This is the column I want to hide and still want to access its value    lt asp BoundField DataField  Outlook ID  HeaderText  OutlookID    gt    I tried everything to hide the column  property Visible  false    but I can t access its value

User · Answer

When I want access some value from GridView before GridView was appears    I have a BoundField and bind DataField nomally  In RowDataBound event  I do some process in that event  Before GridView was appears I write this   protected void GridviewLecturer PreRender object sender  EventArgs e         GridviewLecturer Columns 0  Visible   false

User · Answer

I have a new solution hide the column on client side using css or javascript or jquery    col0     display  none      And in the aspx file where you add the column you should specify the CSS properties    lt asp BoundField HeaderText  Address Key  DataField  Address Id  ItemStyle-CssClass  col0  HeaderStyle-CssClass  col0   gt   lt  asp BoundField gt

User · Answer

I used a method similar to user496892   SPBoundField hiddenField   new SPBoundField    hiddenField HeaderText    Header   hiddenField DataField    DataFieldName   grid Columns Add hiddenField    grid DataSource   myDataSource  grid DataBind     hiddenField Visible   false

User · Answer

You can make the column hidden on the server side and for some reason this is different to doing it the aspx code  It can still be referenced as if it was visible  Just add this code to your OnDataBound event   protected void gvSearchResults DataBound object sender  EventArgs e        GridView gridView    GridView sender       if  gridView HeaderRow    null  amp  amp  gridView HeaderRow Cells Count  gt  0                gridView HeaderRow Cells UserIdColumnIndex  Visible   false             foreach  GridViewRow row in gvSearchResults Rows                row Cells UserIdColumnIndex  Visible   false

User · Answer

You can use DataKeys for retrieving the value of such fields  because  as you said  when you set a normal BoundField as visible false you cannot get their value   In the  aspx file set the GridView property  DataKeyNames    Outlook ID    Now  in an event handler you can access the value of this key like so    grid DataKeys rowIndex   Outlook ID     This will give you the id at the specified rowindex of the grid

User · Answer

Leave visible columns before filling the GridView  Fill the GridView and then hide the columns

User · Answer

You can do it programmatically   grid0 Columns 0  Visible   true  grid0 DataSource   dt  grid0 DataBind    grid0 Columns 0  Visible   false    In this way you set the column to visible before databinding  so the column is generated  The you set the column to not visible  so it is not displayed

User · Answer

If you do have a TemplateField inside the columns of your GridView and you have  say  a control named blah bound to it  Then place the outlook id as a HiddenField there like this    lt asp TemplateField HeaderText  OutlookID  gt       lt ItemTemplate gt           lt asp Label ID  blah  runat  server  gt Existing Control lt  asp Label gt           lt asp HiddenField ID  HiddenOutlookID  runat  server  Value   lt   Eval  Outlook ID     gt    gt       lt  ItemTemplate gt   lt  asp TemplateField gt    Now  grab the row in the event you want the outlook id and then access the control  For RowDataBound access it like   string outlookid     HiddenField e Row FindControl  HiddenOutlookID    Value    Do get back  if you have trouble accessing the clicked row  And don t forget to mention the event at which you would like to access that

User · Answer

If I am not mistaken  GridView does not hold the values of BoundColumns that have the attribute visible  false   Two things you may do here  one  as explained in the answer from V4Vendetta  to use Datakeys  Or you can change your BoundColumn to a TemplateField  And in the ItemTemplate  add a control like Label  make its visibility false and give your value to that Label

User · Answer

lt head runat  server  gt   lt title gt Accessing GridView Hidden Column value  lt  title gt   lt style type  text css  gt     hiddencol         display  none       lt  style gt    lt asp BoundField HeaderText  Email ID  DataField  EmailId  ItemStyle-CssClass  hiddencol  HeaderStyle-CssClass  hiddencol   gt   lt  asp BoundField gt   ArrayList EmailList   new ArrayList    foreach  GridViewRow itemrow in gvEmployeeDetails Rows      EmailList Add itemrow Cells YourIndex  Text

User · Answer

You can do it code behind   Set visible  false for columns after data binding   After that you can again do visibility  true  in row selection function from grid view  It will work

User · Answer

Define a style in css    hiddencol   display  none      Then add the ItemStyle-CssClass  hiddencol  and the HeaderStyle-CssClass  hiddencol  attribute to the grid field    lt asp BoundField DataField  ID  HeaderText  ID  ItemStyle-CssClass  hiddencol   HeaderStyle-CssClass  hiddencol  ClientIDMode  Static    gt

User · Answer

Here is how to get the value of a hidden column in a GridView that is set to Visible False  add the data field in this case SpecialInstructions to the DataKeyNames property of the bound GridView   and access it this way    txtSpcInst Text   GridView2 DataKeys GridView2 SelectedIndex  Values  SpecialInstructions     That s it  it works every time very simple

[c#] How to hide a column (GridView) but still access its value?

Examples related to c#

Examples related to asp.net

Examples related to gridview

Examples related to hide