<appsettings> - ASP.NET General

[Kenneth]

Hi,

In web.config I have an appsettings:

<appSettings>
<add key="constring"
value="Server=localhost;UID=sa;PWD=secret;Database =myDB" />
</appSettings>

This is for my developing machine.

Every time I deploy this web.config to the production
server I forget to change the UID and PWD which are
different on this machine.

Is there a way to write some code that detects which
server you're on so the server picks the right UID and PW`?

/Kenneth

[Teemu]

Of course you can't put running code into the web.config. That wasn't what I
mentioned.

Point really was that you'd put machinenames into <appSettings> as keys (or
as part of keys say "connectionString_MACHINENAME") for connection strings
and then by using Environment.MachineName your code solves in which machine
it is running and picks the correct config setting ("connectionString_" &
Environment.MachineName)

--
Teemu Keiski
MCP,Designer/Developer
Mansoft tietotekniikka Oy
http://www.mansoft.fi

AspInsiders Member, www.aspinsiders.com
ASP.NET Forums Moderator, www.asp.net
AspAlliance Columnist, www.aspalliance.com


"Kenneth" <se> kirjoitti viestissä
news:095f01c366ec$67b9f120$gbl...
Kiitos paljon Teemu for a fast reply,

Environment.MachineName can't be used in web.config, only
in code in aspx doc.

If you have to test new things in web.config and test it
in dev machine then you'll end upp with a mess if you have
to rewrite it.

/Kenneth
 
name of the machine. 
respectively) based on 
production machine once [/ref]
value="Server=localhost;UID=sa;PWD=secret;Database =myDB" /> [/ref]
PW`? 
>
>
>.
>[/ref]

[John]

"Kenneth" <se> wrote in message
news:08f501c366e9$16a21540$gbl... 

Kenneth,

You can do the following in web.config:

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<appSettings file="user.config">
<add key="Key" value="Value" />
</appSettings>
</configuration>

Then, in a file called user.config in the same folder as web.config, you can
put the following (notice there's no "<configuration>" tag):

<?xml version="1.0" encoding="utf-8" ?>
<appSettings>
<add key="Key" value="Override value" />
</appSettings>

If there is no user.config in the same folder, then the web.config settings
are used.

--
John Saunders
Internet Engineer
com