How to change row color in datagridview

Question

I would like to change the color of a particular row in my datagridview  The row should be changed to red when the value of columncell 7 is less than the value in columncell 10  Any suggestions on how to accomplish this

User · Answer

With this code  you only change rows backcolor where columname value is null other rows color still the default one          foreach  DataGridViewRow row in dataGridView1 Rows                                        if  row Cells  columnname   Value    null                                                dataGridView1 AlternatingRowsDefaultCellStyle BackColor   Color MistyRose

User · Answer

int counter   gridEstimateSales Rows Count   for  int i   0  i  lt  counter  i          if  i    counter-1                  this is where your LAST LINE code goes           row DefaultCellStyle BackColor   Color Yellow          gridEstimateSales Rows i  DefaultCellStyle BackColor   Color Red            else                 this is your normal code NOT LAST LINE           row DefaultCellStyle BackColor   Color Red          gridEstimateSales Rows i  DefaultCellStyle BackColor   Color White

User · Answer

You need to loop through the rows in the datagridview and then compare values of columns 7 and 10 on each row   Try this   foreach  DataGridViewRow row in vendorsDataGridView Rows        if  Convert ToInt32 row Cells 7  Value   lt  Convert ToInt32 row Cells 10  Value                    row DefaultCellStyle BackColor   Color Red

User · Answer

Works on Visual Studio 2010   I tried it and it works    It will paint your entire row    Create a button for the datagridview  Create a CellClick event and put the next line of code inside of it      if  dataGridView3 Columns e ColumnIndex  Index Equals 0            dataGridView3 Rows e RowIndex  DefaultCellStyle BackColor   Color Beige

User · Answer

I typically Like to use the GridView RowDataBound Event event for this   protected void OrdersGridView RowDataBound object sender  GridViewRowEventArgs e        if  e Row RowType    DataControlRowType DataRow                e Row ForeColor   System Drawing Color Red

User · Answer

Just a note about setting DefaultCellStyle BackColor   you can t set it to any transparent value except Color Empty   That s the default value   That falsely implies  to me  anyway  that transparent colors are OK   They re not   Every row I set to a transparent color just draws the color of selected-rows   I spent entirely too much time beating my head against the wall over this issue

User · Answer

If you are the second dumbest developer on the planet  me being the dumbest   all of the above solutions seem to work  CellFormatting  DataSourceChanged  and RowPrePaint   I prefer RowPrePaint   I struggled with this  for way too long  because I needed to override my SelectionBackColor and SelectionForeColor instead of BackColor and ForeColor as I was changing the selected row

User · Answer

You can Change Backcolor row by row using your condition and this function call after applying Datasource of DatagridView   Here Is the function for that  Simply copy that and put it after Databind  private void ChangeRowColor         for  int i   0  i  lt  gvItem Rows Count  i                  if  BindList i  MainID    0  amp  amp   BindList i  SchemeID HasValue              gvItem Rows i  DefaultCellStyle BackColor   ColorTranslator FromHtml   C9CADD            else if  BindList i  MainID  gt  0  amp  amp   BindList i  SchemeID HasValue              gvItem Rows i  DefaultCellStyle BackColor   ColorTranslator FromHtml   DDC9C9            else if  BindList i  MainID  gt  0              gvItem Rows i  DefaultCellStyle BackColor   ColorTranslator FromHtml   D5E8D7            else             gvItem Rows i  DefaultCellStyle BackColor   Color White

User · Answer

You re looking for the CellFormatting event  Here is an example

User · Answer

This is my solution to change color to dataGridView with bindingDataSource   private void dataGridViewECO DataBindingComplete object sender  DataGridViewBindingCompleteEventArgs e                     if  e ListChangedType    ListChangedType ItemDeleted                 DataGridViewCellStyle green   this dataGridViewECO DefaultCellStyle Clone            green BackColor   Color Green           DataGridViewCellStyle gray   this dataGridViewECO DefaultCellStyle Clone            gray BackColor   Color LightGray             foreach  DataGridViewRow r in this dataGridViewECO Rows                         if  r Cells 8  Value    null                                 String stato   r Cells 8  Value ToString                      if     Open   Equals stato                                         r DefaultCellStyle   gray                                    else                                       r DefaultCellStyle   green

User · Answer

I was just investigating this issue  so I know this question was published almost 3 years ago  but maybe it will help someone       but it seems that a better option is to place the code inside the RowPrePaint event so that you don t have to traverse every row  only those that get painted  so it will perform much better on large amount of data   Attach to the event   this dataGridView1 RowPrePaint         new System Windows Forms DataGridViewRowPrePaintEventHandler          this dataGridView1 RowPrePaint     The event code  private void dataGridView1 RowPrePaint object sender  DataGridViewRowPrePaintEventArgs e        if  Convert ToInt32 dataGridView1 Rows e RowIndex  Cells 7  Text   lt  Convert ToInt32 dataGridView1 Rows e RowIndex  Cells 10  Text                  dataGridView1 Rows e RowIndex  DefaultCellStyle BackColor   Color Beige

