OnDataItemBound event question

[djc]

one of the columns in my datagrid shows a date. I want to display dates <
the current date in red text. I believe I should be using the
OnDataItemBound event for this. Here is the problem I am having. When using
e.Item.Cells(4).Text I am getting the actual text displayed in the cell and
not the value from the database field. For example when this database field
is null the value of e.Item.Cells(4).Text ends up "&nbsp;". This alone is ok
because I can count on it and test for it in my code. My issue gets a little
more sticky because the condition to display the text in red or not is 2
part. Condition to display text in red in pseudo code: (DateColumn < Today
AND StatusColumn = "In Progress"). The StatusColumn is a template column and
so its e.Item.Cells(5).Text winds up with <span> tags and may or may not
also show an <img> tag. So how do I handle this? I need to use the actual
database field values for my comparison... how do I get to them?

any info is greatly appreciated.

 

[Eliyahu Goldin]

The easiest solution is to add a hidden column with original database value
and count on it rather then on it's templated presentation.

Eliyahu

 

[djc]

thanks for the input.

The easiest solution is to add a hidden column with original database value
and count on it rather then on it's templated presentation.

Eliyahu

is

 

[djc]

I think I may have found what I needed... DataItem? e.DataItem("fieldName")?
I'm actually on my way out and won't be able to work on this today... can
anyone confirm that that is how I should access the underlying database data
from the OnDataBound event handler in a datagrid?

thanks again!

 

[djc]

I think I may have found what I needed... DataItem? e.DataItem("fieldName")?
I'm actually on my way out and won't be able to work on this today... can
anyone confirm that that is how I should access the underlying database data
from the OnDataBound event handler in a datagrid?

thanks again!

 

[Eliyahu Goldin]

For a BoundColumn you can use DataField property which gives you the name of
the field. You still need to find the record. The way I suggested is much
simpler. And you don't add anything to the internet traffic since hidden
columns don't render to client.

Eliyahu

 

[djc]

ok. Thanks again!

For a BoundColumn you can use DataField property which gives you the name of
the field. You still need to find the record. The way I suggested is much
simpler. And you don't add anything to the internet traffic since hidden
columns don't render to client.

Eliyahu

is

 

[Maddy]

DataRowView r = (DataRowView) e.Item.DataItem;

I think I may have found what I needed... DataItem? e.DataItem("fieldName")?
I'm actually on my way out and won't be able to work on this today... can
anyone confirm that that is how I should access the underlying database data
from the OnDataBound event handler in a datagrid?

thanks again!

dates

 

[djc]

THANK YOU!

DataRowView r = (DataRowView) e.Item.DataItem;

is