How to count rows of Access data table?

[Ajay Parmar]

I have one Access data base connected with my ASP.net site. When I want to fetch data it works fine.

I want to display total number of records of Access data table on my ASP.net page

That mean I have one label name lblTotalCount I want to set it’s Text property with total number of record count in Access Table so how can I do that?

Friends kindly help me.

Ajay

[eclipsed4utoo]

this simple query will return the total number of rows in a table


SELECT COUNT(*) FROM Table1


I haven't used Access in years and I can't remember if is supports the "*" operator.