retrieving row count from query

[VMI]

How can I execute a "Select" query from C# so that it only returns an
integer with the amount of rows that the actual query is supposed to return?
I don't want the whole result set.

Thanks.

[mphanke]

Hi,

this should do the trick:

"SELECT COUNT(*) FROM my_DB.table;"

This helped me alot:
http://www.w3schools.com/sql/default.asp

Martin
VMI wrote:

How can I execute a "Select" query from C# so that it only returns an
integer with the amount of rows that the actual query is supposed to return?
I don't want the whole result set.

Thanks.

[Richard Blewett [DevelopMentor]]

Remember to execute the query using SqlCommand.ExecuteScalar ro get the result (although in theory you could use the data reader and look the first column of the first row)

Regards

Richard Blewett - DevelopMentor
http://staff.develop.com/richardb/weblog

Hi,

this should do the trick:

"SELECT COUNT(*) FROM my_DB.table;"

This helped me alot:
http://www.w3schools.com/sql/default.asp

Martin
VMI wrote:

[VMI]

Thanks, it worked, in conjunction with ExecuteScalar .
I read that with the data reader you would need to bring the resultset back
to the application.
"mphanke" <mp*****@nospam.nospam> wrote in message
news:uJ**************@TK2MSFTNGP15.phx.gbl...

Hi,

this should do the trick:

"SELECT COUNT(*) FROM my_DB.table;"

This helped me alot:
http://www.w3schools.com/sql/default.asp

Martin
VMI wrote:

How can I execute a "Select" query from C# so that it only returns an
integer with the amount of rows that the actual query is supposed to
return? I don't want the whole result set.

Thanks.

[Jon Skeet [C# MVP]]

VMI <vo******@yahoo.com> wrote:

Thanks, it worked, in conjunction with ExecuteScalar .
I read that with the data reader you would need to bring the resultset back
to the application.

Well, yes and no - you'd bring "the resultset" back, but that resultset
would be just a single row with a single column, because the query
doesn't retrieve the rows, only the count.

--
Jon Skeet - <sk***@pobox.com>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too

[Dean L. Howen]

--> if I want to get both the "resultset" and count affected rows. How can?
I must fetch to the end row and count ? another way?

"Jon Skeet [C# MVP]" <sk***@pobox.com> wrote in message
news:MP************************@msnews.microsoft.c om...

VMI <vo******@yahoo.com> wrote:

Thanks, it worked, in conjunction with ExecuteScalar .
I read that with the data reader you would need to bring the resultset back to the application.

Well, yes and no - you'd bring "the resultset" back, but that resultset
would be just a single row with a single column, because the query
doesn't retrieve the rows, only the count.

--
Jon Skeet - <sk***@pobox.com>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too

[Jon Skeet [C# MVP]]

Dean L. Howen <co*****@hotpop.com> wrote:

--> if I want to get both the "resultset" and count affected rows. How can?
I must fetch to the end row and count ? another way?

No, there basically isn't another way. I asked the same thing in a Java
newsgroup a long time ago, and was shocked by the answer :(

Any time you ask for a number of rows, that information can be out of
date by the time you get the answer back. You could do a query which
returned two resultsets, one containing just the count and one
containing the actual data - but you need to be ready for there to be
more or fewer rows in the actual data than the count suggests...

--
Jon Skeet - <sk***@pobox.com>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too