There's a bad way to accomplish that..

Just use XLOCK... XLOCK makes an exclusive lock to the record until the transaction is committed...

On c# you can:

1. begin transaction

2. SELECT 1 FROM tableToLock WITH (XLOCK) WHERE Id = @ID

3. do what ever you want....

4. commit transaction

But it's a risky thing to do...

Pedro