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:

<asp:BoundField DataField="Outlook_ID" HeaderText="OutlookID" />

I tried everything to hide the column (property Visible="false"), but I can't access its value.

score 90 · Answer 1 · edited Mar 06 '14 at 13:12

90

<head runat="server">
<title>Accessing GridView Hidden Column value </title>
<style type="text/css">
  .hiddencol
  {
    display: none;
  }
</style>

<asp:BoundField HeaderText="Email ID" DataField="EmailId" ItemStyle-CssClass="hiddencol" HeaderStyle-CssClass="hiddencol" >
</asp:BoundField>

ArrayList EmailList = new ArrayList();
foreach (GridViewRow itemrow in gvEmployeeDetails.Rows)
{
  EmailList.Add(itemrow.Cells[YourIndex].Text);
}

edited Mar 06 '14 at 13:12

Tassisto

9,877
28
100
157

answered May 21 '12 at 06:39

Mubashir Ahmed

1,191
9
4

See http://www.netomatix.com/development/GridViewHideColumn.aspx for an in-depth explanation of this solution. – Marcel Sep 03 '12 at 08:05
3

This solution has the added advantage that the data is still accessible in javascript on client side also. Should be the preferred solution to this problem! – Shaun Keon Nov 11 '16 at 06:16
1

You are a legend! – 3Bady Mar 02 '21 at 21:27

score 45 · Answer 2 · edited Mar 31 '15 at 16:24

45

Define a style in css:

.hiddencol { display: none; }

Then add the ItemStyle-CssClass="hiddencol" and the HeaderStyle-CssClass="hiddencol" attribute to the grid field:

<asp:BoundField DataField="ID" HeaderText="ID" ItemStyle-CssClass="hiddencol"  HeaderStyle-CssClass="hiddencol" ClientIDMode="Static" />

edited Mar 31 '15 at 16:24

SearchForKnowledge

3,663
9
49
122

answered Nov 10 '12 at 18:13

Niloofar

723
8
9

This is a much more effective answer – ImCrimson Apr 17 '17 at 14:53

score 45 · Accepted Answer · edited Jul 03 '17 at 15:24

45

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.

edited Jul 03 '17 at 15:24

answered Mar 21 '11 at 10:31

serhat_pehlivanoglu

982
8
13

8

This hides the column but it doesn't hide the Column header. How will you do that? – Apollo Jul 29 '13 at 16:28
3

Just add in your boundfield. And define a css style like this: .hidden { display:none; } – Philippe Nov 15 '18 at 14:39
Hiding the column header along with the column is a huge part of this. If you do not hide it, all the columns shift out of place. Thanks! – PhillipPDX Aug 17 '23 at 16:31

score 38 · Answer 4 · edited Mar 24 '15 at 15:33

38

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.

edited Mar 24 '15 at 15:33

Marcel

15,039
20
92
150

answered Mar 21 '11 at 10:27

V4Vendetta

37,194
9
78
82

1

DataKeys where meant for that – Antoine Pelletier Nov 01 '16 at 13:09
How would this work if you were using DataSource controls with CRUD code in the HTML...? – Hannington Mambo May 06 '17 at 07:59

score 26 · Answer 5 · edited Mar 06 '14 at 13:13

26

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.

edited Mar 06 '14 at 13:13

prprcupofcoffee

2,950
16
20

answered Nov 11 '11 at 11:16

user496892

276
3
4

2

Not working at all, I get ArrayOutOfBoundsException when I place that code in a Panel PreRender method. – Chexpir Feb 18 '13 at 11:19
2

Worked for me simple and easy. – RustyH May 29 '14 at 20:58
This is by far the best answer. – Talha Imam Sep 16 '20 at 16:07

score 12 · Answer 6 · edited Jul 03 '17 at 13:07

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:

