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