Changing color of a Datagridview cell color based on its value

Question

0.00/5 (No votes)

See more:

Hello,

I am trying to Change the Back color of a Cell in a Datagridview if the Column value >39. I am using below code ,

C#

private void dataGridView1_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
        {
            // If the column is the Artist column, check the
            // value.
            if (this.dataGridView1.Columns[e.ColumnIndex].Name == "SensorValue")
            {
                if (e.Value != null)
                {
                    // Check for the string "pink" in the cell.
                    string stringValue = (string)e.Value;
                    stringValue = stringValue.ToLower();
                    if ((stringValue.IndexOf("pink") > 39))
                    {
                        e.CellStyle.BackColor = Color.Pink;
                    }

                }
            }
        }

Its not working. I got no error but color do not change.

Posted 8-Mar-13 0:47am

ontheline89

Add a Solution

4 solutions

Add a Solution

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

AP - gusoo · Accepted Answer · 2013-03-08T02:48:00

Solution 4

sorry it is not "MaLigne" but "line"

Posted 8-Mar-13 2:48am

AP - gusoo

AP - gusoo · Accepted Answer · 2013-03-08T02:26:00

Hi,

try this code :

C#

private void dataGridView1_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
foreach (GridViewRow Line in dataGridView1.Rows)
  {
     if (MaLigne.RowType == DataControlRowType.DataRow)
     {
         if (this.dataGridView1.Columns[e.ColumnIndex].Name == "SensorValue")
         {
          if (Convert.ToInt32(dataGridView1.Rows[Line.RowIndex] > 39)
             {
              dataGridView1.Rows[Line.RowIndex].BackColor = System.Drawing.Color.LightBlue;

             }
          }
     }
  }
}

Menon Santosh · Accepted Answer · 2013-03-08T01:07:00

check this code

C#

private void datagridview_CellValueChanged(object sender, DataGridViewCellEventArgs e)
{
       if (Convert.ToString(datagridview[e.Columnindex,e.RowIndex].value)=="somevalue")
                    datagridview.Rows[e.RowIndex].Cells[e.ColumnIndex].Style.BackColor = Color.Red;


}

itsmehaboob · Accepted Answer · 2013-03-08T00:55:00

Solution 1

change this line(string stringValue = (string)e.Value;)
to
(string stringValue = e.Value.ToString();)

Posted 8-Mar-13 0:55am

itsmehaboob

Changing color of a Datagridview cell color based on its value

4 solutions

Solution 4

Solution 3

Solution 2

Solution 1

Add your solution here

Preview 0

Changing color of a Datagridview cell color based on its value

4 solutions

Solution 4

Solution 3

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us