QUOTE(YogiYang @ 8 Dec, 2007 - 05:22 AM)
There is no reply. What is the problem? Have I posted to the wrong forum?
Might go better in databases, but I'll give it a go.
QUOTE(YogiYang @ 7 Dec, 2007 - 06:58 AM)
If I am viewing a set of data which is take from two separate table using an SQL query. Now if any other user updates the data in any of these tables the updated changes are not reflected in my view.
How can I get this to happen?
By default DotNET uses Disconnected database connection concept.
Short answer, you can't.
The disconnected nature of the transaction is irrelevant for you problem, so ignore that part. Your issue is with database concurrency.
Basically, every time you query a database the result set is only valid for the time of the request. The very next nano second after your request, someone may have committed changes. The real headache is when two people post changes to the same set of data sequentially, in which case last update wins; usually.
There's no real solution, it's just the nature of a multi user environment. If its vital that your current view of the data be up to date then you best bet is to periodically re query the database to catch any changes.
Hope this helps.
7 Dec, 2007 - 03:58 AM
| 