Real-time data access - how?

  • Thread starter Thread starter Martin Hart - Memory Soft, S.L.
  • Start date Start date
M

Martin Hart - Memory Soft, S.L.

Hi:

I wish to use a system that supports real-time stock control via a WinForms
application. How can I use ADO.NET in a connected fashion (as opposed to
disconnected)?

Am I going about this in the correct manner?

TIA,
Martin.
 
Hi Martin
Am I going about this in the correct manner?
Click to expand...

Um, Er probably yes.:) No Windows language I am aware of handles real-time
events very well. And the only database I know of that will inform an
application of a change is Borland Interbase.

So in the real world you will probably have to set up timers that poll the
database looking for changes.One technique is to set up triggers that
maintain counters (or timestamps) in a separate table. Every insert, delete
and update increments the counters. So your programme need only read the
"changes" table to find out when something changed. Stored procedures to do
the changes are another possibility

HTH

Regards

Ron
 
What you need to look at is Microsoft Notification Services. It's designed
(specifically) to notify you when stuff in the database changes. It's been
around for about a year and is being integrated into the new version of SQL
Server so it's made it past the "experimental" stage.
See
http://msdn.microsoft.com/msdnmag/issues/02/11/SQLServerNotificationServices/default.aspx

hth

--
____________________________________
Bill Vaughn
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Back
Top