Keeping recordsets open?

[MagellanTX]

On an ASP.NET page is it possible to keep recordsets open?

My problem is that everytime I need to update something on the page (postback) I have to re-open my connection to SQL and query the database again. This would be much faster if there was a way to keep the recordset open.

If possible, where should I start looking?

Thanks!!!

[Cander]

Every web programmer will tell you the same thing. You do not and should not presist database connections/recordsets in a web application. Dont even look any further for this. It provides 0 benefit, but wil lhog resources and SEVERLY slow down your web site when multiple users are accessing the site with database connections open. And as web apps are stateless, there is no reliable way to close the connection when you need to when you do that which will leave database connections open, eventually crapping out your site.

[MagellanTX]

Thanks for the advice. I will take a different approach since this will have multiple users attached.