how to change datagridview column backcolor based on another column value

Question

0.00/5 (No votes)

See more:

Hi...am new in using vb and really appreciate your help..i wanted to change a status column backcolor in datagridview based on the rating column in the same datagridview.For example if the rating column="good" then status column backcolor should be green,if rating=satisfactory then status backcolor should be yellow etc. how can i do that in vb 2012?thanks a lot.

Posted 9-Apr-14 22:21pm

Member 10738621

Add a Solution

Comments

Animesh Datta 10-Apr-14 7:31am

check the solution

Member 10738621 10-Apr-14 22:18pm

Hi...thanks so much for your reply below...fyi when i ran the code there is error message ie 'Backcolor' is not a member of 'System.Windows.Forms.DataGridViewCell'.Pls advise...thanks.

1 solution

Add a Solution

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

Animesh Datta · Answer 1 · 2014-04-10T01:31:00

Hello ,
You can use CellEndEdit event to fulfill your requirement . for more details on CellEndEdit follow this Link

C#

private void dgv_CellEndEdit(object sender, DataGridViewCellEventArgs e)
    {
     //now if rating column in 2nd position of datagridview
     if(e.ColumnIndex==1)
       {
          if(dgv.Rows[e.RowIndex].Cells[1].Value=="good") //compare the value
             dgv.Rows[e.RowIndex].Cells[2].BackColor = Color.Green;
          else
             dgv.Rows[e.RowIndex].Cells[2].BackColor = Color.Yellow;

       }
    }

thanks

how to change datagridview column backcolor based on another column value

1 solution

Solution 1

Add your solution here

Preview 0

how to change datagridview column backcolor based on another column value

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us