how to hide auto generate columns in datagrid?

[Hanson]

I have a datagrid control in an aspx page. The datagrid columns will be
dynamically generated according to the pre-page's search condition, I want
to hide some columns in the datagrid. is that anyway to do that?

[Cosmin Marin]

Hi,

You could use DataGridColumn' s Visible property.

Cosmin

"Hanson" <he********@hot mail.com> wrote in message
news:un******** *****@TK2MSFTNG P11.phx.gbl...

I have a datagrid control in an aspx page. The datagrid columns will be
dynamically generated according to the pre-page's search condition, I want
to hide some columns in the datagrid. is that anyway to do that?

[Richard]

Set in the datagrid,

AutoGenerateCol umns="false"

<asp:datagrid runat="server" autogeneratecol umns="false">
.....boundcolum ns stuff....
</asp:datagrid>

Autogeneratecol umns, Indicates whether the DataGrid should automatically
generate BoundColumn columns using the data supplied in a data source (the
DataGrid will use all fields in the data source to do so).

[Richard]

Sorry Hanson, i misunderstood the question a bit,
anyway,

use a Visible = False

to make it invisible and not be showed then

"Hanson" <he********@hot mail.com> schreef in bericht
news:un******** *****@TK2MSFTNG P11.phx.gbl...

I have a datagrid control in an aspx page. The datagrid columns will be
dynamically generated according to the pre-page's search condition, I want
to hide some columns in the datagrid. is that anyway to do that?

[Hanson]

Thanks first for your response.

But you might misunderstand my question:

1), The datagrid's column is generated in runtime not in design time, because the columns is depone the pre-page's search condition. only in runtime, when I construct the dataTable, I can know how many columns in the datagrid.
2) I can not access the auto-generated columns (when I debug, it should the datagrid.column s.count=0 ), then I can not set the column's visible value;
Any other help is very appreciated!
"Cosmin Marin" <no****@nospam. ro> wrote in message news:#F******** ******@TK2MSFTN GP12.phx.gbl...
Hi,

You could use DataGridColumn' s Visible property.

Cosmin

"Hanson" <he********@hot mail.com> wrote in message
news:un******** *****@TK2MSFTNG P11.phx.gbl...

I have a datagrid control in an aspx page. The datagrid columns will be
dynamically generated according to the pre-page's search condition, I want
to hide some columns in the datagrid. is that anyway to do that?

[Cosmin Marin]

Hi,

As Richard also suggested (and if my understanding is correct this time): set AutoGenerateCol umns to false and dynamically add your columns based on what you have in the datatable.

Cosmin
"Hanson" <he********@hot mail.com> wrote in message news:O9******** ******@TK2MSFTN GP12.phx.gbl...
Thanks first for your response.

But you might misunderstand my question:

1), The datagrid's column is generated in runtime not in design time, because the columns is depone the pre-page's search condition. only in runtime, when I construct the dataTable, I can know how many columns in the datagrid.
2) I can not access the auto-generated columns (when I debug, it should the datagrid.column s.count=0 ), then I can not set the column's visible value;
Any other help is very appreciated!
"Cosmin Marin" <no****@nospam. ro> wrote in message news:#F******** ******@TK2MSFTN GP12.phx.gbl...
Hi,

You could use DataGridColumn' s Visible property.

Cosmin

"Hanson" <he********@hot mail.com> wrote in message
news:un******** *****@TK2MSFTNG P11.phx.gbl...

I have a datagrid control in an aspx page. The datagrid columns will be
dynamically generated according to the pre-page's search condition, I want
to hide some columns in the datagrid. is that anyway to do that?

[Hanson]

Hi Richard,

Thanks for your reply first. However the problem is I can not access the autogenerated columns, and then I can not set the column's visible property.
"Richard" <ri*****@nospam .com> wrote in message news:40******** *************** @newsreader.ewe ka.nl...
Sorry Hanson, i misunderstood the question a bit,
anyway,

use a Visible = False

to make it invisible and not be showed then

"Hanson" <he********@hot mail.com> schreef in bericht
news:un******** *****@TK2MSFTNG P11.phx.gbl...

I have a datagrid control in an aspx page. The datagrid columns will be
dynamically generated according to the pre-page's search condition, I want
to hide some columns in the datagrid. is that anyway to do that?

[Ryan S]

You could try something like:

Dim dgcol As System.Web.UI.W ebControls.Data GridColumn
For Each dgcol In myDG.Columns
If dgcol.HeaderTex t = "column to hide" Then dgcol.Visible = False
Next

in Page_Load after calling myDG.DataBind() . That will work with explicity
defined columns. I'm not sure if that works with auto-generated columns.

Good luck!

-Ryan

"Hanson" <he********@hot mail.com> wrote in message
news:uV******** ******@TK2MSFTN GP10.phx.gbl...
Hi Richard,

Thanks for your reply first. However the problem is I can not access the
autogenerated columns, and then I can not set the column's visible property.
"Richard" <ri*****@nospam .com> wrote in message
news:40******** *************** @newsreader.ewe ka.nl...
Sorry Hanson, i misunderstood the question a bit,
anyway,

use a Visible = False

to make it invisible and not be showed then

"Hanson" <he********@hot mail.com> schreef in bericht
news:un******** *****@TK2MSFTNG P11.phx.gbl...

I have a datagrid control in an aspx page. The datagrid columns will be
dynamically generated according to the pre-page's search condition, I want
to hide some columns in the datagrid. is that anyway to do that?

[Peter Högström]

Hi,
found this on http://www.datagridgirl.com/faq.aspx

Question: How do I hide a column in my Datagrid if AutoGenerateCol umns
is set to True?

Answer: AutoGenerated columns do not appear in the Datagrid's Columns()
collection, and so the usual method of hiding a Datagrid column will
fail:

'Will NOT work for AutoGenerated columns:
Datagrid1.Colum ns(1).Visible = False

So the place to handle this is in the ItemDataBound event of the
Datagrid:

<asp:DataGrid id="Datagrid1" runat="server" AutoGenerateCol umns="True"
OnItemDataBound ="Datagrid1_OnI temDataBound"/>

Private Sub DataGrid1_ItemD ataBound(s As Object, e As
DatagridItemEve ntArgs)
e.Item.Cells(1) .Visible = False
End Sub

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!