Locking Mysql table after inserting one row using c# code.

Question

Hi    I am  developing a software. In that software just consider table "COMPANY", after logging in to the software ( very first time ), user will enter his company details. Once the company details are entered and inserted into table , later user should not be able to insert new record (the table should get locked using c# code ). Also if he wish to edit the details he should be able to do that and by opening the lock of the table. Once the update is over then again table should get locked.    Else is there any other solution for my problem , please let me know. I will be very thankful.

Nishant Mittal · Answer

Hi   try reading this   http://www.dotnetperls.com/lock   http://www.codeproject.com/Tips/788402/Monitor-and-Lock-in-Csharp

Kedar Pawgi · Answer

hi sir sorry to say but i didnt understood what you wish to say. I request you to please let me know in brief what exactly you wish to say. What i understood is i should make a function in c# and directly use insert command. Is that so, plz let me know thanks in advance.

Nishant Mittal · Answer

Hi   use Lock(this) { //Insert the record in the table  }    hope it will work