How to use the ConfigurationManager AppSettings

Question

I ve never used the  appSettings  before  How do you configure this in C  to use with a SqlConnection  this is what I use for the  ConnectionStrings   SqlConnection con   new SqlConnection    con ConnectionString   ConfigurationManager ConnectionStrings  ConnectionString   ConnectionString    And this is what I have for the  appSettings   SqlConnection con   new SqlConnection    con   ConfigurationManager AppSettings  ConnectionString      but it is not working

User · Answer

you should use     var x   ConfigurationManager AppSettings  APIKey

User · Answer

if what you have posted is exactly what you are using then your problem is a bit obvious  Now assuming in your web config you have you connection string defined like this    lt add name  SiteSqlServer  connectionString  Data Source  local  Initial Catalog some db User ID sa Password uvx8Pytec  providerName  System Data SqlClient    gt    In your code you should use the value in the name attribute to refer to the connection string you want  you could actually define several connection strings to different databases   so you would have   con ConnectionString   ConfigurationManager ConnectionStrings  SiteSqlServer   ConnectionString

User · Answer

Your web config file should have this structure    lt configuration gt       lt connectionStrings gt           lt add name  MyConnectionString  connectionString         gt       lt  connectionStrings gt   lt  configuration gt    Then  to create a SQL connection using the connection string named MyConnectionString   SqlConnection con   new SqlConnection ConfigurationManager ConnectionStrings  MyConnectionString   ConnectionString     If you d prefer to keep your connection strings in the AppSettings section of your configuration file  it would look like this    lt configuration gt       lt appSettings gt           lt add key  MyConnectionString  value         gt       lt  appSettings gt   lt  configuration gt    And then your SqlConnection constructor would look like this   SqlConnection con   new SqlConnection ConfigurationManager AppSettings  MyConnectionString

User · Answer

ConfigurationManager AppSettings is actually a property  so you need to use square brackets   Overall  here s what you need to do   SqlConnection con  new SqlConnection ConfigurationManager AppSettings  ConnectionString       The problem is that you tried to set con to a string  which is not correct  You have to either pass it to the constructor or set con ConnectionString property

[c#] How to use the ConfigurationManager.AppSettings

Examples related to c#

Examples related to asp.net

Examples related to sql

Examples related to sqlconnection