Sharing DB connection

How can I share DB connections between many pages?Hi,

why would you need to? Do you have some sort of transaction which should
last over multiple pages?

Anyways, connection pooling in .NET is one reason why you shouldn't try to
share connections, but instead use them so that open the conn late and close
as soon as possible and when you need a another conn, instantiate such when
needed.

--
Teemu Keiski
ASP.NET MVP, AspInsider
Finland, EU
http://blogs.aspadvice.com/joteke
You should not. This is not your grandfather's ASP. ASP.Net uses Connection
Pooling to solve the problems that ASP had. With ASP.Net, you should open
and close Connections as quickly as possible.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
The sun never sets on
the Kingdom of Heaven

"David Dvali" <david_dvali@.hotmail.com> wrote in message
news:eSBds$2hFHA.2444@.tk2msftngp13.phx.gbl...
> How can I share DB connections between many pages?