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.