gridview question for databinding

[Guest]

I am trying to set the text color of a cell in a data grid based on the a
value from the data source. I believe i should be doing it in
gridview_RowDataBound, but i do not know how to get to the value in the data
source. I'll try to explain:

column X should be red or green based on the value from szCellColor as
returned from the query used to fill the gridview. However, szCellColor is
NOT a column in the gridview.

Does anyone know how i can access this value from the query bound to the
gridview without the need to make it a hidden colmun?

Any hel pwould be appreciated

 

[Mark Rae]

I am trying to set the text color of a cell in a data grid based on the a
value from the data source. I believe i should be doing it in
gridview_RowDataBound, but i do not know how to get to the value in the
data
source. I'll try to explain:

column X should be red or green based on the value from szCellColor as
returned from the query used to fill the gridview. However, szCellColor is
NOT a column in the gridview.

Does anyone know how i can access this value from the query bound to the
gridview without the need to make it a hidden colmun?

Yup - all you need is to reference the e.Row.DataItem and cast it to a
DataRowView object e.g.

if ((((DataRowView)e.Row.DataItem)["szCellColor"]).ToString() == "red")
{
e.Row.Cells[0].ForeColor = System.Drawing.Color.Red;
}
else
{
e.Row.Cells[0].ForeColor = System.Drawing.Color.Green;
}