How to lock particular record in sqlserver using C#

Question

4.00/5 (1 vote)

See more:

, +

I want to lock a record so that no one except myself can access that record.

I heard locking concept in SQLServer.

But I don't know how to implement it.

Example:

I have logged into a user name say 'John'

Only the username with such name can access this record.

How to do this in SQLServer and implement in windows forms using C#.

Posted 15-Jun-14 22:31pm

KUMAR619

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Debabrata_Das · Answer 1 · 2014-06-15T22:37:00

Solution 1

Hello friend, the following link might help you:

6 ways of doing locking in .NET (Pessimistic and optimistic)[^]

- DD

Posted 15-Jun-14 22:37pm

Debabrata_Das

Kornfeld Eliyahu Peter · Answer 2 · 2014-06-15T22:40:00

There is no way to lock a record (or table or index or page or any other SQL 'object') using programming techniques. SQL locks are created by SQL while executing different queries (transactions). You can learn a lot about locking here: http://technet.microsoft.com/en-us/library/ms190615(v=sql.105).aspx[^]
That all means that you have to develop (or find on the web) a solution for yourself...The main ideas are:
1. Record the PK of the row to lock
2. Check your records upon access
3. Clean record when appropriate (explicit release or time-out)

Sprint89 · Answer 3 · 2014-06-18T00:02:00

Solution 3

You are talking about security rather than locking. You should limit access to the database then set up role-based security in your code. When a user tries to view/change data, check their credentials and limit their access in your code rather than by locking the database

Posted 18-Jun-14 0:02am

Sprint89