Hide a column?

[dew]

How do I hide a column when using AutoGenerateColumns turned on? I tried
dg.Columns(1).visible = false but it errors, as if there is no column.

Also in ItemDataBound, I tried e.items.Cells(1).visible = false and it does
hide that cell, but it doesn't hide the column, so the header of that column
still appears.

This grid has to be auto-generated because there are about 20 queries of
where the datasource is coming from, I don't want to have to make 20 grids
with 20 different queries just to eliminate the id field. Any ideas?

Thanks for your help.

 

[Elton Wang]

In either ItemCreated or ItemDataBound event (without any condition):

e.items.Cells(col_index).Visible = False

will set the whole column invisible.

HTH

 

[mkhmer]

Well, this is my error received by using your suggestion code to hide a
specific column of DataGrid:

===============
BC30456: 'items' is not a member of
'System.Web.UI.WebControls.DataGridItemEventArgs
===============

If you have any idea on that error cause?

Mkhmer