DataBase connection

[varun varun]

hello friends,

i am developing an asp.net application in which
i want to keep database connection of
my application alive through out the application.

in my case, my DBMS is MS SQL Server 2000.

i came to know that in application_init event of
the application, we can put some code to
connect to our back-end.

i tried to search a lot for this event in
developer environment but could not locate it.

so can anyone tell where do i need to put the code ?

thank you.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Kevin Spencer]

You need to dump the idea. ADO.Net is designed to leverage Connection
Pooling, and trying to use one Connection for the entire app is not a good
or safe idea.

HTH,

Kevin Spencer
Microsoft FrontPage MVP
Internet Developer
http://www.takempis.com
Some things just happen.
Everything else occurs.

"varun varun" <an*******@devdex.com> wrote in message
news:ez**************@tk2msftngp13.phx.gbl...

hello friends,

i am developing an asp.net application in which
i want to keep database connection of
my application alive through out the application.

in my case, my DBMS is MS SQL Server 2000.

i came to know that in application_init event of
the application, we can put some code to
connect to our back-end.

i tried to search a lot for this event in
developer environment but could not locate it.

so can anyone tell where do i need to put the code ?

thank you.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!