Yes there is a way, you can use a SQL Dependency in the windows service.
Although this article :
http://www.codemag.com/article/0605061[
^] has all it's code examples in VB.Net, I did find it an excellent article to introduce this premise.
There are certain requirements that you need to ensure have been set up with regards to SQL and database owners else the service broker might fail, as happened to me recently.
Hope that helps/