How to hide column in data table

Question

I have DataTable which I filled using an SQL Query. Then I filled the GridView with the DataTable.

DataTable table = new DataTable();
table.Load(reader);
gvAktivne.DataSource = table;
gvAktivne.DataBind();

This works fine but now I want to hide the first column. When I add this:

gvAktivne.Columns[0].Visible = false;

I get an IndexOutOfRange exception. Does anybody have an idea how to fix this?

Could you please confirm if your datasource has valid data Rows.Count > 0. — Taimur Khan, Aug 06 '13 at 16:15
Remove column from the DataTable instance before binding it to GridView. — sakura-bloom, Aug 06 '13 at 16:54
Possible duplicate of [GridView Hide Column by code](http://stackoverflow.com/questions/3819247/gridview-hide-column-by-code) — Chains, May 24 '16 at 15:06

score 8 · Answer 1 · answered Jul 08 '15 at 02:07

8

This may work for you:

DataTable data;
data.Columns[0].ColumnMapping = MappingType.Hidden;

answered Jul 08 '15 at 02:07

Linh Vu

130
1
3

score 1 · Answer 2 · answered Aug 06 '13 at 16:14

Based on the problem statement it appears you have AutoGenerateColumns set to true. This is going to be problematic when you want to hide columns. You need to make sure that you issue that line of code after the DataBind() and I would do it in OnPreRender.

protected override void OnPreRender(EventArgs e)
{
    base.OnPreRender(e);
    gvAktivne.Columns[0].Visible = false;
}

score 0 · Answer 3 · edited Apr 19 '16 at 04:47

0

Try this:

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

edited Apr 19 '16 at 04:47

demonplus

5,613
12
49
68

answered Aug 06 '13 at 18:39

bala

36
2

How to hide column in data table

3 Answers3

Linked