Validation of UPDATE query in SQL using Visual Studio

I have a details view that has one field that allows an update. You can select open or close. When clicking "edit" it allows the user to update the field using the query: set status = @Status where (Job = @Job) and (Job_Operation = @Job_Operation) UPDATE Job_Operation set last_updated = current_timestamp where (Job = @Job) and (Job_Operation = @Job_Operation)

This works fine, but would like to proceed the list box "open/close" with a validation textbox that would require the user to enter a PIN number to confirm their identity. If the PIN number matched a list, the update would succeed, and if not, the update would return an error.