how to find max value of gridview column data

Question

0.00/5 (No votes)

See more:

hi,

i have the sample gridview data is as follows
which i am adding rows without using a database

id name sal

1 aaa 100

2 bbb 150

3 ccc 200

4 ddd 120

C#

if (e.Row.RowType == DataControlRowType.DataRow)
        {
            int max_cols = Convert.ToInt32(DataBinder.Eval(e.Row.DataItem, "Columns"));

        }

need to write code for getting max value of the column

want to know the maximum value of the column ,i.e in above example the max value of sal 200

thanks inadvance

Posted 12-Nov-11 5:05am

pradeep manne

Updated 15-Nov-11 0:01am

v5

Add a Solution

2 solutions

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)

Sander Rossel · Answer 1 · 2011-11-12T05:20:00

Sorting? Is the GridView bound? In that case you could copy and sort the datasource and get the highest value.
If you wish to get the highest value without sorting the actual grid and you cannot sort a datasource you could for each through the rows, get the value of sal, cast it to an integer and retrieve the highest number.
Using LINQ might also be an option here. That way you do not have to sort, but you can still get the Max value.
In VB (you didn't specify a language) something like:

VB

Dim highestValue = DataGridView1.Rows.OfType(Of DataGridViewRow).Max(Function(row) Convert.ToInt32(row.Cells("sal").Value))

In C# (from the top of my head):

C#

int highestValue = DataGridView1.Rows.OfType<DataGridViewRow>.Max(row => Convert.ToInt32(row.Cells("sal").Value))

This could also be applied directly to the datasource, if your grid is bound.

Not Active · Answer 2 · 2011-11-12T05:19:00

Solution 1

Your grid is bound to a datasource so query it for a Max value, not the grid.

Posted 12-Nov-11 5:19am

Not Active