Data grid columns still showing up

[Angel Fernendez]

I am using a run-time connection to populate a datagrid and when I try to
hide my columns it does not work. If I set the column index higher I get an
error.

here is the code

cn.Open();

SqlCommand cmd = new SqlCommand(sSQL,cn);

DataTable dt = new DataTable();

SqlDataAdapter da = new SqlDataAdapter(cmd);

da.Fill(dt);

DataGrid1.DataSource = dt;

DataGrid1.DataBind();

this.DataGrid1.Columns[1].Visible = false;

does anyone have any suggestions?
Please help!!

Thanks!!

 

[source]

According to MSDN, you can only manipulate (specially using the visible
property) only the explicitly declared columns. If you have
'AutoGenerateColumns' = 'True' for your datagrid then you wont be able to
use the Columns collection for the datagrid.
Even I am trying to hide a column which is not explicitly declared.

Anybody who knows how to hide a column which is not explicitly declared let
me know.

 

[Greg Baugher]

I have a column in a datagrid that I don't want displayed, but still need
access to the data. I changed the column width in the DataGridTableStyle.

According to MSDN, you can only manipulate (specially using the visible
property) only the explicitly declared columns. If you have
'AutoGenerateColumns' = 'True' for your datagrid then you wont be able to
use the Columns collection for the datagrid.
Even I am trying to hide a column which is not explicitly declared.

Anybody who knows how to hide a column which is not explicitly declared let
me know.

I am using a run-time connection to populate a datagrid and when I try to
hide my columns it does not work. If I set the column index higher I get an
error.

here is the code

cn.Open();

SqlCommand cmd = new SqlCommand(sSQL,cn);

DataTable dt = new DataTable();

SqlDataAdapter da = new SqlDataAdapter(cmd);

da.Fill(dt);

DataGrid1.DataSource = dt;

DataGrid1.DataBind();

this.DataGrid1.Columns[1].Visible = false;

does anyone have any suggestions?
Please help!!

Thanks!!