Change background color of a GridView

Question

0.00/5 (No votes)

See more:

Hi all. I have a GridView that has over 200 rows. I want to change the background color where my Reference number is duplicates. I bind the data to my GridView in my code behind.
How do you do it?

Your help would be appreciated :-)

Posted 27-Jun-11 0:49am

Gericke Hoeksema

Add a Solution

1 solution

Add a Solution

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

Prerak Patel · Answer 1 · 2011-06-27T00:54:00

Solution 1

Change your query to include count of occurrence using group by, if possible.
Then you can directly use RowDataBound event

Copy Code

If (e.Row.DataItem("occurrence") > 1) Then
 e.Row.BackColor = Drawing.Color.Red
End If

Otherwise, you need to loop through rows, and check whether it is duplicate or not and set the BackColor accordingly.

Permalink

Posted 27-Jun-11 0:54am

Prerak Patel

Comments

Gericke Hoeksema 27-Jun-11 7:51am

Thanks I have improved my query with the group by clause aslo by adding count to see all the duplicates, now I have another question.
Is it possible to set for every second duplicate a colour so that I only have 2 different colours seperating them that will still be readable for the user?

Prerak Patel 27-Jun-11 8:05am

For your case, I think second option would have been better, as you don't want to highlight both the rows.

Gericke Hoeksema 27-Jun-11 8:31am

Thats the thing I want to highlight all the rows.
for example some ref. numbers has between 2 and 7 duplicates. I want a chest board effect in my GridView. For the first Ref. number that has for example 2 duplicates must be red, the second Ref. number must with the duplicates must be blue. I hope my explanation is clearly now?

Change background color of a GridView

1 solution

Solution 1

Add your solution here

Preview 0

Change background color of a GridView

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us