How to get response from a Database?

Hi, I am trying to findout if a dataBase is up and running. How do I do it in C#? also I need to execute a query to make sure I am getting results.

 
...