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

armin azarnia

10y2.3k

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....

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

armin azarnia10y ago
No its not for my question. at the real i want make a automatic system following this model that below:(c#.net)

all processes are automatically for ever on the server or on the clients. so, we dont would click on a button or visual control and we dont would see any visual style.why? because it was be hidden.for that any person dont would be can close or disable or stop receive message service. too we can use from message queue component with windows service template in the c#. and i dont want send notification as a mail to any address. i want just show received message on the specific clients...and that refrencess that you described any uses have not for me...
my database is on the "sqlserver management studio"...please more help me
armin azarnia10y ago
No its not for my question. at the real i want make a automatic system following this model that below:(c#.net)

all processes are automatically for ever on the server or on the clients. so, we dont would click on a button or visual control and we dont would see any visual style.why? because it was be hidden.for that any person dont would be can close or disable or stop receive message service. too we can use from message queue component with windows service template in the c#. and i dont want send notification as a mail to any address. i want just show received message on the specific clients...and that refrencess that you described any uses have not for me...
my database is on the "sqlserver management studio"...please more help me
Krishna Rajput Singh10y ago
Hello armin azarnia thnsk for writing below links i hope helpful for u..:)

https://code.msdn.microsoft.com/windowsapps/Notification-Service-A-adf433b7

http://www.intstrings.com/ramivemula/articles/sending-automated-emails-asynchronously-using-a-c-windows-service-in-conjunction-with-database-email-records-part-ii/

http://www.dotnetfunda.com/articles/show/931/how-to-send-mail-automatically-for-every-five-minutes-using-csharp

http://www.codeproject.com/Articles/16335/Simple-Windows-Service-which-sends-auto-Email-aler

http://www.codeproject.com/Tips/704008/Send-Auto-Notification-Using-Windows-Service