----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: saurabhdotnet Message 3 in Discussion Hi ! Sara ! Q. I am having a data set which can be modified by multiple users. What will be the row output if all are modifying the same record and updating? A. The problem you are talking here is of Concurrency. There are lots of professional ways this can be solved. 1) BTW, Datasets automatically handles concurrency, whenever the rercords gets manipulated by other user and you will try to update the dataset, this will throw an concurrency exception. 2) But a practical solution will be - use a time stamp column in your all the tables. and whenever you retrieve the data from the tables + the timestamp column to dataset and then get the data into the data set. And when anybody will modify the data into the tables, he will also increment the timsstamp column by 1 . So, when you come there for updating that particular row, you can check the timestamp column in you dataset with the timestamp column in the database table matches or not. And if they are not matching means the row has been updated by anybody. So, there you can either raise the exception, or Get the refresh/updated data / or simply update the row - this totally depends on the case scenario. Hope this help you out. cheers, Saurabh Verma MCT, MCDBA 2003, MCSD.NET (Chartered Member) _________________________________________________________________ Big guns are booming! Bollywood is a war zone! http://server1.msn.co.in/features/decmovies03/index.asp Catch all the filmi action this December. ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/bdotnet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
