C# Winforms: How to Change the DataGridView Row Color based on Expiry Date

Question

Its not a ASP.net Question hence no RowDataBound Event Works here in this question please answer according to Winforms DataGridView which Event handler to be used to solve this question.

I want to change the row color of DataGridView based on Expiry Date.

If the Expiry date is >= to the value of Expiry Date Column the Row Color change to Red

and If one month left to be Expired then the row color change to Yellow.

Answer 1

@Viorel After trying and researched I finally achieved the desired result

by using RowPrePaint Event and below is the right way:

private void dgv_RowPrePaint(object sender, DataGridViewRowPrePaintEventArgs e)  
        {  
            var ExpiryDate = Convert.ToDateTime(dgv.Rows[e.RowIndex].Cells[7].Value);   
            var TodayDate = DateTime.Today;  
            var Expired = ExpiryDate >= TodayDate;  
            var ExpiredToBe = ExpiryDate >= TodayDate.AddDays(-30);  
            if (Expired)  
            {  
                dgv.Rows[e.RowIndex].DefaultCellStyle.BackColor = Color.LightCoral;  
            }  
            else if (ExpiredToBe)  
            {  
                dgv.Rows[e.RowIndex].DefaultCellStyle.BackColor = Color.Gold;  
            }  
        }  

Answer 2

It seems that you can use the CellFormatting event:

• https://social.msdn.microsoft.com/Forums/windows/en-US/a104c6f9-9169-479b-81b0-f25ebb09a226
• https://learn.microsoft.com/en-us/dotnet/desktop/winforms/controls/how-to-customize-data-formatting-in-the-windows-forms-datagridview-control