How to create realtime forms?
-
Hi, I am trying to create an vb app using winforms. I want to always have updated information in the app. So if there are more then one user, and one of users is adding a company, I want the other user to see the company as well after it has been added. Or when one user changes the status of a company I want this update to be send to the other users, if looking at the same data as well. One of the obvious solutions would be to have a timer restrieving the data from the SQL db every couply of seconds, but I guess that will kill a network and there must be more elegant solution, pushing changed data forward. However all the docs I have read until now only talk about a single user and he or she pushing a button to update. Can anybody give me some hints on where to go and some articles to read? Thanks in advance David J Think, try, think, think, try, think, think, think, try, ASK, think, try, advance on step and start over...
-
Hi, I am trying to create an vb app using winforms. I want to always have updated information in the app. So if there are more then one user, and one of users is adding a company, I want the other user to see the company as well after it has been added. Or when one user changes the status of a company I want this update to be send to the other users, if looking at the same data as well. One of the obvious solutions would be to have a timer restrieving the data from the SQL db every couply of seconds, but I guess that will kill a network and there must be more elegant solution, pushing changed data forward. However all the docs I have read until now only talk about a single user and he or she pushing a button to update. Can anybody give me some hints on where to go and some articles to read? Thanks in advance David J Think, try, think, think, try, think, think, think, try, ASK, think, try, advance on step and start over...
Depending on how much data is changed and how much data you have total you could do one of the following: 1. Give each table with data an extra column LastChange of type DateTime. If the column is indexed your clients can regulary ask for newly changed items. 2. Instead of marking ich item just make one field LastChange. Your clients poll this one and (if something changed) get all data. 3. Make some sort of server where your clients must log in. Let the server handle all data access to the db. This way the server gets to know all changes and can send any info he wants to all connected clients. Furthermore the clients wouldnt need to know the data layer - it would all be handled by your server.