remote delegate handling
-
hi, in my case, i have a lan using sql server as data server, now one client insert or update some important data that it's highly recommended to another clients understand this operation, is there any way to make a remote delegate on all clients or something like this ty
-
hi, in my case, i have a lan using sql server as data server, now one client insert or update some important data that it's highly recommended to another clients understand this operation, is there any way to make a remote delegate on all clients or something like this ty
My first thought is that you'd probably have to setup a communications system with a central server that performed the database operations, and then notified all of the clients of the change.
.45 ACP - because shooting twice is just silly
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001 -
hi, in my case, i have a lan using sql server as data server, now one client insert or update some important data that it's highly recommended to another clients understand this operation, is there any way to make a remote delegate on all clients or something like this ty
You could use SqlDependency to keep clients updated when the database has changed. Using SqlDependency for data change events[^]
I know the language. I've read a book. - _Madmatt
-
You could use SqlDependency to keep clients updated when the database has changed. Using SqlDependency for data change events[^]
I know the language. I've read a book. - _Madmatt
thanx for ur answer, in my case I have 1milion record in my cached table in my form, so if 1 record has changed,then by using sqldependency 1milion record must be retrived again! is it possible to understand which record has been changed?
-
My first thought is that you'd probably have to setup a communications system with a central server that performed the database operations, and then notified all of the clients of the change.
.45 ACP - because shooting twice is just silly
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001thanks for ur answer, u right, look im going to do this as easy as possible, bcoz fee for this work is only 50$. :(
-
thanx for ur answer, in my case I have 1milion record in my cached table in my form, so if 1 record has changed,then by using sqldependency 1milion record must be retrived again! is it possible to understand which record has been changed?
1 million? I doubt that. Have you read the documentation? Have you actually tried it?
I know the language. I've read a book. - _Madmatt
