473,372 Members | 1,074 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,372 software developers and data experts.

Data Changed Event ?

Hello,

I'm using SQL server 2000.
I want to permanently have a deconnected dataset taken with a select command
like SELECT* FROM table WHERE myActiveField=True

When The Field "myActiveField" is chnaged by another software, I want to
refresh my dataset.
Is it possible to do that ?

I think with sqlserver2005 it's possible, but with 2000 ?

Thx
Jan 27 '06 #1
2 2101
I don't remember how to do it, but what I do remember from the demo's I've
seen is that is possible with 2005 and 2000 using .net 2.0. You implement
both the same way.

With 2005, it is supported by SQL natively. With 2000 the 2.0 frame work
sets up a polling mechanism and will poll your database to see when data has
changed.

Thanks
Wayne

"Geoffrey" <AE**************@dufour.be> wrote in message
news:ON**************@tk2msftngp13.phx.gbl...
Hello,

I'm using SQL server 2000.
I want to permanently have a deconnected dataset taken with a select
command
like SELECT* FROM table WHERE myActiveField=True

When The Field "myActiveField" is chnaged by another software, I want to
refresh my dataset.
Is it possible to do that ?

I think with sqlserver2005 it's possible, but with 2000 ?

Thx

Jan 27 '06 #2
I've never tried it, but the scuttlebut I've heard here is that it's
incredibly resource intensive, and you're better off having your app
periodically poll the database for changes.

As I said, though, I've never tried it, so I don't stand by this
advice. :)

Jan 27 '06 #3

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

Similar topics

0
by: Dinesh | last post by:
We need to perform math functions on the data from one or more data sources and store the result of the math function as a new data. In order to achieve this result, we are currently using global...
4
by: JonathanG | last post by:
All, Thanks in advance for any help. I am attempting to write a property that is an array of strings. I am trying to trap the event when one of the strings in the array changes. When I step...
2
by: Adrian Parker | last post by:
We have a date control (textbox) that opens up a popup calendar window, how, when that calendar returns with the selected value can I cause the changed event to fire on the date control ? --...
1
by: Robert van Poelgeest | last post by:
Hi We just upgraded to VS2005 but now the FileSystemWatcher no longer fires events under ASP.NET. We use the following code (which works under 1.1): private void AddFileSystemWatcher(string...
1
by: RichGK | last post by:
The first time I run my code the list box sends a selected index changed event even though at this point there has been no activity with the mouse. The value returned from SelectedValue according...
0
by: Ryan Liu | last post by:
Hi, How to capature data changed event in datagrid when the datasource is an ArrayList? I know if the datasource is a datatable, there are events like ColumnChanged, RowChanged, RowDeleted...
1
by: =?Utf-8?B?RG9hbiBOZ3V5ZW4=?= | last post by:
My application is written in VB.NET 2005 to display a table of a SQL 2005 in a datagrid. I want to be notified or capture events when table data changed (inserted, deleted, updated by another user)...
4
by: tomb | last post by:
I'm using VB.net 2003 and a FileSystemWatcher. The Changed event gets called twice for every change in the folder I'm watching. To build the functionality, I'm manually changing a text file. As...
6
by: cnixuser | last post by:
Hello, I have a basic application written which is designed to data over a serial cable and then receive a response back. I am not getting any triggers to my data received event. I have tried...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

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.