Hey freinds ,
Suppose that same set of records are being accessed by the more than 1 user
at a time and if some process is done simultaneously,suppose at same time
then who ever request first to server will be able to enter the record and in
user2 get error of data duplication due to primary key.
So how to apply locks on the data when some interaction is done with the
database.

(2) suppose user opens the application then he goes out ..for an hour or so
after he come he can see the status of records what he has left ,so how to
refresh the data or to notify or to AUTO UPDATE the records...

Please reply its Urgent Myid is : Patelblues (AT) hotmail (DOT) com

2 is easier to handle than 1. If this is a web app, there is no automatic
refresh, you can use the mouse movement or a click to go to the server to
check for fresh data. or provide the user with a refresh button. One other
alternative is to have the page refresh every 15 minutes or so. these
approaches aren't elegant but the disconnected architecture of the web
constrains the approaches to this problem.

1. you need to take care of this condition in code using exception handling.

--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc, Amazon.com etc
"patelblues" <patelblues (AT) discussions (DOT) microsoft.com> wrote