C# - Compare Date Column from DataGrid to Today's Date

[mlowery]

I am new to C# and I am working on a Windows Form. I have a DataGrid that is getting data from an Oracle Database. I am trying to compare the "ExpireDate" column from my database with todays date. All records that are expired (from the ExpireDate column), change that row color.

Example: The code is wrong but I am trying to explain the concept.

if (ExpireDate > TodayDate)
DataGrid.Row.BackGroundColor = Red

I hope someone out there knows what to do. I am sure this is probably very easy, but I don't know what to do. I saw a lot of articles that are getting values through a double click event, but I don't want to do an event.

Thank you for your time in advance.

Mike

[nateraaaa]

You need to utilize the OnItemDataBound event of the DataGrid. In this event you can loop through the rows of your datagrid and compare the cell text of the Expired column to today's date. If this comparison is true change the ForeColor property of the cell text.

Nathan

[mlowery]

Cool, I am still new to C#. Do you mind giving me an example?
Thanks

[nateraaaa]

In the example below the Expiration Date column is the 1st column. This code will changed the backcolor of the Expiration Date cell only.

 
protected void DataGrid1_ItemDataBound(object sender, DataGridItemEventArgs e)
{ 
foreach(TableCell cell in e.Item.Cells)
{
if(e.Item.Cells.GetCellIndex(cell) == 1 && e.Item.DataSetIndex >= 0)
{
if(Convert.ToDateTime(cell.Text) > DateTime.Today)
{
cell.BackColor = System.Drawing.Color.Red;
}
}
}
}
 

Nathan

[Plater]

Does DataGrid have that event? DataGridView does not. (GridView does though, I wish the other objects had it, it's great)

[nateraaaa]

Does DataGrid have that event? DataGridView does not. (GridView does though, I wish the other objects had it, it's great)

You can also use the OnPreRender event as an alernative to set properties for the datagrid before the DataGrid is displayed on the page.

[Plater]

You can also use the OnPreRender event as an alernative to set properties for the datagrid before the DataGrid is displayed on the page.

That too is only related to the GridView object and web-based objects.
The OP said they were on a windows form, so they either are using the DataGrid or the DataGridView object.