7
Answers

Cell color not changing based on condition..

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;

}
}
}
Answers (7)
0
Manas Mohapatra

Manas Mohapatra

NA 29.3k 3.3m 7y
Did you install correct version of connector which is compatible with your MySQL database. Please install latest version.
 
http://www.itcsolutions.eu/2010/09/09/how-to-connect-to-mysql-database-from-visual-studio-vs2010-problems-with-net-connectors/
 
 
Accepted