Retrieve data from visible false BoundField of Gridview

Question

I have this BoundField in a GridView

<asp:BoundField DataField="ReportId" HeaderText="RId" Visible="false" />

But when I try to get text in that field, it returns empty.

protected void gvwReports_RowCommand(object sender, GridViewCommandEventArgs e)
{
    if (e.CommandName == "ViewSchedule")
    {
        int index = Convert.ToInt32(e.CommandArgument);
        GridViewRow row = gvwReports.Rows[index];
        string s = row.Cells[0].Text;
    }
}

but, it returns a correct value if I change BoundField's .Visible property to true

I'm thinking some optimization is happening behind the scenes and the binding does not actually take place until it becomes visible. — lc., Jul 14 '12 at 18:42
@lc. I just bind data source in normal way. also don't have much experiese of Gridview. — Darshana, Jul 14 '12 at 18:51
The `Visible="false"` doesn't just "hide" that field on the client, it doesn't even send the data down **to** the client. So it is impossible to get it back **from** the client. So instead of setting `Visible="false"`, use a `CssClass` that will hide it from view on the client, but the data will still be there. Then the data will be available again server-side on a postback. Just as COLD TOLD suggests, but without the typo :), and remember to set the visibility of the header. — hmqcnoesy, Jul 14 '12 at 19:09
Does this answer your question? [How to hide a column (GridView) but still access its value?](https://stackoverflow.com/questions/5376278/how-to-hide-a-column-gridview-but-still-access-its-value) — Michael Freidgeim, Dec 14 '20 at 04:03

score 25 · Accepted Answer · edited Oct 16 '18 at 03:48

25

try somethink like this using client side html to hide

<style type="text/css">
     .hidden
     {
         display:none;
     }
</style>

<asp:BoundField DataField="ReportId" HeaderText="RId" HeaderStyle-CssClass="hidden"   >

</asp:BoundField>

edited Oct 16 '18 at 03:48

Community

1
1

answered Jul 14 '12 at 18:52

COLD TOLD

12,989
3
31
49

+1 I didn't read your answer before posting my own. :) I'll remove mine. – hmqcnoesy Jul 14 '12 at 19:00
@hmqcnoesy good, I agreed with you point that when we set visible ='true' the entire row is not sent to the client. – Waqar Janjua Jul 14 '12 at 19:04
4

Usually the header also should be hidden, so we need to add HeaderStyle-CssClass="hidden" to BoundField tag. – Saber Dec 10 '12 at 11:22
Add this also – Bino Kochumol Varghese Jan 18 '16 at 10:04
This only hide header only\ – Bibin Dec 03 '19 at 07:15

score 4 · Answer 2 · edited Jul 14 '13 at 07:13

4

Although it's an year old question (in fact exactly an year old), here's another workaround without using CssClass.

Just after the databind, set visibility of the desired column to false.

gridview1.databind()
gridview1.columns(i).Visibile = False

This will maintain data in viewstate but will not create markup for page.

edited Jul 14 '13 at 07:13

mishik

9,595
9
39
62

answered Jul 14 '13 at 06:54

Prashant Gupta

529
5
19

score 2 · Answer 3 · answered Feb 03 '15 at 11:50

the first solution works correctly, but it was necessary add HeaderStyle to hide the header of this column

<style type="text/css">
     .hidden
     {
         display:none;
     }
</style>

<asp:BoundField DataField="ReportId" HeaderText="RId"  >
    <ItemStyle CssClass="hidden"/>
    <HeaderStyle CssClass="hidden"/>
</asp:BoundField>

score 0 · Answer 4 · answered Jul 14 '12 at 18:58

0

According to my knoweldge when you have made the bound field invisible then you can not access it. Try using TemplateField

answered Jul 14 '12 at 18:58

Waqar Janjua

6,043
2
23
33

score 0 · Answer 5 · answered Sep 20 '12 at 11:24

I just had the same problem.

Funnily enough a DataGrid won't have that problem, it will allow you to access the data from hidden columns even though it doesn't even render them in the client, because it still adds the information of the hidden columns to the ViewState.

A GridView on the other hand simply ignore the hidden fields even if you set the EnableViewState property to true. The only way is to leave the information there for the client to hide with a style property, like display: none;.

Unfortunate really, I liked the DataGrid behaviour on that, but GridView has other advantages.

score 0 · Answer 6 · answered Feb 14 '14 at 16:06

Seems that if a GridView column is marked as not visible it is not populated at run time so it returns nothing. So, I just populated the Hyperlink from the DataView that is bound to the Gridview remembering to declare the DataView as shared.

I did this in VB asp.net for a GridView that finds searched events from a calendar database.

This worked great for me!

Private Sub GridView1_RowDataBound(sender As Object, e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles GridView1.RowDataBound

  If (e.Row.RowType = DataControlRowType.DataRow) Then

    Dim ThisHyperLink As HyperLink = e.Row.Cells(0).Controls(0)
    Dim drvRow As DataRowView = dvFoundEvents.Item(e.Row.DataItemIndex)

    EventID = drvRow("EventID")
    ThisHyperLink.NavigateUrl = "<URL>?id=" + EventID

  End If

End Sub

score 0 · Answer 7 · answered May 15 '14 at 15:55

This worked for me:

If the column is a named DataKeyValue on your grid, you can cast the e.Item sent from the row as a DataGridItem and call its DataKeyValue. You'll need to convert it to Int, String, whatever but it will be there even if the column is visible=false.

score 0 · Answer 8 · answered Jul 15 '14 at 13:39

0

At rowDataBound event you can access the field's value using something like:

(((DataRowView)e.Row.DataItem)["your_boundField_dataFieldName"]).ToString();

even if your boundfield visibility is set to false.

answered Jul 15 '14 at 13:39

Hugo Silva

23
4

Retrieve data from visible false BoundField of Gridview

8 Answers8

Linked