Global connection

[abcd]

Any body please tell me how to declare the connection object public /global in asp.net and how to call the object in forms.

Thanks in advance

 

[hrabia]

You have to declare your object in global.asax

<object id="MyConnection" class="System.Data.SqlClient.SqlConnection" runat="server" scope="Application"></object>

Than you can use it in following way:

Dim moConn As System.Data.SqlClient.SqlConnection
moConn = CType(Application.StaticObjects.Item("MyConnection"), System.Data.SqlClient.SqlConnection)

BTW: It is VERY BAD idea having Connection object as global object. Because of connection pooling it is much better to create, use and destroy (close) connection to database as quickly as possible.