conditional grid formatting based on non-visible column

[Keith G Hicks]

I have a gridview (asp.net 2.0) where I'm trying to format rows based on a
NON VISIBLE column. It doesn't seem to work. When column 0 below is visible,
the row is formatted as expected but when it's not, it doesn't do anything.
How can I do this so that the formatting is based on the value of a
non-visible column?

If e.Row.RowType = DataControlRowT ype.DataRow Then
If e.Row.Cells(0). Text = "1" Then
e.Row.Font.Bold = True
e.Row.Font.Ital ic = True
e.Row.ForeColor = Drawing.Color.D arkBlue
e.Row.Cells(1). Text = "  &n bsp;" & e.Row.Cells(1). Text
End If
End If

Thanks,

Keith

[Eliyahu Goldin]

Are you doing this on postback? Non-visible controls don't come back in
postbacks. A good place for non-visible values is DataKeys collection.

--
Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net
"Keith G Hicks" <kr*@comcast.ne twrote in message
news:uk******** ******@TK2MSFTN GP04.phx.gbl...

>I have a gridview (asp.net 2.0) where I'm trying to format rows based on a
NON VISIBLE column. It doesn't seem to work. When column 0 below is
visible,
the row is formatted as expected but when it's not, it doesn't do
anything.
How can I do this so that the formatting is based on the value of a
non-visible column?

If e.Row.RowType = DataControlRowT ype.DataRow Then
If e.Row.Cells(0). Text = "1" Then
e.Row.Font.Bold = True
e.Row.Font.Ital ic = True
e.Row.ForeColor = Drawing.Color.D arkBlue
e.Row.Cells(1). Text = "&nbsp;&nbsp;&n bsp;" & e.Row.Cells(1). Text
End If
End If

Thanks,

Keith

[PopeDarren]

It looks like he's doing it on the RowDataBound. If that's the case,
and the hidden column is the problem, you could wait until the Page's
PreRender event to hide the column.

[PopeDarren]

Hmm.. that worked for me. I tested your scenario. You're right, it
doesn't work when the column is hidden. So I made it visible on the
client side, and hid the column like so on the server side:

Protected Sub Page_PreRender( ByVal sender As Object, ByVal e As
System.EventArg s) Handles Me.PreRender
Me.grd.Columns( 1).Visible = False
End Sub

In this case, the grid was formatted correctly. You have to make sure
the formatting happens before hiding the column. So, if you're
formatting in RowDataBound you can hide the column in PreRender. You
can verify this yourself by putting stops on each of the events.
(Click in the gray to the left of the line number.)

Try it again. Make sure you close your debugger instance before
verifying. I don't know how many times I've been trying to figure
something out and simply closing the browser window and re-opening it
helped.

[Keith G Hicks]

OK. Thanks for the info. I'll test your suggestion. I'm sure it will work
fine.

Keith

<Po********@gma il.comwrote in message
news:e6******** *************** ***********@e39 g2000hsf.google groups.com...

Hmm.. that worked for me. I tested your scenario. You're right, it
doesn't work when the column is hidden. So I made it visible on the
client side, and hid the column like so on the server side:

Protected Sub Page_PreRender( ByVal sender As Object, ByVal e As
System.EventArg s) Handles Me.PreRender
Me.grd.Columns( 1).Visible = False
End Sub

In this case, the grid was formatted correctly. You have to make sure
the formatting happens before hiding the column. So, if you're
formatting in RowDataBound you can hide the column in PreRender. You
can verify this yourself by putting stops on each of the events.
(Click in the gray to the left of the line number.)

Try it again. Make sure you close your debugger instance before
verifying. I don't know how many times I've been trying to figure
something out and simply closing the browser window and re-opening it
helped.