We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

System.Configuration.ConfigurationSettings.AppSettings("PubsString")

hanneman
hanneman asked
on
Medium Priority
880 Views
Last Modified: 2012-06-21
Hello,
I am proficient in ASP and Cold Fusion, but I am very new to .net and am doing the quickstart tutorials on www.asp.net (can anyone recommend a better tutorial?) and I am now doing intro8.aspx.

I notice that the example uses:
SqlConnection(System.Configuration.ConfigurationSettings.AppSettings("PubsString"))

I can connect to a DB by putting in a connection string, but keeping the connection string in one place is much better, I presume that is what this line does?
How do I set this property?

I am using webmatrix.

Thanks
Comment
Watch Question

The line System.Configuration.ConfigurationSettings.AppSettings("PubsString") means that you have stored somehting in the config file or your application (web.config for a web project or app.config for a windows app).
To add such a file, right lcik on your project and Add New Item --> Application Configuration file.

Then you need to add the tags <appSettings> between the <configuration> one and add your key !

<configuration>
  <appSettings file="Server_FO.config">
    <add key="PubsString" value="You connection String here"></add>
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Oops ... looks like we were answering at the same time!!
:-)
Two seconds quicker ;-)
Jarodtweiss, will the entries listed in the web.config under the <appSettings> node be processed if you have specified an external file for storage? I didn't think that they would, but I could be wrong.
Yeah they will !
I am using :
<configuration>
  <appSettings file="myFile.xml">

In that case, .NET will :
1. Check in myFile.xml if the given key exist.
    If it is the case, you get that value
2. If the key doesn't exist, it will check in the "standard file" if it exists
    If it is the case, you get that value
3. Otherwise, you get String.Empty

For Hanneman, in that case, myFile.xml must have the following structure :
<?xml version="1.0" encoding="utf-8" ?>
  <appSettings>
  <appsettings>
So the "alternative file" will "override" the key of the main file

Author

Commented:
hey, i thought there used to be an option for assisted answers?
I was going to split the points because I used both your answers.

I used eric's code, and jarod gave me the method for adding a web.config file (i am that ignorant that i need that kind of info)

Thanks both of you.
-h
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.