Odtnhj

now just add 90 days with expiry date or subtract 90 days from system date. it will solve my problem! i want that the row color is red when 90 days left to item expiry date

 private void DgvStock_CellFormatting_1(object sender, DataGridViewCellFormattingEventArgs e)
 

 foreach (DataGridViewRow row in DgvStock.Rows)
 

 DateTime exp = Convert.ToDateTime(row.Cells["ExpDate"].Value);

 if (exp <= System.DateTime.Now)
 
 row.DefaultCellStyle.ForeColor = Color.White;
 row.DefaultCellStyle.BackColor = Color.Red;
 
 
 

to add or substract days from current date you can do like this:

var date = DateTime.Now.AddDays(-90);

and change you code like:

if (exp <= System.DateTime.Now)

 row.CellStyle.ForeColor = Color.White;
 row.CellStyle.BackColor = Color.Red;

else

 row.CellStyle.ForeColor = Color.Black;
 row.CellStyle.BackColor = Color.White; // or some other origin color

looks like you using DefaultCellStyle incorrectly. DefaultCellStyle change style for all rows, but you need to change colors for specific row.

How about

if (exp <= System.DateTime.Now.AddDays(-90))
{
 //...

P.S: I would move the DateTime.Now outside the loop and save it into a variable once.

try this:

 foreach (DataGridViewRow row in DgvStock.Rows)
 
 DateTime exp = DateTime.Parse(row.Cells["ExpDate"].Value + "");


 if (exp <= System.DateTime.Today.AddDays(-90))
 
 row.DefaultCellStyle.ForeColor = Color.White;
 row.DefaultCellStyle.BackColor = Color.Red;
 
 else
 

 row.DefaultCellStyle.BackColor = Color.White;