Change individual DataGridView row colors based on column value

Harvey Saayman

Rate me:

3.76/5 (17 votes)

8 Jan 2010CPOL

168.6K

Below is an example of changing the individual row colors based on one of the DataGridView's columns.While this is not hard to do, the property isn't always where you think it should be, its hidden within the rows DefaultCellStyle property.Here's the example:foreach (DataGridViewRow...

Below is an example of changing the individual row colors based on one of the DataGridView's columns.

While this is not hard to do, the property isn't always where you think it should be, its hidden within the rows DefaultCellStyle property.

Here's the example:

foreach (DataGridViewRow row in mydataGridView.Rows)
{
    string RowType = row.Cells[0].Value.ToString();

    if (RowType == "Type A")
    {
        row.DefaultCellStyle.BackColor = Color.Red;
        row.DefaultCellStyle.ForeColor = Color.White;
    }
    else if (RowType == "Type B")
    {
        row.DefaultCellStyle.BackColor = Color.Yellow;
        row.DefaultCellStyle.ForeColor = Color.Black;
    }
}

A Good thing to do is add this piece of code in a method like UpdateDataGridViewRowColors() and call it every time your DataGridView is bound or rebound to a piece of data.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

Harvey Saayman

Software Developer Osiris Trading

South Africa

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

private void SetDGRowBackground() { string rowValue, pKeyValue = "MyKeyValue".ToLower(); int cellNumber = 0 // set to the cell to validate for (int r = 0; r < this.dgMain.Rows.Count; r++) { rowValue = this.dgMain.Rows[r].Cells[cellNumber].Value.ToString().ToLower(); if (rowValue.Contains(pKeyValue)) { this.dgMain.Rows[r].DefaultCellStyle.BackColor = Color.OrangeRed; } }//for (int r = 0; r < this.dgMain.Rows.Count; r++) }//void SetDGRowBackground()

protected void SetDGRowBackground(int pCellNumber, string pKeyValue, System.Drawing.Color pColor) { string rowValue; for (int r = 0; r < this.dgMain.Rows.Count; r++) { rowValue = this.dgMain.Rows[r].Cells[cellNumber].Value.ToString().ToLower(); if (rowValue.Contains(pKeyValue)) { this.dgMain.Rows[r].DefaultCellStyle.BackColor = pColor; } }//for (int r = 0; r < this.dgMain.Rows.Count; r++) }//void SetDGRowBackground(int pCellNumber, string pKeyValue, System.Drawing.Color pColor)

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Change individual DataGridView row colors based on column value

License

Comments and Discussions