c# change color for a row if its not empty

Question

I have a table an some values on it. If the Row Cell "Name" is not empty change color of background to violet.

Name    ID    Customers

Niky    1     yes       // here change background to violet
        2     no
Donna   3     yes       // here change background to violet
Baka    4     no        // here change background to violet
        5     yes
        6     no

I have tried this code but i doesnt work, dont know why:

 foreach (DataGridViewRow row1 in dataGridView1.Rows)
        {
            if (row1.Cells[0].Value != null)
            {
                row1.DefaultCellStyle.BackColor = Color.Violet;
            }
        }

after dataGridView1.DataSource = result; – Uni Le Sep 27 '12 at 12:40 — Uni Le, Sep 27 '12 at 12:40

score 1 · Accepted Answer · answered Sep 27 '12 at 13:55

The usual place to put this sort if code in within the DataBindingComplete event handler, either attach the event as below or using the designer:

dataGridView1.DataBindingComplete += new DataGridViewBindingCompleteEventHandler(dataGridView1_DataBindingComplete);

Then in the handler you have something like this:

void dataGridView1_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
    foreach (DataGridViewRow row1 in dataGridView1.Rows)
    {
        if (row1.Cells.Cast<DataGridViewCell>().Any(c => c.Value == null || string.IsNullOrWhiteSpace(c.Value.ToString())))
        {
            row1.DefaultCellStyle.BackColor = Color.Violet;
        }
        else
        {
            row1.DefaultCellStyle.BackColor = Color.White;
        }
    }
}

In the code above I've changed your original code to now looks at all cells rather than just the first.

You can also put the code in the CellFormatting event.

BugFinder · Answer 2 · 2012-09-27T13:24:58.233

I dont know where you put your colour code but Ive always done it in the drawing section

Heres oen where I coloured the line depending on a status, except for the first column which was dependant on yellow or blue - this is work in progress code and should be tidied up

  private void dataGridView1_CellPainting(object sender, DataGridViewCellPaintingEventArgs e)
    {
        if (e.RowIndex >= 0 && e.ColumnIndex > 0)
        {
            if (dataGridView1.Rows[e.RowIndex].Cells[].Value.ToString() == "good")
            {
                e.CellStyle.BackColor = Color.PaleGreen;
                    e.CellStyle.SelectionForeColor = Color.Black;
                    e.CellStyle.SelectionBackColor = Color.Wheat;

            }
            if (dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString() == "warning")
            {
                e.CellStyle.BackColor = Color.LightGoldenrodYellow;
                e.CellStyle.SelectionForeColor = Color.Black;
                e.CellStyle.SelectionBackColor = Color.Wheat;
            }
            if (dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString() == "error")
            {
                e.CellStyle.BackColor = Color.Salmon;
                e.CellStyle.SelectionForeColor = Color.Black;
                e.CellStyle.SelectionBackColor = Color.Wheat;
            }

                if (e.Value.ToString() == "Yellow")
                {
                    e.CellStyle.BackColor = Color.Yellow;
                }
                else
                    if (e.Value.ToString() == "Blue")
                    {
                        e.CellStyle.BackColor = Color.LightBlue;
                    }


        }
    }

Or you can do:

foreach(DataGridViewRow r in dataGridView1.Rows) 
{ 
      if(!String.IsNullOrEmpty(r.Cells[0].Value.ToString()))
      { 
           r.DefaultCellStyle.BackColor = Color.Violet; 
      } 
}

so if all the first cell of a line is not empty, colour the row violet.

OK, updated answer as first part still applies, but second half is probably more what you wanted. — BugFinder, Sep 27 '12 at 13:25
i used your second part but all rows in my table are violet now, i just want some rows to be violet, which Column "Name" is not empty — Uni Le, Sep 27 '12 at 13:30
Then it cant be column 0 as that will only do it for those which are empty or null.. whats the query behind the dataset? — BugFinder, Sep 27 '12 at 13:35

Krunal Mevada · Answer 3 · 2012-09-27T14:24:58.783

0

you can do it on the rowdatabound event of the gridview

You can also use this use can go throught it:

foreach(DataGridViewRow r in dataGridView1.Rows)
{
      if(r.Cells.Cast<DataGridViewCell>().Any(c => c.Value.ToString() == string.Empty)) 
      {
           r.DefaultCellStyle.BackColor = Color.Violet;
      }
}

edited Sep 27 '12 at 14:24

answered Sep 27 '12 at 12:20

Krunal Mevada

1,637
1
17
28

1

Yes it does, its defined in the LinQ expression – BugFinder Sep 27 '12 at 13:20
You need to first cast the cell collection: http://stackoverflow.com/questions/2648657/using-datagridviewrowcollection-object-in-linq – David Hall Sep 27 '12 at 13:47
What version of .Net/Visual Studio are you using? – JMK Sep 27 '12 at 14:23

score 0 · Answer 4 · answered Sep 27 '12 at 12:47

A good (but not performant) way for achieving this is the event cell-formatting of the datagridview. You can read the whole documentation in the MSDN. The essence is, that you subscribe to the formatting-event and in this you can do your formatting-issues.

This way you can be sure that the colors etc. are just fine no matter if the user is resizing, scrolling whatever.

Btw: I wouldn't do it in the drawing-event as I learned that usually you will break something of the automated drawing-logic ;)

For further information there is an article about cellstyles in the MSDN which will be in this case overkill. But you can never know enought :)

c# change color for a row if its not empty

4 Answers4

Linked

Related