How to Lock a Database table through c# code?

Question

Hi,

    I have a database in SQLSERVER with some columns and it is meant for multiple access.Now i don't want a user to interrupt the database if some other user is modifying that database.I want to write the code through c# ans not through SQL. please help me out.