Read connection string from web config

Question

How can I read a connection string from a web config file into a public class contained within a class library   I ve tried   WebConfigurationManager  ConfigurationManager   But these classes are not recognized within my class library

User · Answer

using System  using System Collections Generic  using System Configuration  using System Data SqlClient  using System Drawing  using System Linq  using System Web  using System Web UI  using System Web UI DataVisualization Charting  using System Web UI WebControls      C       string constring   ConfigurationManager ConnectionStrings  ABCD   ConnectionString                  using  SqlConnection con   new SqlConnection constring     BELOW WEB CONFIG FILE CODE   lt connectionStrings gt       lt add name  ABCD  connectionString  Data Source DESKTOP-SU3NKUU MSSQLSERVER2016 Initial Catalog TESTKISWRMIP Integrated Security True  providerName  System Data SqlClient   gt     lt  connectionStrings gt    In the above Code ABCD is the Connection Name

User · Answer

C      Add a using directive at the top of your code file     using System Configuration      Within the code body set your variable     string cs   ConfigurationManager ConnectionStrings  connectionStringName   ConnectionString    VB    Add an Imports statement at the top of your code file     Imports System Configuration    Within the code body set your variable     Dim cs as String   ConfigurationManager ConnectionStrings  connectionStringName   ConnectionString

User · Answer

Add System Configuration as a reference   For some bizarre reason it s not included by default

User · Answer

In VB   This should work  ConfigurationManager ConnectionStrings  SQLServer   ConnectionString   In C  it would be  as per comment of Ala   ConfigurationManager ConnectionStrings  SQLServer   ConnectionString

User · Answer

I guess you need to add a reference to the System Configuration assembly if that have not already been added   Also  you may need to insert the following line at the top of your code file   using System Configuration

User · Answer

using System Configuration    string connString   ConfigurationManager ConnectionStrings  ConStringName   ToString      Remember don t Use ConnectionStrings index  because you might of Global machine Config and Portability

User · Answer

First add this   using System Configuration

User · Answer

You have to invoke this class on the top of your page or class    using System Configuration    Then you can use this Method that returns the connection string to be ready to passed to the sqlconnection object to continue your work as follows       private string ReturnConnectionString                   Put the name the Sqlconnection from WebConfig           return ConfigurationManager ConnectionStrings  DBWebConfigString   ConnectionString          Just to make a clear clarification this is the value in the web Config             lt add name  DBWebConfigString  connectionString           gt     lt  connectionStrings gt

User · Answer

Everybody seems to be suggesting that adding   using System Configuration    which is true   But might I suggest that you think about installing ReSharper s Visual Studio extension   With it installed  instead of seeing an error that a class isn t defined  you ll see a prompt that tells you which assembly it is in  asking you if you want it to add the needed using statement

User · Answer

using System Configuration    string conn   ConfigurationManager ConnectionStrings  ConStringName   ToString

User · Answer

Add System Configuration as a reference then    using System Configuration          string conn        ConfigurationManager ConnectionStrings  ConnectionName   ConnectionString

User · Answer

You need to add a reference to System Configuration and then use   System Configuration ConfigurationManager      ConnectionStrings  connectionStringName   ConnectionString

[c#] Read connection string from web.config

Examples related to c#

Examples related to .net

Examples related to asp.net

Examples related to web-config

Examples related to connection-string