Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: Server2008
Hey everyone,
My question is that, In my app there are 100 of user to access the record from table but my requirement is that if suppose, any one hold particular record none of user(ie remaining 99 user can't) access this record until it's lock is release.
 
so pls help me
 
OP's additional information moved from comment below
Sir, I wanted to lock particular integer value either in Sql server or C#
 
I have RadioButtonList, so if some one checked particular radiobuttonlist and also at the same time another user trying to check this radiobutton then he will get the messages(this radio button hold by other user).
Posted 16-Nov-12 21:45pm
Edited 19-Nov-12 4:31am
Nelek51.4K
v3
Comments
Nelek at 17-Nov-12 5:11am
   

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Use table hints to lock the particular row, page or table. Please refer the following link:
http://msdn.microsoft.com/en-us/library/ms187373.aspx[^]
  Permalink  

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

  Print Answers RSS
0 CPallini 365
1 Sergey Alexandrovich Kryukov 242
2 OriginalGriff 165
3 George Jonsson 159
4 Richard MacCutchan 110
0 OriginalGriff 6,344
1 Sergey Alexandrovich Kryukov 5,860
2 CPallini 5,135
3 George Jonsson 3,559
4 Gihan Liyanage 2,522


Advertise | Privacy | Mobile
Web01 | 2.8.140916.1 | Last Updated 19 Nov 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100