Trying to hide a datatable column from my datagrid... please help

[jonnylbluejeans]

I've read everywhere to use the following:

objDS.Tables("Results").Columns(0).ColumnMapping = MappingType.Hidden

objDS.AcceptChanges()

dgNotes.DataSource = objDS.Tables("Results")

dgNotes.DataBind()

But, the column still shows? Can anyone shed some light on this?

[S. Justin Gengo]

jonny,

I haven't seen any code like you're using before.

I hide columns by simply setting the column's visibility property.

Here's how I do it when I'm creating the datagrid myself:

<asp:boundcolumn visible="False" datafield="pk_EntryId"></asp:boundcolumn>

And here's how I set it from the codebehind:

DataGrid1.Columns(0).Visible = False

I hope this helps.
--
S. Justin Gengo, MCP
Web Developer

Free code library at:
www.aboutfortunate.com

"Out of chaos comes order."
Nietzche
"jonnylbluejeans" <jo*********@arch.com> wrote in message
news:uE**************@TK2MSFTNGP12.phx.gbl...

I've read everywhere to use the following:

objDS.Tables("Results").Columns(0).ColumnMapping = MappingType.Hidden

objDS.AcceptChanges()

dgNotes.DataSource = objDS.Tables("Results")

dgNotes.DataBind()

But, the column still shows? Can anyone shed some light on this?

[Christopher Frazier]

Perhaps your problem lies within the implementation of the DataGrid -
have you tried using bound columns instead of just databinding to the
default Grid?

-Christopher
http://weblogs.asp.net/CFrazier

jonnylbluejeans wrote:

I've read everywhere to use the following:

[Jerry]

Use the ItemCreated Event to
Private Sub DataGrid1_ItemCreated(ByVal sender As Object, ByVal e As
System.Web.UI.WebControls.DataGridItemEventArgs) Handles
DataGrid1.ItemCreated

Select Case e.Item.ItemType

Case ListItemType.Header,ListItemType.AlternativeItem,L istItemType....

e.Item.Cells(1).Visible = False
End Sub
"jonnylbluejeans" <jo*********@arch.com> wrote in message
news:uE**************@TK2MSFTNGP12.phx.gbl...

I've read everywhere to use the following:

objDS.Tables("Results").Columns(0).ColumnMapping = MappingType.Hidden

objDS.AcceptChanges()

dgNotes.DataSource = objDS.Tables("Results")

dgNotes.DataBind()

But, the column still shows? Can anyone shed some light on this?

[Rick Spiewak]

Thanks for this one! It solved a different problem for me:

If I set a column's Visible property to False (unchecking in the columns
property page), the value read from it is empty. Using this technique makes
the column invisible without causing that side-effect.

Frankly, in the case of my problem, I think it's a bug!! But, whatever it
takes....

"Jerry" <JG******@rogers.com> wrote in message
news:jM*******************@news01.bloor.is.net.cab le.rogers.com...

Use the ItemCreated Event to
Private Sub DataGrid1_ItemCreated(ByVal sender As Object, ByVal e As
System.Web.UI.WebControls.DataGridItemEventArgs) Handles
DataGrid1.ItemCreated

Select Case e.Item.ItemType

Case ListItemType.Header,ListItemType.AlternativeItem,L istItemType....

e.Item.Cells(1).Visible = False
End Sub
"jonnylbluejeans" <jo*********@arch.com> wrote in message
news:uE**************@TK2MSFTNGP12.phx.gbl...

I've read everywhere to use the following:

objDS.Tables("Results").Columns(0).ColumnMapping = MappingType.Hidden

objDS.AcceptChanges()

dgNotes.DataSource = objDS.Tables("Results")

dgNotes.DataBind()

But, the column still shows? Can anyone shed some light on this?