-1

I'm developing Windows forms Application using Microsoft.Net, VB and Sql. Which is managing repository from databases of OLTP.

I want to implement triggering system, such that when data inserted in OLTP's database it will be notified to me so that I can update my own Application's data in order to get most recent data.

How can I achieve that?

Bruce_Wayne
  • 1,564
  • 3
  • 18
  • 41
M Adnan Ayub
  • 21
  • 4

2 Answers2

0

You need to use database mail and create SQL triggers on your corresponding Tables

refer this link

Send e-mail from a trigger

Community
  • 1
  • 1
Rolwin Crasta
  • 4,219
  • 3
  • 35
  • 45
  • Is there any other way for triggering that changes database, as I've to link the some other function to that trigger for the Loading of data in the Application Database – M Adnan Ayub Apr 20 '15 at 11:03
  • You could link your function and call the function from within this same trigger as well.. – Rolwin Crasta Apr 20 '15 at 11:22
0

I think you're looking for Query Notifications. I'd caution you against hooking up a client application directly to it (as opposed to an intervening back-end service that your client talks to), but there you have it.

Ben Thul
  • 31,080
  • 4
  • 45
  • 68
  • I got this, as i studied from the link provided above its for the cache applications and used with web applications..but i wan that for the windows application with Sql-Database – M Adnan Ayub Apr 20 '15 at 17:35
  • The backend client doesn't matter - you can use it in a windows app if you want to. I'm sure that the example given was just that - an example. – Ben Thul Apr 20 '15 at 19:11