How can I reflect changes in underlying database into my application dynamically

[AliRezaGoogle]

Dear Group,
I have a SQL Server 2000 databse with some tables. The tables contents
are modified by many users at the same time. When I fetch some rows
from a table via dataset into my application , I just have a static
version of rows. When other users modify the rows I do not have new
changes on them. In other words I want to have most up-to-date version
of rows every time. One way is to refresh dataset ( re-fetch) in short
periods of time. But this is not possible when dealing with millions
of rows. Is there any solution for this problem?

[=?UTF-8?B?QXJuZSBWYWpow7hq?=]

AliRezaGoogle wrote:

I have a SQL Server 2000 databse with some tables. The tables contents
are modified by many users at the same time. When I fetch some rows
from a table via dataset into my application , I just have a static
version of rows. When other users modify the rows I do not have new
changes on them. In other words I want to have most up-to-date version
of rows every time. One way is to refresh dataset ( re-fetch) in short
periods of time. But this is not possible when dealing with millions
of rows. Is there any solution for this problem?

If you were using 2005 the following could have been a solution:
http://msdn2.microsoft.com/en-us/lib...ependency.aspx

Maybe the updating code can invalidate all caches that contains the data.

Maybe offline long time locking is an option.

Arne