Click here to Skip to main content
12,696,493 members (31,019 online)
Rate this:
Please Sign up or sign in to vote.
See more: C# VB VB.NET

What is service ?

Is it possible to flash a window if a entry is made into a sql table?
Posted 29-Nov-11 19:17pm
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Window service enable you to create long-running executable applications that run in its own Windows session, which then has the ability to start automatically when the computer boots and also can be manually paused, stopped or even restarted.

check this , window service in .NET[^]
Rate this: bad
Please Sign up or sign in to vote.

Solution 2

A Windows Service is not designed to show any UI at all, as it can work when the system is started but no one is logged in, the desktop is not available, and/or when people log in and log out. Optionally, it can be started automatically when a system starts up. Normally, other applications communicate with a Windows Service via IPC (Inter-Process Communication such as named pipes and network.

However, in principle, your problem can be solved. To do it, you should have a Windows Service and one more application, which is an interactive application showing your flash or whatever you need on UI level. This application can connect to the Service and establish a channel (say, TCP session, named pipe) the way the Server can push notifications to this application. You can also use classical remoting or WCF, presumably self-hosted by the Service.

Naturally, all the SQL requests should be redirected through your Windows Service which should relay them to the database server. I think this is feasible but will need considerable effort.


This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170118.1 | Last Updated 30 Nov 2011
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100