How do I display the row count of a particular column in C#.

Question

How do I display the row count of a particular column in C#. The row count  number should get automatically updated when the databse gets updated.