return number of rows found

[sde]

what is the best way to return the total number of rows found in a query to SQL2k ?

 

i can connect and query, .. i'm just wondering the most efficient way to see if a user/pass row exists.

[sde]

i guess i should be more specific. right now i'm creating a data adapter.. and filling a dataset. then i use rows.count on the data table in the dataset.

 

that seems like a lot of things to do just to get the number of rows found.

[PlausiblyDamp]

If the DB is SQL you could just return the @@rowcount.

Or alternatively "SELECT COUNT(*) FROM

WHERE

[Volte]

You need to set an alias for the COUNT.

SELECT COUNT(id) AS rowcount FROM mytable WHERE id = 7

Then use 'rowcount' as if it was a regular field.

[sde]

is DataReader object will be the quickest way of reading this field then?

 

thanks for the time.

[Volte]

I would say it most likely is the quickest.

[PlausiblyDamp]

How about Command.ExecuteScalar ?

[Volte]

Ah, I didn't think of that. Indeed that would be the quickest.