How to hide column in gridview while setting the data source

Question

I have following code to hide column and edit column header. But its not going into foreach. I have tried various method by putting the foreach into DataBound, RowDataBound, RowCreated events. But not working.

GridView1.AutoGenerateColumns = true;
GridView1.DataSource = SomeObject[];
GridView1.DataBind();

foreach (DataControlField col in GridView1.Columns)
{
    if (col.HeaderText == "FirstName") 
    {
        col.HeaderText = "First Name"; 
    }
    if (col.HeaderText == "SchoolName") 
    { 
        col.Visible = false; 
    }
}

Can anyone please advice me the fix. Thanks

No, Don't want to use hardcoded index. as I want to make it future proof. Will break if index changed. — user1211185, Oct 08 '13 at 15:45
How about if you take that solution and add this http://stackoverflow.com/a/9716160/961695? — Yuriy Galanter, Oct 08 '13 at 15:48

score 1 · Answer 1 · answered Oct 08 '13 at 15:46

Note that columnss count would be 0 when you do AutoGenereateColumns = true

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

to set a column invisible using the GridView's RowDataBound event.

On aspx page you can declare in gridview control like this

<asp:GridView runat="server" OnRowDataBound="GridView_RowDataBound" .../>

score 1 · Answer 2 · answered Oct 08 '13 at 15:47

1

Try this instead:

int indexOfSchoolName = -1;
int columnIndex = -1;
foreach(TableCell cell in GridView1.HeaderRow.Cells)
{
    columnIndex ++;
    if (cell.Text == "FirstName") 
    { 
        cell.Text = "First Name"; 
    }
    if(cell.Text == "SchoolName") indexOfSchoolName = columnIndex;
} 
if(indexOfSchoolName != -1)
{
    foreach(GridViewRow row in GridView1.Rows)
    {
        row.Cells[indexOfSchoolName].Visible = false;
    }
}

answered Oct 08 '13 at 15:47

Tim Schmelter

450,073
74
686
939

Thanks Tim, cell.Text is empty string while debugging – user1211185 Oct 08 '13 at 16:11

score 0 · Answer 3 · answered Oct 08 '13 at 15:55

0

Why do you not remove the column from SomeObject[] or clone it and then remove the column?

answered Oct 08 '13 at 15:55

Fabrizio A

3,072
5
24
35

don't want to loose the values – user1211185 Oct 08 '13 at 15:58
At this point, the @Dusht solution seems to be the best. It uses the correct method and clean code. – Fabrizio A Oct 08 '13 at 16:05

score 0 · Answer 4 · answered Oct 08 '13 at 15:58

0

If SomeObject[] is an array then you may have to try to make a copy of SomeObject[] to say CopyObject[] and manipulate this array to exclude the column that you want. Finally rebind it to your grid view.

answered Oct 08 '13 at 15:58

Nisha

1,379
16
28

score 0 · Answer 5 · answered Oct 08 '13 at 15:58

0

I normally do something like this:

private int GetColumnIndexByName(GridView grid, string name)
{
    foreach (DataControlField col in grid.Columns)
    {
        if (col.HeaderText.ToLower().Trim() == name.ToLower().Trim())
        {
            return grid.Columns.IndexOf(col);
        }
    }

    return -1;
}

GridView1.Columns[GetColumnIndexByName(GridView1, "SchoolName")].Visible = false;

answered Oct 08 '13 at 15:58

Bit

1,068
1
11
20

what is the difference than my code? grid.Columns does not have anything here. – user1211185 Oct 08 '13 at 16:05
as noted by @Dusht you nee to move AutoGenereateColumns = true to after the datasource is in place. – Bit Oct 08 '13 at 16:09

How to hide column in gridview while setting the data source

5 Answers5