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 ...