I'm not sure if this is ther right forum for this but I think its a problem as much related to database programming as to ASP.net.

In fact i'm working on the development of a ASP.net LAN-based application over SQL server back-end that is being used in a multi user environment. When a user is editing a row in a table in the SQL database, I lock that record using rowlock so that no one else can have access to it. now this mechanism works perfectly. Only that, if ever a user has initiated a rowlock and then closes the aspx page through by IE, then the row is not updated and rowlock is not released (correct me if i'm wrong). Thus I believe that another user won't have access to the row unless the rowlock is released.

One good thing would have been to detect the closing event of an aspx page when IE is closed but this is not possible I think. Any suggestions how this problem can be solved or worked around?

all help appreciated,

thanx