By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,883 Members | 2,037 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,883 IT Pros & Developers. It's quick & easy.

DB Connections in ASP.net ?

P: n/a
Good evening all

Have a question about coonections. We are disscusing two ways

1] Open the connection. Run your SQL. Close the connection
This done is a function or sub

O

2] Open connection on page load/Init
It stays open during life of page. When you move from page to another one or when browser is killed yo
then close the connection

Which is the best way
Life of page? While it is shown on client Browser
or
is life of page ended when it is completely loaded in client browser
If so if you closed the connection in a finished page event would that be better then
opening a connection, doing the SQL cmd, disposing of the connection in a fucntion or procedure

Hope this all made sense. Its just ever where I read it says open it, do it, then kill it

Thank
Deasu

Jul 21 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.