User · Answer

If you bind to a  collection  of concrete objects  you can get the that concrete object via the DataBoundItem property of the row    To avoid check for magic strings in the cell and using  real  properties of the object   Skeleton example below   DTO POCO  public class Employee       public int EmployeeKey  get set        public string LastName  get set        public string FirstName  get set        public bool IsActive  get set              Binding to the datagridview      private void BindData ICollection lt Employee gt  emps                System ComponentModel BindingList lt Employee gt  bindList   new System ComponentModel BindingList lt Employee gt  emps OrderBy emp   gt  emp LastName  ThenBy emp   gt  emp FirstName  ToList             this dgvMyDataGridView DataSource   bindList                 then the event handler and getting the concrete object  instead of a DataGridRow and or cells           private void dgvMyDataGridView RowPrePaint object sender  DataGridViewRowPrePaintEventArgs e                        Employee concreteSelectedRowItem   this dgvMyDataGridView Rows e RowIndex  DataBoundItem as Employee              if  null    concreteSelectedRowItem  amp  amp   concreteSelectedRowItem IsActive                                dgvMyDataGridView Rows e RowIndex  DefaultCellStyle BackColor   Color LightGray

User · Answer

private void dtGrdVwRFIDTags DataSourceChanged object sender  EventArgs e        dtGrdVwRFIDTags Refresh        this dtGrdVwRFIDTags Columns 1  Visible   false       foreach  DataGridViewRow row in this dtGrdVwRFIDTags Rows                if  row Cells  TagStatus   Value    null               amp  amp  row Cells  TagStatus   Value ToString       Lost                  row Cells  TagStatus   Value    null               amp  amp  row Cells  TagStatus   Value ToString       Damaged                  row Cells  TagStatus   Value    null               amp  amp  row Cells  TagStatus   Value ToString       Discarded                         row DefaultCellStyle BackColor   Color LightGray              row DefaultCellStyle Font   new Font  Tahoma   8  FontStyle Bold                     else                       row DefaultCellStyle BackColor   Color Ivory                           for  int i  0   i lt dtGrdVwRFIDTags Rows Count - 1  i                      if  dtGrdVwRFIDTags Rows i  Cells 3  Value ToString       Damaged                             dtGrdVwRFIDTags Rows i  Cells  TagStatus   Style BackColor   Color Red

User · Answer

Something like the following    assuming the values in the cells are Integers    foreach  DataGridViewRow dgvr in myDGV Rows      if  dgvr Cells 7  Value  lt  dgvr Cells 10  Value          dgvr DefaultCellStyle ForeColor   Color Red          untested  so apologies for any error   If you know the particular row  you can skip the iteration   if  myDGV Rows theRowIndex  Cells 7  Value  lt  myDGV Rows theRowIndex  Cells 10  Value      dgvr DefaultCellStyle ForeColor   Color Red

User · Answer

I had trouble changing the text color as well - I never saw the color change   Until I added the code to change the text color to the event DataBindingsComplete for DataGridView  After that it worked    I hope this will help people who face the same problem

User · Answer

You have not mentioned how value is changed  I have used similar functionality when user is entering value  i e  entering and leaving edit mode   Using CellEndEdit event of datagridview   private void dgMapTable CellEndEdit object sender  DataGridViewCellEventArgs e        double newInteger       if  double TryParse dgMapTable e ColumnIndex e RowIndex  Value ToString    out newInteger                if  newInteger  lt  0    newInteger  gt  50                        dgMapTable e ColumnIndex  e RowIndex  Style BackColor   Color Red                dgMapTable e ColumnIndex  e RowIndex  ErrorText                     Keep value in Range      0 to      50                                                      You may add logic for clearing error notification in a similar way   if in your case  if data is loaded programmatically  then CellLeave event can be used with same code

User · Answer

I landed here looking for a solution for the case where I dont use data binding   Nothing worked for me but I got it in the end with   dataGridView Columns Clear     dataGridView Rows Clear    dataGridView Refresh

User · Answer

Some people like to use the Paint  CellPainting or CellFormatting events  but note that changing a style in these events causes recursive calls   If you use DataBindingComplete it will execute only once   The argument for CellFormatting is that it is called only on visible cells  so you don t have to format non-visible cells  but you format them multiple times

[c#] How to change row color in datagridview?

Examples related to c#

Examples related to winforms

Examples related to datagridview

Examples related to background-color