Solved

GridView BackColor

Posted on 2014-09-30
4
213 Views
Last Modified: 2014-09-30
I have a gridview that looks like this. There a way I can extend the backcolor of the row so that goes to multiple rows. For example, show the color blue from 1.5 to 3.25 for Dan, the color red from 1.5 to 2.75 for Mike
        Dan     Mike        John
1                                      X
1.5       X      X

2
2.5
2.75             X
3
3.25      X
4
5                             X
 
        protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
        {
                        DataRowView drview = e.Row.DataItem as DataRowView;
                        if (e.Row.RowType == DataControlRowType.DataRow)
                        {
                            if (e.Row.Cells[1].Text == "1")
                            {
                                e.Row.Cells[1].Text = "X";
                                e.Row.Cells[1].BackColor = System.Drawing.Color.Blue;
                            }
                            if (e.Row.Cells[2].Text == "1")
                            {
                                e.Row.Cells[2].Text = "X";
                                e.Row.Cells[2].BackColor = System.Drawing.Color.Red;
                            }
                            if (e.Row.Cells[3].Text == "1")
                            {
                                e.Row.Cells[3].Text = "X";
                                e.Row.Cells[3].BackColor = System.Drawing.Color.Yellow;
                            }
                        }
        }

Open in new window

0
Comment
Question by:RecipeDan
  • 2
  • 2
4 Comments
 
LVL 24

Expert Comment

by:chaau
ID: 40353717
I think the RowDataBound event is not the right place for setting the colours for the continuous rows. You need to set it in a function after you have build the whole grid. The code will be as simple as this:
Color clr[3] = {System.Drawing.Color.Blue, System.Drawing.Color.Red, System.Drawing.Color.Yellow}; // add more colours here
for(int i = 0; i < min(GridView1.Columns.Count, 3); i++)
{
  bool started = false;
  foreach(GridViewRow row in GridView1.Rows)
  {
    if(row.Cells[i].Text == "X")
    {
      if(!started) started = true; else break;
    }
    if(started) row.Cells[i].BackColor = clr[i];
  }
}

Open in new window

0
 
LVL 1

Author Comment

by:RecipeDan
ID: 40353835
I am getting two errors with your code:

bad array declarator
min does not exist in the current context

I fixed the errors and loaded LoadColorsGrid from RowDataBound after everything was done. Should I have loaded it from somewhere else? I attached a screenshot of the results but it is not correct neither. I do not know why one column has two rows colored and the second column only has one and the third has none.
        protected void LoadColorsGrid()
        {
            System.Drawing.Color[] colorList = new System.Drawing.Color[3];             
            colorList[0] = Color.Blue;            
            colorList[1] = Color.Red;            
            colorList[2] = Color.Yellow; 
 
            for(int i = 0; i < 3 ; i++)
            {
              bool started = false;
              foreach(GridViewRow row in GridView1.Rows)
              {
                if(row.Cells[i].Text == "X")
                {
                  if(!started) started = true; else break;
                }
                if(started) row.Cells[i].BackColor = colorList[i];
              }
            }
        }

Open in new window

Screenshot.png
0
 
LVL 24

Accepted Solution

by:
chaau earned 500 total points
ID: 40353845
Thanks for testing. I figured the errors. This code will do the job:
        protected void LoadColorsGrid()
        {
            System.Drawing.Color[] colorList = new System.Drawing.Color[3];             
            colorList[0] = Color.Blue;            
            colorList[1] = Color.Red;            
            colorList[2] = Color.Yellow; 
 
            for(int i = 0; i < 3 ; i++)
            {
              bool started = false;
              foreach(GridViewRow row in GridView1.Rows)
              {
                if(row.Cells[i+1].Text == "X")
                {
                  row.Cells[i+1].BackColor = colorList[i];
                  if(!started) started = true; else break;
                }
                if(started) row.Cells[i+1].BackColor = colorList[i];
              }
            }
        }

Open in new window

0
 
LVL 1

Author Comment

by:RecipeDan
ID: 40353862
It works great. Thank you for your assistance. I spent the last two days trying to figure it out.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
This article is for Object-Oriented Programming (OOP) beginners. An Interface contains declarations of events, indexers, methods and/or properties. Any class which implements the Interface should provide the concrete implementation for each Inter…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question