473,241 Members | 1,578 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,241 software developers and data experts.

Automate a message box based on UPDATE?

Hello all!

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?

Also, is there a way to put in a variable in the message box base on the
results of the Update?

TIA!!
Rudy
Jul 9 '06 #1
6 1341
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.
Jul 9 '06 #2
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.
Jul 10 '06 #3
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

"Gran 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.
Jul 10 '06 #4
Hi Pritcham!

Sounds like a good idea!! I'm using SQL 2000. I'll look for that extended
proc. I'll let y you kow how it goes.

Thanks!
Rudy
"Pritcham" wrote:
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.
>

Jul 10 '06 #5
Hi Rudy

Here's a link to one of the articles on codeproject (I knew I'd
bookmarked it!!)

http://www.codeproject.com/cs/databa...ntsArticle.asp

Hope that helps

Martin
Rudy wrote:
Hi Pritcham!

Sounds like a good idea!! I'm using SQL 2000. I'll look for that extended
proc. I'll let y you kow how it goes.

Thanks!
Rudy
"Pritcham" wrote:
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
>
"Gran Andersson" wrote:
>
Rudy wrote:
I'm working in vb/ado.net I want to to have a message box pop upbased 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 baseon the
results of the Update?

You can put whatever you want in the string that you use to show the
message box.
Jul 11 '06 #6
Thanks Martin!

I already got it working with your advice. A little diffrent than what this
article does. I just created a trigger to watch a table for update or
insert. Then it will update a txt file on the server, and a filewatch to
watch that file for a change. One a change happens a a message box will pop
up. The user doesn't have access to the computer, just the app, so I have a
lot of control of the file structure.

Thanks again for your help!

Rudy
"Pritcham" wrote:
Hi Rudy

Here's a link to one of the articles on codeproject (I knew I'd
bookmarked it!!)

http://www.codeproject.com/cs/databa...ntsArticle.asp

Hope that helps

Martin
Rudy wrote:
Hi Pritcham!

Sounds like a good idea!! I'm using SQL 2000. I'll look for that extended
proc. I'll let y you kow how it goes.

Thanks!
Rudy
"Pritcham" wrote:
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.
>
>
>

Jul 12 '06 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Brad Burke | last post by:
From a windows .Net app, I need to 1) check if MSAccess is already open to a certain Access application. If so, then open a form and find a certain record. 2) If not open, then open MSAccess and...
4
by: Chris via AccessMonster.com | last post by:
I have the challenge of needing to automate table creation. It doesn't end there the tables have to be created from one table that looks something like this... Email ...
16
by: cyranoVR | last post by:
This is the approach I used to automate printing of Microsoft Access reports to PDF format i.e. unattended and without annoying "Save As..." dialogs, and - more importantly - without having to use...
3
by: John Marble | last post by:
I have around 400 excel files filled with data that I need to import in ACCESS. The tricky part is that they must be imported one at time, and properly corrected before importing the next one. I...
15
by: Karl | last post by:
Hi all, I regularly use FTP to place Self Extracting Zip files on the web for remote users to update their datafiles. Works very nicely. I have automated the creation of the initial zip file (...
9
by: Ots | last post by:
I'm using SQL 2000, which is integrated with a VB.NET 2003 app. I have an Audit trigger that logs changes to tables. I want to apply this trigger to many different tables. It's the same trigger,...
1
by: tmcjunkin | last post by:
I'm trying to back into this project by defining what the user needs to see when they open a form. I'm between beginner and intermediate with vba, but have been using access for years. When the...
2
by: =?Utf-8?B?QWxleGFuZGVyIFd5a2Vs?= | last post by:
Is it possible to automate a COM object ebmeded in an excel document run the process and return the results in a C# .NET application? Or better yet extract the com object some how and just run it...
6
by: rcook349 | last post by:
I'm looking for a very simple walkthough on how to automatically build and publish a Visual Studio 2008 Windows app. E.g. 1. Create a Windows App named "HelloWorld" 2. Create a virtual...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.