ASP.net table lock upon record insertion

[Nestor]

I'm writing a simple aspx page that allows users to key in some data and
submit them into a SQL2k database. I realised that even after that db
connection closes and the page unloaded and closed, the table will still be
locked in the database. Is there any way to unlock the table after the
process is completed?

Thanks in advance

 

[Scott Allen]

How are you locking the table with a closed connection?

 

[Nestor]

thats my question.. how come it's still locked?

How are you locking the table with a closed connection?

 

[George]

1. closing DB connection in ASP.NET does not close it per say.
We have a DB connection pooling. So when you close it you simply releasing it for grab. And next DB request to open connection will grab already opened connection. Thus saving some time required to open DB connection.

You got to remmeber that if you are using TEMP tables in MSSQL

2. Connection per say does not lock tables. Only SQL statements do when they run as batch. I am positive that it's something else that locking your table.




George.

thats my question.. how come it's still locked?

 

[xhead]

Perhaps your "updating" code had a BEGIN TRAN but no COMMIT