Display Total Count of Records in Database Table in ASP.Net Label control

Hi Priyanka,

You can do that by firing below query let say your table name is Employees

SELECT COUNT(*) counts FROM Employees

Get this value by ExecuteScalar and than set this value to appropriate control.

Thanks and Regards,

Rk_Hirpara.