Im working with a project, simple IM for our office... I have a Table in sql with column Status, if a user opens this application, the status column changes from 0 to 1, if it closes this app, the status turn back to 0. On my form load event, it pulls data from the database where status = 1 (shows logged on users). Here is the situation, if a user opens the app, he will see every logged on users, when someone closes it, he shouled be removed from the lists of logged on users. what i did is to call the form load event again to refresh m lists, but i need somthing to trigger this call. Im thinking of the CDC feature of sql but how will i tell vb.net that there are changes happen to database?
Hope I explained it clear
Thanks in advance