Last event on page? 1

[mrdance]

I am new to ASP.NET. I do some database queries in my script and want to close the connection at the end of the script. Where should I put the disconnect? Maybe I don't know when the last execution will be and there will be several queries so I want to disconnect at the "last stage". Any ideas?

--- neteject.com - Internet Solutions ---

 

[vbkris]

http://msdn.microsoft.com/library/d...on/html/vbconWebFormsPageProcessingStages.asp

Known is handfull, Unknown is worldfull

 

[ca8msm]

I wouldn't really recommend closing your connections in the unload sub of the page as you shouldn't leave connections open.

You should only have your connection open whilst running the actual SQL command so I would suggest placing your code in a sub/function (and call this each time you need to run any SQL) and using a Try/Catch. e.g

    Private Sub RunMySQL(ByVal strSQL As String)
        Try
            ' Open Connection and run SQL

        Catch ex As Exception
            ' Catch any exceptions

        Finally
            ' Clean Up and close connections

        End Try
    End Sub

--------------------------------------------------------------------------------------------------------------------------------------------

Need help finding an answer?

Try the search facility (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.

 

[jshurst]

Regarding connections...it is better to open late and close early. I usually use the method mentioned by Ca8msm.