<asp:TemplateField HeaderText="OutlookID">
    <ItemTemplate>
        <asp:Label ID="blah" runat="server">Existing Control</asp:Label>
        <asp:HiddenField ID="HiddenOutlookID" runat="server" Value='<%#Eval("Outlook_ID") %>'/>
    </ItemTemplate>
</asp:TemplateField>

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.

score 9 · Answer 7 · edited Jul 04 '17 at 04:27

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 && gridView.HeaderRow.Cells.Count > 0)
    {
        gridView.HeaderRow.Cells[UserIdColumnIndex].Visible = false;
    }

    foreach (GridViewRow row in gvSearchResults.Rows)
    {
        row.Cells[UserIdColumnIndex].Visible = false;
    }
}

This works. For everyone looking you need to make sure both the header column and the grid view column are hidden. — Danrex, Jun 01 '16 at 03:12

score 3 · Answer 8 · edited Jul 03 '17 at 19:52

3

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

edited Jul 03 '17 at 19:52

answered Oct 11 '11 at 20:40

rube

31
1

score 2 · Answer 9 · edited Jun 26 '21 at 13:25

2

I have a new solution hide the column on client side using css or javascript or jquery.

.col0
{
  display: none !important;
}

And in the aspx file where you add the column you should specify the CSS properties:

<asp:BoundField HeaderText="Address Key" DataField="Address_Id" ItemStyle-CssClass="col0" HeaderStyle-CssClass="col0" > </asp:BoundField>

edited Jun 26 '21 at 13:25

Valeh Mikayilzadeh

813
7
18

answered Feb 16 '15 at 06:13

mukund

21
1

score 2 · Answer 10 · edited Apr 27 '15 at 16:17

2

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.

edited Apr 27 '15 at 16:17

Cristik

30,989
25
91
127

answered Apr 27 '15 at 16:14

Benchmark

21
1

score 1 · Answer 11 · answered Jun 25 '12 at 16:10

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;

score 1 · Answer 12 · answered Jan 27 '23 at 10:55

I found this solution, an elegant(IMO) quick 2 parter.

1. On your gridview, add a column as normal, no need to do anything differently:

<asp:BoundField DataField="AccountHolderName" HeaderText="Account Holder" 
 ReadOnly="true"/>

You can keep the header text if this is useful to you for later processing.

2. In the rowdatabound method for the grid hide the header, footer and row for that column index:

if (e.Row.RowType == DataControlRowType.Header)
{
    e.Row.Cells[10].Visible = false;
}
if (e.Row.RowType == DataControlRowType.Footer)
{
    e.Row.Cells[10].Visible = false;
}
if (e.Row.RowType == DataControlRowType.DataRow)
{                                   
    e.Row.Cells[10].Visible = false;
}

score 0 · Answer 13 · edited Oct 19 '15 at 07:12

0

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!!

edited Oct 19 '15 at 07:12

Anirudh Sharma

7,968
13
40
42

answered Oct 19 '15 at 07:09

Abhisek

1

score 0 · Answer 14 · answered Sep 20 '21 at 17:55

I searched a lot but no luck. The most of them was working with some errors. Finally I used this code and it worked for me. probably you should change 1 to some other value. for me I would hide second col.

protected void FoundedDrGridView_RowDataBound(object sender, GridViewRowEventArgs e) {

    if(e.Row.RowType!=DataControlRowType.Pager)e.Row.Cells[1].Visible = false;
}

score 0 · Answer 15 · answered Jul 08 '22 at 07:17

0

I just set the width to 0. and it works.

columns.AddFor(m => m.Id).Name("hide-id").Width(0);

answered Jul 08 '22 at 07:17

Laoti Sok

1
2

score -1 · Answer 16 · edited Jul 03 '17 at 12:50

-1

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;
}

edited Jul 03 '17 at 12:50

answered Mar 11 '16 at 09:41

Mitr Raiputta

199
1
7

How to hide a column (GridView) but still access its value?

16 Answers16

Linked

Related