By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,387 Members | 1,729 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,387 IT Pros & Developers. It's quick & easy.

notification of changes between apps on different pc's on the network

P: n/a
I will be developping a planning application for wich it's necessary for
multiple users to view and edit the same data, all changes made by one user,
must be visible to the other user's more or less immediately (on their pc).
So I'm looking for a mechanism with wich I can notify the 'other'
applications on the network of any changes so they can update their 'view'
if necessary.

Although I think I'm capable of solving this problem by re-inventing the
wheel, I'm pretty sure it's already been done, and probably better and more
robust than my first few attempts would be... So can anyone help me out ?
thanks,
Jurjen.

Sep 26 '08 #1
Share this Question
Share on Google+
2 Replies


P: n/a

Well i can think of 3 easy ways of acomplishing that
1. if you use SQL server as database backend you could setup notification
services the database performs a callback to your app whenever the dataset
you subscibed to has a change

2. You could create a change mechanism yourself ,,, actually i have done
this a few years ago before we had notification services the following way
let a trigger in your database create a new guid in a watch table
whenever there are changes made in the main table ( you could even implement
this with a low entry "database" as ACCESS however then you should do this
from code .

now when you app gets its dataset it will also retrieve the guid and compare
this once in a while with a backgound thread to the current database value
if it has changed if it has changed you know there are changes and thus need
to update your working set .

3. You could do a broadcast on the network whenever one of the applications
perfomed a change on the dataset , then all running instances can update
there datasets

Maybe someone else has some more ideas !?

regards
Michel Posseth [MCP]
http://www.vbdotnetcoder.com



"Jurjen de Groot" <Ju*************@xs4all.nlschreef in bericht
news:%2****************@TK2MSFTNGP06.phx.gbl...
>I will be developping a planning application for wich it's necessary for
multiple users to view and edit the same data, all changes made by one
user, must be visible to the other user's more or less immediately (on
their pc). So I'm looking for a mechanism with wich I can notify the
'other' applications on the network of any changes so they can update their
'view' if necessary.

Although I think I'm capable of solving this problem by re-inventing the
wheel, I'm pretty sure it's already been done, and probably better and
more robust than my first few attempts would be... So can anyone help me
out ?
thanks,
Jurjen.

Oct 5 '08 #2

P: n/a
Michel,

thanks for your reply, in the mean Time I have found several articles
concerning PublishSubscribe scenario's and am looking into a solution
created by juval lowy from idesign wich seem to do the trick,

thanks.
"Michel Posseth [MCP]" <MS**@posseth.comwrote in message
news:eC*************@TK2MSFTNGP03.phx.gbl...
>
Well i can think of 3 easy ways of acomplishing that
1. if you use SQL server as database backend you could setup notification
services the database performs a callback to your app whenever the dataset
you subscibed to has a change

2. You could create a change mechanism yourself ,,, actually i have done
this a few years ago before we had notification services the following way
let a trigger in your database create a new guid in a watch table
whenever there are changes made in the main table ( you could even
implement this with a low entry "database" as ACCESS however then you
should do this from code .

now when you app gets its dataset it will also retrieve the guid and
compare this once in a while with a backgound thread to the current
database value if it has changed if it has changed you know there are
changes and thus need to update your working set .

3. You could do a broadcast on the network whenever one of the
applications perfomed a change on the dataset , then all running instances
can update there datasets

Maybe someone else has some more ideas !?

regards
Michel Posseth [MCP]
http://www.vbdotnetcoder.com



"Jurjen de Groot" <Ju*************@xs4all.nlschreef in bericht
news:%2****************@TK2MSFTNGP06.phx.gbl...
>>I will be developping a planning application for wich it's necessary for
multiple users to view and edit the same data, all changes made by one
user, must be visible to the other user's more or less immediately (on
their pc). So I'm looking for a mechanism with wich I can notify the
'other' applications on the network of any changes so they can update
their 'view' if necessary.

Although I think I'm capable of solving this problem by re-inventing the
wheel, I'm pretty sure it's already been done, and probably better and
more robust than my first few attempts would be... So can anyone help me
out ?
thanks,
Jurjen.

Oct 9 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.