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
– zey, Commented Jul 5, 2013 at 4:54
Does this answer your question? GridView Hide Column by code — Michael Freidgeim
– Michael Freidgeim, Commented Dec 13, 2020 at 23:20

Amit Singh · Accepted Answer · 2013-07-05 05:07:22Z

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 5, 2013 at 5:07

answered Jul 5, 2013 at 4:59

Amit Singh

8,12922 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

zey Over a year ago

Is there any way likes > <asp:BoundField HeaderText="ColumnTwo" Visible='if(Request.QueryString[show])==all){....}else{....}'/>

शेखर Over a year ago

you should be using '==' rather than '='

Michael Freidgeim · Accepted Answer · 2020-12-13 23:24:47Z

8

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"%>'

edited Dec 13, 2020 at 23:24

Michael Freidgeim

28.8k17 gold badges164 silver badges181 bronze badges

answered Jul 5, 2013 at 4:58

शेखर

17.6k14 gold badges64 silver badges123 bronze badges

2 Comments

zey Over a year ago

Is there any way likes > <asp:BoundField HeaderText="ColumnTwo" Visible='if(Request.QueryString[show])==all{....}else{....}'/>

zey Over a year ago

Yes Shekhar , it's said This expression is not a valid statement :)

Rahul · Accepted Answer · 2013-07-05 04:59:23Z

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 5, 2013 at 4:59

Rahul

5,6556 gold badges38 silver badges58 bronze badges

2 Comments

zey Over a year ago

Is there any way likes > <asp:BoundField HeaderText="ColumnTwo" Visible='if(Request.QueryString[show])==all{....}else{....}'/>

Rahul Over a year ago

the way you want to bind is possible but not in bound field, have to use ItemTemplate check this link stackoverflow.com/questions/1839163/… .have to do something like that.

Collectives™ on Stack Overflow

conditionally show hide asp.net Gridview column

3 Answers 3

2 Comments

Edit 3

Settings in ASPX/ASCX can not be done directly.

Edit 1

Edit 2

2 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Edit 3

Settings in ASPX/ASCX can not be done directly.

Edit 1

Edit 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related