----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: _Neeraj_ Message 3 in Discussion Probably you can use the using statement while establishing the connection with the database. As soon as you come out of that block the connection gets closed immediately. See if it helps. Regards, Neeraj Saluja ----- Original Message ----- From: SaifIkram4u <[EMAIL PROTECTED]> Date: Mon, 27 Sep 2004 03:38:39 -0700 Subject: SQL Server Problem To: BDOTNET <[EMAIL PROTECTED]> New Message on BDOTNET SQL Server Problem Reply Reply to Sender Recommend Message 1 in Discussion From: SaifIkram4u Hi All, There is an ASP.NET application for which i am doing enhancements.. the application uses SQL Server database. everywhere they are just opening the connection and was just reading the data using datreader... and they are not closing. because of this when the user performs certain action "n" number of processes are getting created in SQL Server database..... How can i change please give suggestion : like creating one connection object at session or application level or is there any way thanks Saif ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ********************************************************************** View other groups in this category. Also on MSN: Start Chatting | Listen to Music | House & Home | Try Online Dating | Daily Horoscopes To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. Need help? If you've forgotten your password, please go to Passport Member Services. For other questions or feedback, go to our Contact Us page. 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. Remove my e-mail address from BDOTNET. ----------------------------------------------------------- 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]
