One user is accessing the record to update..
And other user is trying to access the same record for update that time i
want to do lock that record which is going to use by first user..
and second user has to know this record is using by someone..
How can i do the rowlevel lock with using SQLServer2005 and .Net2.0..
What is the use of isolation levels where we use isolation levels..
If you give me the right code,I will be thankqfull to you...

Thanks and Regards

Rajagopal G
Chrysalis Information Systems
Mumbai
Mobile:9892237486