Author: Jackxxx | Posted on: 8/15/2008 8:09:31 AM | Views : 1131

Just woundering if this is the correct way to do this or if there is a more efficent way?
I'm just opening a table and grabing a couple of settings I need on my web form. I call this in the page load event.

Sub GetStuffFromSettings()
        Dim dtrGAN As SqlDataReader
        Dim strName As String
        Dim SelectGAN As String
        Dim ConnectStr As String = _
            ConfigurationManager.ConnectionStrings("ConnectionString").ConnectionString
        Dim Con As New SqlConnection(ConnectStr)
        Con.Open()
        SelectGAN = "Select Name,TaxRate FROM tblSettings"
     & ...

Go to the complete details ...