Hi Rudy
It sounds like you want some form of notification sent to the client
app when a change happens at the DB. If this is correct then there's a
couple of options that I'm aware of (depending on your DB).
If you're using SQL 2000 then one of the "common" options is to have an
extended proc that runs via a trigger on the table(s) that you want to
monitor. This proc basically writes details of the change to a file
that is accessible from the client app, and the client app watches this
file for changes using a file-watcher, when a change is picked up, the
client can read the file for what the change was and act accordingly.
I seem to remember something on Codeproject.com that dealt with this.
Alternatively, if you're using SQL 2005 then there is an updated
version of notification services available that will send out
notifications to all interested parties - take a look on MSDN as I'm
sure there's lots of info there.
Hope that helps
Martin
Rudy wrote:
Hi Goran!
OK, Sorry. Didn't make myself clear on this. I have a server application
and a client application. The update will be executed at the server app,but
after it's done I want the message box to show up on the client app. So how
do I watch that update from the client. I know I can create a click event on
the client to look for the update. But I wouldn't think I would loop that.
Looking fot the best way.
Thanks!
Rudy
"Göran Andersson" wrote:
Rudy wrote:
I'm working in vb/ado.net I want to to have a message box pop up based on a
result of a update on a SQL table. How do I do that so it automaticly pops
up after the update is performed?
Just put the code that shows the message box after the code that updates
the table.
Also, is there a way to put in a variable in the message box base on the
results of the Update?
You can put whatever you want in the string that you use to show the
message box.