How to make gridview column visible true or false dynamically?

Question

I am using GridView in asp.net like this:

    mygrid.DataSource = dTable;       
    mygrid.DataBind();

    if (mygrid.Columns.Count > 1)
    {
        mygrid.Columns[2].Visible = false;
    }

my grid view code is as follows

    <asp:GridView ID="mygrid" runat="server" AllowPaging="True" 
       onpageindexchanging="mygrid_PageIndexChanging" PageSize="15" 
       PersistedSelection="true"  
       ondatabound="mygrid_DataBound">
       <Columns>
           <asp:TemplateField>
           <ItemTemplate>
           <asp:HyperLink ID="Edit" runat="server" Text="Edit" NavigateUrl='<%# Eval("Value", "~/myweppage.aspx?Id=M{0}") %>' />
           </ItemTemplate>
           </asp:TemplateField> 
       </Columns>           
       <PagerSettings PageButtonCount="4" />


   </asp:GridView>

Here I am not able to set visible=false.

I tried with the following answer

How do I make several gridview columns invisible dynamically?

I am not finding datarow event in Visual Studio 2010. Can anyone help me to set the column visible property?

my Column structure of data table is

column[0] is Value column then 4 other columns are there.

my Column structure of Grid view is column[0] is link field column1 is Value field from Dtable 4 other columns

if i am not putting inside the if condition then object reference not set error its giving. if i put inside if condition contol is not coming. — Raghuveera, Nov 28 '13 at 07:23
@Bhavesh Kachhadiya if i set AutoGenerateColumns="false" ptoperty then only on colum is visible. columns which are coming from data table are not visible. again same problem column count> 1 condition fails. — Raghuveera, Nov 28 '13 at 08:07
I have edited answer it will work perfect for you.Please see my edited answer. — Bhavesh Kachhadiya, Nov 28 '13 at 08:20

Bhavesh Kachhadiya · Accepted Answer · 2013-11-28T08:23:51.307

This is perfect solution for dynamically generated columns in gridview

Please try this :

int indexOfColumn = 1; //Note : Index will start with 0 so set this value accordingly
protected void mygrid_RowDataBound(object sender, GridViewRowEventArgs e)
{
    if (e.Row.Cells.Count > indexOfColumn)
    {
        e.Row.Cells[indexOfColumn].Visible = false;
    } 
}

For .aspx page edit gridview tag as follow :

 <asp:GridView ID="mygrid" runat="server" AllowPaging="True" 
       onpageindexchanging="mygrid_PageIndexChanging" PageSize="15" 
       PersistedSelection="true"  
       ondatabound="mygrid_DataBound"
       OnRowDataBound="mygrid_RowDataBound">

Indranil.Bharambe · Answer 2 · 2013-11-28T07:38:00.860

3

Here is the simple answer. Create css as below

.classHide{ display:none }

then instead of column.visible = false, just assign classHide CSS class to the column.

e.g.

grdRole.Columns(0).ItemStyle.CssClass = "classHide"
    grdRole.Columns(0).HeaderStyle.CssClass = "classHide"

edited Nov 28 '13 at 07:38

answered Nov 28 '13 at 07:22

Indranil.Bharambe

1,462
3
14
25

that column only not getting to assign.object reference not set error its giving – Raghuveera Nov 28 '13 at 07:26
mygrid.Columns[2].cssClass="classHide" – Indranil.Bharambe Nov 28 '13 at 07:27
Property cssClass not found – Raghuveera Nov 28 '13 at 07:30
1

It's working. This is the best answer really because what if you want to hide a column and yet still have access to the controls in it? In other words, you don't want to remove it entirely from the DOM. If you do and don't care, then .Visible = false is enough – Fandango68 Sep 12 '17 at 01:34
@@Indranil.Bharambe thank u...so much...by using css class....i can easily get the column on client side... – THE LIFE-TIME LEARNER Feb 17 '20 at 05:45

Sai Avinash · Answer 3 · 2013-11-28T07:36:32.020

2

*strong text*Try to make use of the event ItemDataBound event and try the following syntax to hide the column dynamically:

   mygrid.Columns[1].Visible = false           //(Example)

Column count for a datatable starts from 0 not from 1 . so if it is the second column , you want to hide, index should be 1.

Hope this helps..

edited Nov 28 '13 at 07:36

answered Nov 28 '13 at 07:31

Sai Avinash

4,683
17
58
96

@Raghuveera..you can also make use of the event..Pre Render to hide columns – Sai Avinash Nov 28 '13 at 07:33
Giving error like this Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index – Raghuveera Nov 28 '13 at 07:35
@Raghuveera.what is the value of the index , you have given ? – Sai Avinash Nov 28 '13 at 07:36
2 because in data table it is 2nd column. – Raghuveera Nov 28 '13 at 07:37
@Raghuveera..if that does not work..can you please try using Prerender and other thing is are you setting AutogenerateColumns=False or not? – Sai Avinash Nov 28 '13 at 07:38
It should be 1 if its the second column in the database, beacause the column count for the data table starts from 0 not from 1. – Sai Avinash Nov 28 '13 at 07:40
No i got you point. but not working i will give you the coloumn structure wait. – Raghuveera Nov 28 '13 at 07:51
see at the end of my question i specified column indexes – Raghuveera Nov 28 '13 at 08:01

score 2 · Answer 4 · answered Nov 28 '13 at 07:44

right Click on gridview and select Properties then select Events you will find there RowDataBound Double Click on it and in Row data bound write this

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
    e.Row.Cells[0].Visible = false;
}

score 0 · Answer 5 · edited May 31 '18 at 12:19

0

Try this:

for (int i = 0; i < YourGrid.Rows.Count; i++)
{
    (YourGrid.Columns[2]).Visible = false;
}

edited May 31 '18 at 12:19

Robert Columbia

6,313
15
32
40

answered May 31 '18 at 11:51

Pavani Manthena

1
2

While this code may answer the question, it is better to explain how to solve the problem and provide the code as an example or reference. Code-only answers can be confusing and lack context. – Robert Columbia May 31 '18 at 12:19
Thanks @ Robert Columbia – Pavani Manthena Jun 02 '18 at 11:56

How to make gridview column visible true or false dynamically?

5 Answers5