display DB connection on site
===

Morning,

Just wondering if anyone knows of a way i can display the status of a DB connection on a page?

I ideally need to know when there is an good connection, or if it is down. Would also be good to show the reason why as well.

I am using ASP.NET and SQL server 2008 R2.

Many thanks.