Compare date field with current date in datagridviwer

Question

I got a field in my datagridiviwer which is called "SCHEDULE" this field receives a date, which comes from the database as varchar or string, I need to compare the date in this field with the current date, if it is greater than the current date the date line datagridiviwer color changes. I did the command below but I am not getting the result I hope, this changing the color of all lines.

follows my code

else if (row.Cells["PROGRAMAÇÃO"].Value.ToString() != Convert.ToString(DateTime.Now))
{
    row.DefaultCellStyle.BackColor = Color.Bisque;
}

Answer 1

I would do something like this:

if (row.Cells["PROGRAMAÇÃO"].Value != null)
{
    DateTime dataProgramacao = DateTime.Parse(row.Cells["PROGRAMAÇÃO"].Value.ToString();
    DateTime dataAtual = DateTime.Now;
    int resultado = DateTime.Compare(dataProgramacao, dataAtual);

    if (resultado < 0)
    //dataProgramacao é menor que a dataAtual
    else if (resultado == 0)
     //datas iguais
    else
    //dataProgramacao é maior que a dataAtual
    //row.DefaultCellStyle.BackColor = Color.Bisque;
}

I believe you answer what you wish.

Answer 2

Convert the cell value to Datetime, and then make the comparison:

else if (DateTime.Parse(row.Cells["PROGRAMAÇÃO"].Value.ToString()) > DateTime.Now)
{
    row.DefaultCellStyle.BackColor = Color.Bisque;
}

obs. If the cell is empty, null, or in an incorrect format, an error will occur in Parse. You may need to deal with this problem.

Edit: Treating possible errors.

if (...)
{ 
    ...
}
else if (row.Cells["PROGRAMAÇÃO"].Value != null)
{
    DateTime programacao; //variavel auxiliar
    if (DateTime.TryParse(row.Cells["PROGRAMAÇÃO"].Value.ToString(), out programacao))
    {
        if (programacao > DateTime.Now)
            row.DefaultCellStyle.BackColor = Color.Bisque;
    }
}