Question windows service check db?

CRP

Member
Joined
Oct 30, 2007
Messages
11
Programming Experience
3-5
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

Well-known member
Joined
Jun 3, 2008
Messages
503
Location
Vienna, Austria
Programming Experience
3-5
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
 
Top Bottom