Problem Getting Notification On Changes from the Database

Question

Hi Experts I am new in C#. I've a problem with database notifications.. I've develped a windows application in c# using web services just like little-bit as skype. In which i want to show that who is online/offline/absent/Lunch to all online users using notifyicon in c# i've used the notifyicon but it doesn't show to all users because that information don't come from the database it has been defined statically. so i want to know . how can i implement this. i've searched on google. find some sql dependency query notification requests Push technology.. But i am just confused.. i don't even understand what i need to do for my application.. I need some proper guidline Thanx in Advance.

kedar pawgi · Answer

Just a thought...i want to ask the question is who is going to update the sql query. The user or any internal script. If the user remain ideal for few min then user become ideal means offline as ur using some static variables then change their status after that much of seconds to 0 from 1. and when it changes to zero send notification that this user is offline or show faded icon as we see in Gtalk or Gmail. Another option is if the database is getting update by this then give a window of username and password. When user enter into DB and if any row gets updated from any table then just after completion of inserting query use  commit  once the commit is done then send the message the DB is changed and show that the user is absent or offline or what ever u wanna show. Same way if any once come back from lunch or from offline to online follow the same procedure by checking either with If---else---if or CASE structure. Hope this work for u. Else please give a bit more info about ur query i can give more proper solution to u.