Live monitoring SQL statements on SQL Server
There's Sql Server Profiler which comes with the installation. It allows you to monitor all SQL statements with various filter criteria. You could also pair it up with PerfMon to investigate performance.

MSDN Sql Server Profiler

I also found this site Receiving Profiler Events. Which allows real-time tracking in .NET.