Cell color not changing based on condition..

Mohammad Imran

Below code is not working.not changing color.. data type is datetime..

private void dataGridView1_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)

{

if (e.ColumnIndex == 6)
{

var mydatetime = DateTime.Parse(dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString());

if (mydatetime.Hour > 9 && mydatetime.Minute > 30)
{
e.CellStyle.BackColor = Color.Yellow;

}
}
}

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Midhun Tp9y ago
Accepted answer
Hi,

Please try below code -
var mydatetime = DateTime.Parse(dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString());
TimeSpan start = new TimeSpan(9, 30, 0);//09:30
if (mydatetime.TimeOfDay > start)
{
     e.CellStyle.BackColor = Color.Yellow;
}
+2
Mohammad Imran9y ago
I'm using crystal reports i want to use formula for counting LATE

I have below code but not working... Clockin2 is field where showing Late. there is showing 0.00 late

if {@Clockin2} ="Late" then count({@Clockin2})
0
Midhun Tp9y ago
Hi,

Please check below article -
http://www.c-sharpcorner.com/blogs/import-and-export-data-from-excel-to-database
+1
Mohammad Imran9y ago
Thanks Brother...Midhun T P

Another question.. I have attendance machine, i have fetched monthly attendance in xl sheet now i want to insert all excel sheet data in database existing table.

Column based like if excel sheet have Clock In column then must be insert in database Clock In in existing table.
+1
Manas Mohapatra9y ago
Can you try like this:
private void dataGridView1_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
    string originalCell;
    string reformattedCell;

    if (e.ColumnIndex == 6)
    {
        var mydatetime = DateTime.Parse(dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString());

        if (mydatetime.Hour > 9 && mydatetime.Minute > 30)
        {
            //e.CellStyle.BackColor = Color.Yellow;

            DataGridViewCell cell = this.dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex];
            cell.Style.BackColor = Color.Yellow;
        }
    }
}
+1
Mohammad Imran9y ago
Manas dont understand.. please make this code right because im new
-1
Manas Mohapatra9y ago
Can you follow below URL, it fetch the cell object from e(DataGridViewCellFormattingEventArgs) first and then assign the property(Style.BackColor):

https://stackoverflow.com/questions/25192961/cell-formatting-in-datagridview-on-databindingcomplete
+1