How to extract some value in the result of executing the select command purely?

Question

0.00/5 (No votes)

See more:

Without using dbdatareader, could you please give me a solution to extract some value in the result from executing a select command, for example:

C#

mysqlcommand.CommandText = "Select max(Mark) from MarkSummary";
mysqlcommand.ExecuteNonQuery()

The value I want to extract here is max of the column Mark as I said without using SqlDataReader or IDataReader or even loading the data into a DataTable before extracting from that or even creating a stored function. I want to deal it primitively and purely with Select command.
Thank you so much!

Posted 10-Sep-11 9:28am

King Boy

Updated 10-Sep-11 9:34am

Simon Bang Terkildsen

v2

Add a Solution

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)

Simon Bang Terkildsen · Accepted Answer · 2011-09-10T09:34:00

Solution 1

use ExecuteScalar() e.g.

C#

object max = mysqlcommand.ExecuteScalar()

Posted 10-Sep-11 9:34am

Simon Bang Terkildsen

Comments

[no name] 10-Sep-11 16:04pm

Just a trick but it's exactly what I want.
That ExecuteScalar in fact works in a similiar way that ExecuteReader works, I have learned that ExecuteScalar gets only the value at the first column of the first row while ExecuteReader gets all the result.
I wonder if we have any other ways to solve this?
I voted you with 5s but please wait until I accept your answer. Just for I want more others to get in here and try thinking out some other solution. I don't mean yours is not the best, in fact it is the best, I think, but I like to solve problems in as many ways as possible.
Thank you so much!

Simon Bang Terkildsen 10-Sep-11 16:53pm

That's completely ok, I admire your desire to have multiple solutions to a problem in your tool belt.