Count number of records/tuples in a database

[weird0]

What is the best way to count the number of records in a MS SQL DB.
The way I do it is executeReader() and loop through all the records in
a db and increment variable RowCount++.

Is there already a function pre-defined for it ?

 

[=?ISO-8859-1?Q?G=F6ran_Andersson?=]

What is the best way to count the number of records in a MS SQL DB.
The way I do it is executeReader() and loop through all the records in
a db and increment variable RowCount++.

Is there already a function pre-defined for it ?

There sure is. Use the count() aggregate in a query:

"select count(*) from SomeTable"

This will return one row that contains the number of records in the table.

 

[Cor Ligthert [MVP]]

Weird,

You can use instead of the executeReader the almost special command for this

Command.ExecuteScalar

http://msdn.microsoft.com/library/d...stemdataidbcommandclassexecutescalartopic.asp

On this page you see direct the sample with the count to fulfil what you
need.

(You can do of course much more with the command)

Cor