Concurrent Updates using asp.net and mysql...
-
Hi, I am developing small web application(ASP.NET and MySQL)with CURD Operations which has one table and has 30 columns. my ques: Suppose If more than one person tries to modifies the same row(record) then it should throw message as "Someone already editing the record". I find out optimistic and pessimistic locking for the above problem. How to achieve this one and which method to use any sample application which will be very useful Reg, Subbu
-
Hi, I am developing small web application(ASP.NET and MySQL)with CURD Operations which has one table and has 30 columns. my ques: Suppose If more than one person tries to modifies the same row(record) then it should throw message as "Someone already editing the record". I find out optimistic and pessimistic locking for the above problem. How to achieve this one and which method to use any sample application which will be very useful Reg, Subbu
use ado.net transaction for that so that allow only one person at time to update record
-
Hi, I am developing small web application(ASP.NET and MySQL)with CURD Operations which has one table and has 30 columns. my ques: Suppose If more than one person tries to modifies the same row(record) then it should throw message as "Someone already editing the record". I find out optimistic and pessimistic locking for the above problem. How to achieve this one and which method to use any sample application which will be very useful Reg, Subbu
i had that Problem once in my early days. but look at how i wrote the SP to overcome that. I check if the Value has change since i have retrieved the data, if it has change i dont Update. look at this Coding an N-Tier Application in C# Without Any Wizard: Part II[^]
Vuyiswa Maseko, Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code. C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.com vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/