Question windows service check db?

[CRP]

I am adding a new record in my sql server database table. Once a new record is added to my database table i need to create a windows service to check if a new record is added to the table. If it is done, then it should pop-up with a messagebox stating "New Record added".

How to achieve this? I need full coding

Please help

 

[Robert_Zenz]

Hello.

There are some serious problems regarding Windows Services and GUI. F.e. the limitation that a Service shouldn't have a GUI at all, including messageboxes. There are also some issues with timers within Services (check the board for that one).

Maybe you would be better off by using a normal application and a Tray Icon...or no Tray Icon at all. Setting ShowInTaskBar to False and then minimizing the application does it hide, too.

To check if a record was created, you could get the total row count with "SELECT COUNT(*) FROM table", save it and check it every 'now and then' if it has changed.

I need full coding

This isn't Rent/GetACoder...

Bobby