----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: Mrinal Message 5 in Discussion Hi Pradeep , See there's a beautiful strategy being used in .Net to handle such problems , for that it's important for you to understand the internals of working with DataSet , DataAdapter and DataReader . DataSet is a part of disconnected architecture and if you would have generated one using IDE then it asks for having optimistic concurrency , which means everybody accessing it can make appropriate changes and important thing is everybody is having same copy and finally one copy gets updated to final database . Now all this concurrency errors are not handled by default , it's an exception , so we need to have provision in our code to ensure there are no concurrency errors . Dataset has couple of events like RowUpdated along with it where we can check a dataset , dataview or datatable for errors and correct them accordingly before database updation . Infact we can use DataAdapter Property ContinueUpdateOnError for continuing update on errors and keep on logging errors to correct them later in form of SqlErrors . In case you are using CommandBuilder then it takes care of it by default , you can go to following link for a good explanation : http://www.zdnet.com.au/builder/architect/database/story/0,2000034918,20271957,00.htm http://www.c-sharpcorner.com/Code/2002/Aug/TransactionsNConcurr.asp Now in case of DataReader is Pessimistic Concurrency , so it locks the row while operation is going on and there's any issue with respect to others , but the problem is it won't be a nice idea in case u go for reservation system done through remote components as done in your case , so it's dataset and we need to handle it . One more way is to implement it as transactions but that will again not lead to perfect solution as it can several associated issues , In case u r having specific problem u can send it we can try to find appropriate solution . Regards , Mrinal ----------------------------------------------------------- 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]
