how to get maximum value from a specific column in database

Question

0.00/5 (No votes)

See more:

i have a table column named myvalues, an asp.net webpage contains one button. i want when user click on button it takes the highest value from that myvalues column and show it on the page. how is it possible.?

Posted 15-Jul-11 22:35pm

saifullahiit

Add a Solution

Comments

Christoph Keller 16-Jul-11 13:47pm

Why you don't look at the answers of your previous posted (same) question here: http://www.codeproject.com/Questions/226395/how-to-get-max-min-values-from-a-specific-col-in-d?

2 solutions

Add a Solution

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

OriginalGriff · Accepted Answer · 2011-07-15T22:48:00

Solution 1

You need an SQL Command similar to:

SELECT MAX(myColumn) FROM myTable

Posted 15-Jul-11 22:48pm

OriginalGriff

Comments

Uday P.Singh 16-Jul-11 3:50am

correct my 5!

Mohd Wasif · Accepted Answer · 2011-07-15T22:51:00

Solution 2

SqlCommand cmd = new SqlCommand("select max(myColumn) as myColumnfrom myTable", con);
        con.Open();
        string  a =Convert.ToString( cmd.ExecuteScalar());
        
            Response.Write(a);

        con.Close();

use it

Posted 15-Jul-11 22:51pm

Mohd Wasif

Updated 15-Jul-11 22:52pm

v2

how to get maximum value from a specific column in database

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

how to get maximum value from a specific column in database

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us