----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: Mrinal Message 2 in Discussion Hi , Connection pooling is implicitly handled in .Net making sure that there's an efficient usage , so even on closing connection returns to pool for optimization of usage but in case you explicitly dispose then it doesn't returns back to the pool . So, returning back to pool doesn't means that connection is active , but it's just that it can be re used , Now other thing is it's opposite , datareader retains the connection , but dataset doesn't as it closes it immediately after filling up and always in a network based scenario it's better to use collections or dataset as they are stored on server and for every request they doesn't connect to database server over the network that happens in case of datareaders , i hope it's clear , Regards , Mrinal ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/bdotnet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
