Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 548
  • Last Modified:

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

0
TonyReba
Asked:
TonyReba
2 Solutions
 
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
 
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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 KhaleefaInformation 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
 
Miguel OzSoftware 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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now