-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: Pooran-Prasad
Message 3 in Discussion
Hi
Satish,
.Net takes care of this by
default. However, if you have to do it, put conn.Close() in finalize method of
form.
Refer
ms-help://MS.VSCC.2003/MS.MSDNQTR.2003FEB.1033/vbcn7/html/vaconFinalizeDestructors.htm
for more details
Hope that
helps
Have a great day
:)
R Pooran
Prasad
R. Pooran Prasad
Itreya Technologies Pvt Ltd.,
Mail:
[EMAIL PROTECTED]
Phone(Off) :
5200179/80/81/82/83 Extn: 50
Mobile: +91 98860 29578
-----Original Message-----
From: Satu301176
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 08, 2003
1:38 PM
To: BDOTNET
Subject: SQL connections with Datasets
, Datareaders and Collections
New Message on BDOTNET
SQL connections with Datasets ,
Datareaders and Collections
Reply
Reply to
Sender
Recommend
Message 1 in
Discussion
From: Satu301176
When .Net developers code there
is mostly a big problem faced with the connections of the SQL
database. Mostly because of the Connnection pooling and the IIS
handling of these connection on its own. Even when the objects
are disposed the connection are not closed. Does any one know
the best way of closing/disposing the Connections?
Datareaders automatically close
the connection when you close where as the dataset the
connection remains. When we see most of the codes in the .Net
Starter kits, the collection are used to get the data from the
data layer to the business layer. Are collections helpfull
any way?(for webfarm IIS handling of request at multiple
servers)
View other
groups in this category.
-----------------------------------------------------------
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]
