how to make auto sql notification using windows service....

Question

hello!

 

i want make a windows service in c# that  do show notification and  inserted record into database table when time a record inserted to my table. for visual showing, i add a message queue to windows service. message queue is a tool for shown sql notifications to user. finally my target is make a automatic system that showing fast of inserted records to database table in the inserted moment.

How Do it?

please answer by C# Code and SQLserver Query if needed.

...

.

.

.

for more known:

so, i have (a windows service and message queue )on the c# or View Side and

(a queue from servicebroker queues in sqlserver and a service from sqlbroker services and a trigger of  mytable triggers)on the sqlserver Database Side....

thankyou and waiting for answers....