one sql connection for multiple web forms

[new2.NET]

Hello,

I am learning ADO.NET, so please bear with me.
Currently, I am coding in VB.NET and running a SQL Server
2000. My question is this, how do I use only one
SQLConnection for multiple web forms? Is this even
possible?

Thanks in advance,
-new2.NET

 

[Guest]

new2.Net,

Its possible, but not usually advisable.

Hanging onto an open connection will keep your app from scaling. After all,
there are only so many connections to go around, and each one uses resources
on the server.

Instead, get a connection right before you need it, use it, and then close
the connection as soon as possible.

ADO.Net will keep a pool of connections that your app will use.

Kerry Moorman

 

[Cor Ligthert]

I am learning ADO.NET, so please bear with me.
Currently, I am coding in VB.NET and running a SQL Server
2000. My question is this, how do I use only one
SQLConnection for multiple web forms? Is this even
possible?

Why?

Beside that every datareader or whatever needs his own connection.

Cor

 

[Sahil Malik]

You don't need to and you shouldn't either. ADO.NET does all this under the
seams using connection pooling. Just keep creating new instances of the
SqlConnection object.

- Sahil Malik
http://codebetter.com/blogs/sahil.malik/