Change Cell Color dynamically in a Gridview Loop

I am trying to build a for loop that will go to each row in my gridview and check wheter a row has any of the following criterias, but I am not quite sure how to build the loop since right now I specify the column , please help
protected void GridView3_RowDataBound(object sender, GridViewRowEventArgs e)
    {

        for (Int32 i = 0; i < GridView3.Columns.Count; i++)

        { 

        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            DataRowView row = e.Row.DataItem as DataRowView;


         
            if (row["NT1_Status"].ToString() == "Assigned")
            {
                e.Row.Cells[0].BackColor = System.Drawing.Color.LightGreen;
            }

            else if (row["NT1_Status"].ToString() == "BR")
            {
                e.Row.Cells[0].BackColor = System.Drawing.Color.Azure;
            
            }

            else if (row["NT1_Status"].ToString() == "OpenNS")
            {
                e.Row.Cells[0].BackColor = System.Drawing.Color.LightSalmon;

            }
            }
        }
    }

Open in new window

LVL 9
TonyRebaAsked:
Who is Participating?
 
Miguel OzConnect With a Mentor Software EngineerCommented:
Ok, your issue is that, we need to compare strings, because "Assigned" is part of the string not the string itself.
Thus my previous posted code can be modified to work with your sample data as follows:
[Snippet ID=8036243]
Note: Debug.WriteLine is optional but it will show that you are fetching the correct column names.
protected void GridView3_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            for (int i = 0; i < GridView1.Columns.Count; i++)
            {
                if (string.IsNullOrEmpty(GridView1.Columns[i].HeaderText))
                    continue;
                Debug.WriteLine(String.Format("Col {0}Header text {1}", i, GridView1.Columns[i].HeaderText), "GridView3_RowDataBound");
                string statusValue = (string)DataBinder.Eval(e.Row.DataItem, GridView1.Columns[i].HeaderText);

                if (statusValue.Contains("Assigned"))
                {
                    e.Row.Cells[0].BackColor = System.Drawing.Color.LightGreen;
                }

                else if (statusValue.Contains("BR"))
                {
                    e.Row.Cells[0].BackColor = System.Drawing.Color.Azure;

                }

                else if (statusValue.Contains("OpenNS"))
                {
                    e.Row.Cells[0].BackColor = System.Drawing.Color.LightSalmon;

                }
            }
        }
    }

Open in new window

0
 
Miguel OzSoftware EngineerCommented:
Ok, this event occurs for every row in your grid, thus no need for loop.
I rewrite your code, notice the way i fetch the value:
string statusValue = (string)DataBinder.Eval(e.Row.DataItem, "NT1_Status");

You need to fech any required value that way and cast it to your needs.

Cheers,
Miguel
protected void GridView3_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            string statusValue = (string)DataBinder.Eval(e.Row.DataItem, "NT1_Status"); 

            if (statusValue == "Assigned")
            {
                e.Row.Cells[0].BackColor = System.Drawing.Color.LightGreen;
            }

            else if (statusValue == "BR")
            {
                e.Row.Cells[0].BackColor = System.Drawing.Color.Azure;

            }

            else if (statusValue == "OpenNS")
            {
                e.Row.Cells[0].BackColor = System.Drawing.Color.LightSalmon;

            }
        }
    }

Open in new window

0
 
TonyRebaAuthor Commented:
Well really is not for specific column eg. Nt1. Is any cell in the grid with those statuses.
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
MajorBigDealCommented:
I was having a similar problem and I used the following logic in the page load event instead of the row binding to get around it.

DataTable dt = (DataTable)gridView.DataSource;
int rowIndex = 0;
foreach (GridViewRow gvr in gridView.Rows)
{
gvr.DataItem = dt.Rows[rowIndex++];
DataRow dr = (DataRow)gvr.DataItem;                
object[] oa = dr.ItemArray;
if (oa[7].ToString().Length == 0)
{
gvr.Cells[7].BackColor = System.Drawing.Color.Red;
}
}
0
 
TonyRebaAuthor Commented:
I dont reallly see the logc there,

the function should look for all cells in the grid, but instead of saying
 string statusValue = (string)DataBinder.Eval(e.Row.DataItem, "NT1_Status");

where  "NT1_Status"  is the status field , i want to look for all cells and when the Status field of each column is for example

if (statusValue == "Assigned")
            {
                e.Row.Cells[0].BackColor = System.Drawing.Color.LightGreen;
}

but NT1_Staus is just one of many databound fields which are called e.g. NT2_Status.,,,

sorrry my english is very bas hope i get the idead.
0
 
Miguel OzSoftware EngineerCommented:
GridView3_RowDataBound occurs every time a row is bound to data in a GridView control.
Check:
http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.gridview.rowdatabound.aspx

If you want to look at all the the other values, just repeat the same construct:
string status2Value = (string)DataBinder.Eval(e.Row.DataItem, "NT2_Status");
//do similar code here
etc.
Note: For the column loop, you can even use the column name, instead of hard -coded names ("NT2_Status")

Question: Are you planning to change every cell or just cell[0] based on the contents.
0
 
TonyRebaAuthor Commented:
I am not very familiar with GridView, but

I have a filed on the database for each column status , so the grid looks like


NT1                                        NT2                 NT3
43 Assigned                           65 BR
34                                           11 Assigned
22   BR
11

So on this case 43 and 11 cells  should change color

if (statusValue == "Assigned")
            {
                e.Row.Cells[0].BackColor = System.Drawing.Color.LightGreen;
            }
0
 
Kamal KhaleefaConnect With a Mentor Information Security SpecialistCommented:
private void GridView3_RowDataBound(object sender, System.Web.UI.WebControls.GridViewRowEventArgs e)
{
      if (e.Row.RowType == DataControlRowType.DataRow) {
            DataRowView x = e.Row.DataItem;
            DataTable dt = x.DataView.ToTable();


            dynamic x2 = e.Row.DataItemIndex;


            if (dt.Rows[e.Row.DataItemIndex]["NT1_Status"] == "Assigned") {
                  e.Row.BackColor = System.Drawing.Color.LightGreen;
                  e.Row.Cells[0].BackColor = System.Drawing.Color.LightGreen;
                  e.Row.Cells[1].BackColor = System.Drawing.Color.LightGreen;
                  e.Row.Cells[2].BackColor = System.Drawing.Color.LightGreen;

            } else if (dt.Rows[e.Row.DataItemIndex]["NT1_Status"] == "BR") {
                  e.Row.BackColor = System.Drawing.Color.Azure;
                  e.Row.Cells[0].BackColor = System.Drawing.Color.Azure;
                  e.Row.Cells[1].BackColor = System.Drawing.Color.Azure;
                  e.Row.Cells[2].BackColor = System.Drawing.Color.Azure;

            } else if (dt.Rows[e.Row.DataItemIndex]["NT1_Status"] == "OpenNS") {

                  e.Row.BackColor = System.Drawing.Color.LightSalmon;
                  e.Row.Cells[0].BackColor = System.Drawing.Color.LightSalmon;
                  e.Row.Cells[1].BackColor = System.Drawing.Color.LightSalmon;
                  e.Row.Cells[2].BackColor = System.Drawing.Color.LightSalmon;
            }
      }
}
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.