ASP.net Gridview highlight max values in multiple columns

Question

I have a gridview that shows, for example, a baseball team's statistics. It's a standard sports stats grid - the rows show statistics for each player and the columns show the specific stat for the each player.

Easy enough so far. But what I would then like to do is style (highlight or bold) the Max or Min (the team leader) of each stat column. For example, Player A may only lead in one or two categories, so we cannot style the entire row. If Player A just leads the team in strikeouts, I just want to style the number of strikeouts he had (THAT cell only).

What's the best way to handle this? Make SQL Server do all the work and in effect, rank EVERY stat of each player, effectively doubling the number of columns (e.g. col: AB, col: ABRank). Or do I let the rowdatabound event of the gridview handle this?

If I chose the latter, I think I would get the Max of every statistical category from the datatable before binding (e.g. store them in a local variable) then on rowdatabound, if they match the value, apply the style.

score 2 · Answer 1 · answered Mar 30 '11 at 00:15

2

You already gave the answer to your own question, which is by the way the answer I'd have given you.

Or do I let the rowdatabound event of the gridview handle this?

If I chose the latter, I think I would get the Max of every statistical category from the datatable before binding (e.g. store them in a local variable) then on rowdatabound, if they match the value, apply the style.

answered Mar 30 '11 at 00:15

citronas

19,035
27
96
164

Well since there's so many great minds on Stack I figured someone had a better idea. – IMAbev Mar 30 '11 at 01:58

score 2 · Answer 2 · answered Mar 30 '11 at 00:19

2

There is an option you didn't mention. You could use javascript clientside to do the highlighting. should be rather simple to run over a table am highlight the highest values in a column.

answered Mar 30 '11 at 00:19

Justin808

20,859
46
160
265

Good point Justin. I think I may have a go at that with my new toy jQuery. – IMAbev Mar 30 '11 at 02:01

score 2 · Answer 3 · answered Mar 30 '11 at 01:34

Depending on what you are doing you probably have a certain amount of columns you bind to.

I would use LINQ on your DataSource, before you bind it, for each type you want the max for example:

// create a global variable to hold the data
int _maxHomeRuns = 0;

// Then before you bind the datasource, find out the max of each stat
_maxHomeRuns = baseballStats.Max(i => i.HomeRuns);  // get the max

// Then in your template columns Label control DataBinding method    
if ((int)(Eval("HomeRuns")) == _maxHomeRuns)
{
    // Assign the style you want
    ((Label)(sender)).CssClass = "MaxCellStyle";
}

I wouldn't use the RowDataBinding, do it at the control level's OnDataBinding so you are scoping the checks specifically to a control so you don't have to search for controls on a row.

Makes sense Kelsey - definitely a good option although LINQ isn't in in my vocabulary. — IMAbev, Mar 30 '11 at 01:59

ASP.net Gridview highlight max values in multiple columns

3 Answers3