retrieving number of records in the database to labeltext

[dualshock03]

How can i read the number of records in the database and show it in a label control. just like a sample of "No. of Employees: 25" in some applications. Hope anyone understand my question..

I already used fieldcount using datareader but it only reads the number of column fields in the database. I can't find any row count or something that reads the number of records in a column.

 

[brushman]

google :

sql count

 

[dualshock03]

YEp! tnx it works, just easy i never thought that..