By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 1,110 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 IT Pros & Developers. It's quick & easy.

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

P: n/a
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?

Oct 26 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
Oct 27 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.