conditionally show hide asp.net Gridview column

Question

This is how I navigate to myPage.aspx ,

<a href='~/myPage.aspx?show=<%#Eval("id")%>' id="showEach" runat="server">Show Each</a>

<a href="~/myPage.aspx?show=all" id="showAll" runat="server">Show All</a>

And I have a gridview in myPage.aspx

<asp:GridView ID="GridView1" runat="server">
<Columns>
<asp:BoundField  HeaderText="ColumnOne"  Visible="true"/>
<asp:BoundField  HeaderText="ColumnTwo"  Visible="true"/>
</Columns>
</asp:GridView>

What I want to do is , if Query String is equal to all(~/myPage.aspx?show=all) , I want to set GridView1's Column2's visible to true , else , set visible to false .
How can I do it ?

it's not depends on `datasource` of my gridview AmitSingh , it's depends on `QueryString` ! — zey, Jul 05 '13 at 04:54
Does this answer your question? [GridView Hide Column by code](https://stackoverflow.com/questions/3819247/gridview-hide-column-by-code) — Michael Freidgeim, Dec 13 '20 at 23:20

Amit Singh · Answer 1 · 2013-07-05T05:07:22.643

11

You can use gridview pre-render method to set this...

protected void GridView_PreRender(object sender, EventArgs e)
    {
        if(Reqest.QueryString["Id"]=="all"&& Reqest.QueryString["Id"]!=null)
         {
           GridViewId.Columns[1].Visible = true;
         }
        else
            GridViewId.Columns[1].Visible = false;
    }

edited Jul 05 '13 at 05:07

answered Jul 05 '13 at 04:59

Amit Singh

8,039
20
29

Is there any way likes > `` – zey Jul 05 '13 at 05:03
you should be using '==' rather than '=' – शेखर Jul 05 '13 at 05:07

score 8 · Accepted Answer · edited Dec 13 '20 at 23:24

you can use gridview column index to hide the particular column

Code could be

 if(Request.QueryString.Get("show")=="all")
    GridView1.Columns[1].Visible=true;
 else
    GridView1.Columns[1].Visible=false;

More detail

GridView Hide Column by code

Edit 3

Settings in ASPX/ASCX can not be done directly.

<%= %> outputs directly to the response stream, and the asp markup is not part of the response stream. Its a mistake to assume the <%= %> operators are performing any kind of preprocessing on the asp markup.

More explanation

Why will <%= %> expressions as property values on a server-controls lead to a compile errors?

Edit 1

I think yes

 <asp:BoundField HeaderText="ColumnTwo" 
      Visible='<% if (Request.QueryString.Get("all") == "all" ) "true" else "false" %>'/>

You will have to check for the syntex

Edit 2

Try this

 Visible='<% Request.QueryString.Get("all") == "all"? "true": "false"%>'

Yes Shekhar , it's said `This expression is not a valid statement` :) — zey, Jul 05 '13 at 05:16

score 1 · Answer 3 · answered Jul 05 '13 at 04:59

1

Dear try to use RowDataBound event of Grid View like

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
    if (e.Row.RowType == DataControlRowType.DataRow)
    {
        //here apply your condition
        if(Request.QueryString["name"] == "all")
        e.Row.Cells[<index_of_cell>].Visible = true;
        else
        e.Row.Cells[<index_of_cell>].Visible = false;
    }
}

Try something like that.

Hope it works for you.

answered Jul 05 '13 at 04:59

Rahul

5,603
6
34
57

Is there any way likes > `` – zey Jul 05 '13 at 05:03
1

the way you want to bind is possible but not in bound field, have to use ItemTemplate check this link http://stackoverflow.com/questions/1839163/aspboundfield-view-the-values-with-a-condition .have to do something like that. – Rahul Jul 05 '13 at 05:12

conditionally show hide asp.net Gridview column

3 Answers3

Edit 3

Settings in ASPX/ASCX can not be done directly.

Edit 1

Edit 2

Linked