Get max value of each column of a generic table

Question

1.33/5 (2 votes)

See more:

C#

Silverlight

Telerik

How do I get the max value of every columns of a dynamically created RadGridView?
And turn them red when found?

Thanks

Posted 11-Jun-14 3:10am

pierrewhy

Add a Solution

Comments

joshrduncan2012 11-Jun-14 11:40am

What have you tried? Where are you stuck? Can you show us your code, please?

pierrewhy 11-Jun-14 12:00pm

I've been at it for two days.

I get lots of examples from other forums but nothing works.
The simple way would be to look thru every rows of every column and get the max value within that column.
I need to have the max value turn red in every column.

I've tried foreach loop and for iteration.

Since the grids are created dynamic I never know the number of columns or the header's name.

Every coding I had so far has been deleted out of frustation.

Hopefully you can help,

thanks.

pierrewhy 11-Jun-14 12:17pm

I don't even have acces to this simple command.

foreach (DataGridRow row in firstcontrol.RadGridView1.Rows)

It doesn't accept the symbol .Rows

ZurdoDev 11-Jun-14 12:15pm

Not sure if this would be easier but if you can include a column in your sql that flags the max. For each column have another one that is columnname_max and set to 1 or 0.

pierrewhy 11-Jun-14 12:21pm

I'm not using SQL to get the data. It comes from another application that produce a list of table that need to be converted for and I have to an ObservableCollection<ilist> before becoming the itemsource of the grid.

ZurdoDev 11-Jun-14 13:11pm

Perhaps as the rows are databinding store off an array of column names and max values and then in prerender event go back and set the max ones red.

Either way, it doesn't sound like it will be easy. :)

pierrewhy 11-Jun-14 13:16pm

I know it's not easy. I already have to extract the headers form the original table and then the rows for each header.
The output looks good on the RadGridView. I just don't know how to iterate thru that datagrid to get the max value to turn red.
Or to extract any data from any cell.

ZurdoDev 11-Jun-14 13:19pm

I haven't used RadGridView but I would have to believe their site and documentation would have examples of how to iterate over the table rows.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

SRS(The Coder) · Answer 1 · 2014-06-11T18:13:00

Please try this out handling the PreRender event of the RadGrid to format the cell which is largest among all rows of the columns added in array and let me know if this helps for you :-

C#

protected void MyRadGrid_PreRender(object sender, EventArgs e)
{
    string[] columns = { "TaxID", "Tax1", "Tax2", "Tax3" };
    foreach (string colName in columns)
    {
        int i = -1;
        decimal max = decimal.MinValue;
        foreach (GridDataItem dtItem in MyRadGrid.MasterTableView.Items)
        {
            decimal currentNo = decimal.Parse(dataItem[colName].Text);
            if (currentNo > maxNumber)
            {
                max = currentNo;
                i = dtItem.ItemIndex;
            }
        }

        if (i >= 0)
        {
            GridTableCell gtCell = (MyRadGrid.Items[i] as GridDataItem)[colName] as GridTableCell;
            gtCell.BackColor = System.Drawing.Color.Red;
        }
    }
}

Hope this will definitely be of help.