How can I retrieve the following connection string from (app.config) using a
routine similar to the one I have (at the bottom of the app.config)
<connectionStrings>
<add name="Coda_Desktop.My.MySettings.CodaConnectionString"
connectionString="Data Source=hisqlprod001;Initial Catalog=Membership;Persist
Security Info=True;User ID=malpha;Password=password"
providerName="System.Data.SqlClient" />
</connectionStrings>
<system.diagnostics>
<sources>
===========================================
Imports System.Data
Imports System.Data.SqlClient
Imports Microsoft.VisualBasic
Imports System.Configuration
Public Class Coda_CNN
Public Shared Function GetConnection() As SqlConnection
Return New SqlConnection(GetConnectionString)
End Function
Public Shared Function GetConnectionString() As String
' Dim sCon As String =
ConfigurationManager.ConnectionStrings("CodaConnectionString").ConnectionString
Return sCon
End Function
End Class