hi, can anyone please help me with this..

i have an adodc with two text boxes attached to the employees table in northwind (sqlserver) .

I want to update a certain row .. then when another user logs in and tries to update the same row I want to lock it (not by using a boolean field indicating if its locked or not)
i.e. is there a method in the connection, recordset, .. that allows me to lock some rows or tables in my database. . thank you in advance.