inform app of changes in database content
-
The database is on server(sql server 2000). The application run on the client pc's. How can i update the data in the application when the data on server has been changed.
http://www.codeproject.com/cs/database/DatabaseEventsArticle.asp[^]
enjoy the code with you is my priority, Blaise Braye
-
The database is on server(sql server 2000). The application run on the client pc's. How can i update the data in the application when the data on server has been changed.
Hi Capuano, You have to implement/design a sort of "push - pull" mechanism. You have identify what is changed ( tablesize, tablecontent, indexes .. etc ) and monitor that. Then push out a message to the users saying what has changed, or invoke a method that can update the clients with what ever you want. It not easy to give you a hard and fast anwser because your post lacks the information required to send you down the right path ( if there is such a thing ) Cheers,
-
http://www.codeproject.com/cs/database/DatabaseEventsArticle.asp[^]
enjoy the code with you is my priority, Blaise Braye
-
have a look at also http://www.15seconds.com/issue/041006.htm[^] I couldn't give you the answer to your question because I simply didn't try it. For this kind of applications, I am using transactions
enjoy the code with you is my priority, Blaise Braye
-
The database is on server(sql server 2000). The application run on the client pc's. How can i update the data in the application when the data on server has been changed.