Synchronization

  • Thread starter Thread starter Samuel
  • Start date Start date
S

Samuel

Hello,

I would like to know if something like that exist:

To make it simple, I want to have a table in SQL server and a grid in my
program. When I modify the table, it updates the grid automatically and
without writting special code in my program.

For the moment, what I found, it's "SQL Broker service". But, it doesn't
correspond to what I want. It just says that the table have been updated and
then it's the program to make itself update by recovering data from the
database.

Somebody have an idea?

Samuel
 
Hello Samuel,

If you use .NET 2 and SQL Server 2005 you can use Query Notifications.
You are provided with an onchange event in your dataset that you can
use to repopulate a table in case there is a change in the database.

If you don't use .NET 2 or SQL Server either you have to resort to
manual polling or use a trigget that will call an extended stored
procedure that will notify a client ...

Check the following link :
http://msdn2.microsoft.com/en-us/library/ms175110.aspx

Regards,
Tasos
 
Samuel,

You typically only get this functionality with real-time databases such as
Polyhedra (www.polyhedra.com).

Out of curiosity, for anyone who reads this, how useful a feature would this
be? I've been researching a way to do this with SQL-Server. I have an
approach that will work, but its quite a lot of work to finish the
implementation. If I licensed this feature for $1000 would you buy it?

Thanks
Adrian Moore
MVP - Windows Networking
 
Back
Top