Well, there are a couple ways you could do that.
You could write a windows service with a
System.Timers.T imer object, that fires an event ever 15
minutes. Or, you could use a trigger on the table you are
evaluating. On update for your table, your trigger fires
executing a piece of code that could be a SQL job, or an
actual executable you had written in VB or VB.net. The
easiest programatic way would probably be the service
though.
Cheers... -----Original Message-----
I am writing a little vb/vb.net application to check
every15 minutes if a record or certain records have changed in
a specific table, If record/records have changed then
getthe index of that record. What is the best way to
accomplish this task? Any ideas or source code samples
would be highly appreciated.
I am using vb.net with SQL Server 2000, vb6 is also
available to me.
Thanks
. 2  9771  -----Original Message-----
Well, there are a couple ways you could do that.
You could write a windows service with a
System.Timers. Timer object, that fires an event ever 15
minutes. Or, you could use a trigger on the table you are
evaluating. On update for your table, your trigger fires
executing a piece of code that could be a SQL job, or an
actual executable you had written in VB or VB.net. The
easiest programatic way would probably be the service
though.
Cheers...
-----Original Message-----
I am writing a little vb/vb.net application to check
every15 minutes if a record or certain records have changed
ina specific table, If record/records have changed then
getthe index of that record. What is the best way to
accomplish this task? Any ideas or source code samples
would be highly appreciated.
I am using vb.net with SQL Server 2000, vb6 is also
available to me.
Thanks
.
.
Thanks for you reply.
Yes, I am writing this process using Windows Servce and
using Update Trigger, how do I know which record has
changes?
The most easy way is to create a table and inset in it a record index and
change time on trigger event.
Then your service can red this table and empty it, or keep it and just
select after particuar time.
Code can look like:
CREATE TRIGGER watchTrigger
ON <table_name, sysname, pubs.dbo.sales>
FOR INSERT, UPDATE
AS
BEGIN
insert watchTable ([ID], ChangeTime) select [ID], getdate() from inserted
END
GO
"Mo Quamar" <mq*****@cprk.c om> wrote in message
news:03******** *************** *****@phx.gbl.. . -----Original Message-----
Well, there are a couple ways you could do that.
You could write a windows service with a
System.Timers. Timer object, that fires an event ever 15
minutes. Or, you could use a trigger on the table you are
evaluating. On update for your table, your trigger fires
executing a piece of code that could be a SQL job, or an
actual executable you had written in VB or VB.net. The
easiest programatic way would probably be the service
though.
Cheers...
-----Original Message-----
I am writing a little vb/vb.net application to check
every15 minutes if a record or certain records have changed ina specific table, If record/records have changed then
getthe index of that record. What is the best way to
accomplish this task? Any ideas or source code samples
would be highly appreciated.
I am using vb.net with SQL Server 2000, vb6 is also
available to me.
Thanks
.
.
Thanks for you reply.
Yes, I am writing this process using Windows Servce and
using Update Trigger, how do I know which record has
changes?
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Salina |
last post by:
I am new in C#.Net and going to write a window
client/server application.
my database is mysql and the data will update every min.
what i need to do is push the up-to-date data to clients
from server directly. Clients just need to read the data,
not neccessary for modification.
Can anyone recommend me what method I should use? DataSet
or Threading or anything else? Any samples?
Please help
|
by: Mo Quamar |
last post by:
I am writing a little vb/vb.net application to check every
15 minutes if a record or certain records have changed in
a specific table, If record/records have changed then get
the index of that record. What is the best way to
accomplish this task? Any ideas or source code samples
would be highly appreciated.
I am using vb.net with SQL Server 2000, vb6 is also
available to me.
|
by: Alessandro |
last post by:
When I build a setup project under vb2005, starts "Microsoft sql server 2005
Tool" showing "Please wait while windows configures Microsoft sql server
2005 tools"
Then it stop with this message: Failure setting security rights on users
account SQLServer2005NotificationServicesUser$M2
If I give the user administrator rights it does not happen and buid goes
right. I I remove the user from administrators the message is showed again.
I...
|
by: zxo102 |
last post by:
Hi,
I am doing a small project using socket server and thread in python.
This is first time for me to use socket and thread things.
Here is my case. I have 20 socket clients. Each client send a set
of sensor data per second to a socket server. The socket server will
do two things: 1. write data into a file via bsddb; 2. forward the data
to a GUI written in wxpython.
I am thinking the code should work as follow (not sure it is
feasible)...
|
by: Jobs |
last post by:
Download the JAVA , .NET and SQL Server interview with answers
Download the JAVA , .NET and SQL Server interview sheet and rate
yourself. This will help you judge yourself are you really worth of
attending interviews. If you own a company best way to judge if the
candidate is worth of it.
http://www.questpond.com/InterviewRatingSheet.zip
| | |
by: Ryan |
last post by:
I am trying to log events to SQL Server instead of the computers event
log, but, although I get no errors, I have no luck. The
webevents_events table is empty. I have a custom event that I am
raising (passwordchange), and can see it beign raised
successfully...just it seems to go nowhere. I have run aspnet_regsql
to setup the database to handle event recording. I am fairly sure I am
missing something in my web.config file. (I would...
|
by: Rick |
last post by:
I developing a large project that will have numerous text boxes, datetime
controls, checkboxes etc. all data bound to a
dataset/datatable/tableadapter.
I'm wondering what is the normal way to get notification from the program
that the user has changed some databound item? I know I can tap into the
OnChange event of all these individual controls, however it seems like there
should be something exposed at a more common level.
I looked...
|
by: Toni |
last post by:
Hello! I'm trying to use ASP.NET caching with my web site and SQL Server,
but I have a problem.
I try to do everything according to the instructions like this page here:
http://www.eggheadcafe.com/articles/20060407.asp
First I run the aspnet_regsql tool on the command line succesfully to enable
the database for cache notification:
aspnet_regsql -S -E -d -ed
|
by: Toni |
last post by:
Hello! I'm trying to get caching work with ASP.NET 2.0 and SQL Server
Express Edition 2005, but I have a problem and I can't figure out what I'm
still doing wrong.
I have enabled the database for cache notification by running the
aspnet_regsql tool on the command line:
aspnet_regsql -S server -E -d database -et
Then I have run the aspnet_regsql tool to enable each table in the database
for cache notification:
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
