tags:

views:

6

answers:

0

I need my connection in global.aspx what do i do. I want this code to be in global.aspx so that on other page i will just call OpenCon and CloseCon.

Dim mySqlCon As OleDbConnection
Dim strConnection As String

Sub OpenCon()
        strConnection = ConfigurationManager.ConnectionStrings("UAFConnectionString").ConnectionString
        mySqlCon = New OleDbConnection(strConnection)
        mySqlCon.Open()
End Sub

Sub CloseCon()
        mySqlCon.Close()
        mySqlCon.Dispose()
    End Sub