ASP Transaction from locking table just after select coomand

Hello Guys.....

I want to lock table row after select command so that another process could not able to select that row again while the first process is being running.......

Please Note That:---

I want to lock table row just after select command fired


ASP Transaction works only when then table is being updating but not for after simple select command

sourabh