Synchronize application and DB

Question

4.00/5 (1 vote)

See more:

Hi Every one.
I have e database in server (SQL SERVER 2005) and a windows application installed in some machines. when i make a particular update in a table i want to notify all users if the application is running on its machine (For example, to show a balloon tool Tip ).
I'm new in programming field and I want to know if it is possible to do that

i don't want to use a timer to check sequentially on db.
thanks.

Posted 8-Dec-11 22:40pm

Valdet Zabeli

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Mehdi Gholam · Answer 1 · 2011-12-08T23:16:00

Solution 1

Notifications are usually done by polling from the client side, or publishing to clients from the server side.

If you don't want to poll from the client then you will have to to publishing from the server.

Publishing can be done by a UDP packet broadcast on the network.

Posted 8-Dec-11 23:16pm

Mehdi Gholam

AlexBanu · Answer 2 · 2011-12-12T04:12:00

You can do this with a trriger and 2 tables.

SQL

CREATE TABLE Event(id INT INDENTITY(0,1), EventTxt VARCHAR(8000))
CREATE TABLE  Viewed (IdUser INT, IdEvent INT, Viewed BIT DEFAULT (0) )
CREATE TRIGGER triger_name
ON   your_table FOR UPDATE AS
 IF
 (
     (UPDATE(your_field))or
 )
 BEGIN
 INSERT INTO Event (EventTxt) VALUES ('Filed was update')
 INSERT INTO
 END

After you do this you will use a watch component to see.
Want new events are in table with this procedure

SQL

PROCEDURE CREATE new_events
@UserId
AS
SELECT e.Id,e.EventTxt FROM 
Event e join Viewed w on e.Id=w.IdEvent WHERE Viewed=0

Now when app show message with event you will
UPDATE Viewed SET Viewed=1 WHERE IdEvent= event id AND IdUser= loged user