VB NET Connection string Web Config App Config

Question

Really having an annoying time with connection strings   I have two projects together in a single solution  A Web forms application acting as the presentation layer  and a class library supporting it which will send and receive data from a database      -- The Employee Class within the Class Library Project --  Friend Class Employee  Public Function GetEmployees   As DataSet      Dim DBConnection As New SqlConnection My ConnectionString      Dim MyAdapter As New SqlDataAdapter  exec getEmployees   DBConnection       Dim EmployeeInfo As DataSet     MyAdapter Fill EmployeeInfo   EmployeeInfo        Return EmployeeInfo  End Function  End Class   Currently the application is telling me it cannot access  My ConnectionString  which I have attempted to store within a config file for quick repeated access    lt configuration gt    lt system web gt     lt compilation debug  true  strict  false  explicit  true  targetFramework  4 5    gt     lt httpRuntime targetFramework  4 5     gt   lt  system web gt     lt connectionStrings gt      lt add name  My ConnectionString  connectionString  Data Source   sqlexpress Initial Catalog My DB Integrated Security True    gt    lt  connectionStrings gt    lt  configuration gt    The web config is part of the web form project and not the class library  are these projects unable to  talk  to each other  Do I need to add a web   app config file to the class library to store a connection string within that project

User · Accepted Answer

Not clear where My ConnectionString is coming from in your example  but try this  System Configuration ConfigurationManager ConnectionStrings  My ConnectionString   ConnectionString  like this  Dim DBConnection As New SqlConnection System Configuration ConfigurationManager ConnectionStrings  My ConnectionString   ConnectionString

User · Answer

Public Function connectDB   As OleDbConnection          Dim Con As New OleDbConnection          Con ConnectionString    Provider SQLOLEDB 1 Persist Security Info False User ID sa Initial Catalog    amp  DBNAME  amp    Data Source    amp  DBSERVER  amp    Pwd    amp  DBPWD  amp             Con ConnectionString    Provider SQLOLEDB 1 Integrated Security SSPI Persist Security Info False Initial Catalog DBNAME Data Source DBSERVER-TOSH User ID Sa Pwd   amp  DBPWD          Try             Con Open           Catch ex As Exception             showMessage ex          End Try         Return Con     End Function

User · Answer

Connection in APPConfig   lt connectionStrings gt     lt add name  ConnectionString  connectionString  Data Source 192 168 1 25 Initial Catalog Login Persist Security Info True User ID sa Password example com    providerName  System Data SqlClient    gt   lt  connectionStrings gt    In Class Cs  public string ConnectionString       get               return System Configuration ConfigurationManager ConnectionStrings  ConnectionString   ToString

User · Answer

I don t know if this still is an issue  but i prefere just to use the My Settings in my code   Visual Studio generates a simple class with functions for reading settings from the app config file    You can simply access it using My Settings ConnectionString       Using Context As New Data Context DataClasses           Context Connection ConnectionString   My Settings ConnectionString     End Using

User · Answer

If it s a  mdf database and the connection string was saved when it was created  you should be able to access it via       Dim cn As SqlConnection   New SqlConnection My Settings DatabaseNameConnectionString    Hope that helps someone

[vb.net] VB.NET Connection string (Web.Config, App.Config)

Examples related to vb.net

Examples related to connection-string