Loading

Share a SQL DB connection in the same form

M T

Hi

I have been working in VB.NEt and recently shifted to C#. I want to open a DB connection and keep it open till user close the form. I want to use this connection for fetching different record sets.

In VB, I can declare a CONN variable in teh beginig of the form and open the connection at the form load and keep on using it.

Is there a way in C#?

Thanks

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bechir Bejaoui18y ago
or impelent the closing event of the form by connection.Close();
Bechir Bejaoui18y ago
using(...Connection oConnection = new ...Connection("ConnectionString"))
{
/* put your code here, and after excution of the bloc the connection will be garbage collected */ authomatically
}