CodingForums.com - View Single Post - Multiple open close database connections in one page

mrfreeze81 · 09-30-2010, 01:59 PM

Thank you. I don't want to change the DAL unless its really necessary. I have tried to write a SP to club a few of the insert/select statements which help me in eliminating some of the open and close statements from my code.

I'll probably have to come up with a better way eventually, as I will have to start integrating transactions and much more to that page.

09-30-2010, 01:59 PM	PM User \| #3
mrfreeze81 New to the CF scene Join Date: May 2008 Location: US Posts: 6 Thanks: 0 Thanked 0 Times in 0 Posts	Thank you. I don't want to change the DAL unless its really necessary. I have tried to write a SP to club a few of the insert/select statements which help me in eliminating some of the open and close statements from my code. I'll probably have to come up with a better way eventually, as I will have to start integrating transactions and much more to that page. __________________ --- Freeze