Is there any way of locking the Particular Row of the Database through ADO?.

<i><b>Originally posted by : Sakthivel (sakthivel_atw@hotmail.com)</b></i><br />At the Time of Editing a record i want to lock the Row in the Database throught ADO from ASP. If we are using <br /><br /> objConnection.BeginTrans<br /> .....<br /> .....<br /> objConnection.EndTrans<br /><br /> It is locking the Entire Database. Is there any way of locking the Particular Row of the Database through ADO? from ASP.<br />

A particular that is edited is locked by default (or should be, depending on the database system used). You should have to use code in order to NOT lock it.