how to get max & min values from a specific col in database

Question

1.00/5 (2 votes)

See more:

i have a columns in database named highest. i have 2 textboxes(max,min) and 2 button(max, min) in asp.net web page. i want that when i click on max button it takes the highest values from that column in database and show it in max text box. when i click on min button it takes the minimum value to that column and show it in min text box. remember i am using asp.net web page.please tell me the solution.also code if possible

Posted 15-Jul-11 3:50am

saifullahiit

Add a Solution

Comments

R. Giskard Reventlov 15-Jul-11 9:57am

What have you attempted yourself?

[no name] 15-Jul-11 10:06am

have you made any attempt yourself?

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)

#realJSOP · Answer 1 · 2011-07-15T04:13:00

Solution 1

Yeah, that's nice - you're coding an ASP.Net web page. But:

0) Do you want to get this info from the database, or from data you've already retrieved from the database?

1) What language are you using? C#, or VB?

Posted 15-Jul-11 4:13am

#realJSOP

Comments

saifullahiit 15-Jul-11 12:29pm

i want to get this information from database and i am using asp.net with c#

Christoph Keller · Answer 2 · 2011-07-15T05:53:00

Hi,

First, please be more specific in what you actually using (language, DB). Also always state what you already tried by yourself, because codeproject.com is a supporting-platform and not a "others do my work"-platform.

Anyway, here are some starting points for you, how you could get the min / max values out of a SQL DB:

TSQL MAX Command: http://msdn.microsoft.com/en-us/library/ms187751.aspx[^]
TSQL MIN Command: http://msdn.microsoft.com/en-us/library/ms179916.aspx[^]

The SQL Query for getting a max / min value could look like this:

SQL

SELECT MAX(MyColumn1), MIN(MyColumn2)
FROM tbl_MyTable

If you do not know how to access a SQL DB using ASP.NET, you could start with something like this:
Using ADO.NET for beginners[^]

Hope this helps to solve your problem.

Happy coding and have a nice weekend,
Stops