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

  • Thread starter Thread starter AliRezaGoogle
  • Start date Start date
A

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?
 
AliRezaGoogle said:
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?
Click to expand...

If you were using 2005 the following could have been a solution:
http://msdn2.microsoft.com/en-us/library/system.data.sqlclient.sqldependency.aspx

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

Maybe offline long time locking is an option.

Arne
 
Back
Top