Connection String WOES

[jesus4u]

Something that I need advise on how to make more efficient is this:

When you drag and drop the design time sqlDataAdapter on let's say 10 aspx pages, .NET creates a separate connection string in the code behind for each page. Problem is when I have to move onto a production server I then need to go to each page and manually change the connection string. IT would be nice if .NET would offer a centralized class for the connection strings.

What do you suggest I do?

Thanks

[Lethal]

Originally posted by jesus4u
IT would be nice if .NET would offer a centralized class for the connection strings.

They do, check out the web.config file. You can store your connection string in there, as well as any other string data.

[Cander]

in web.config in the configuration element


<appSettings>
<add key="SQLConn" value="Initial Catalog=BRS;Integrated Security=SSPI;Data Source=(local);user id=Cander;password=*****"
<add key="Watchdir" value="c:\watchdir"/>
</appSettings>


You can get the value whenever you need it:

System.Configuration.ConfigurationSettings.AppSettings("SQLConn").ToString()

[Lethal]

I was to lazy to post a sample. Thanks Cander

[jesus4u]

cool, thanks

[jesus4u]

Originally posted by Cander
in web.config in the configuration element


<appSettings>
<add key="SQLConn" value="Initial Catalog=BRS;Integrated Security=SSPI;Data Source=(local);user id=Cander;password=*****"
<add key="Watchdir" value="c:\watchdir"/>
</appSettings>


You can get the value whenever you need it:

System.Configuration.ConfigurationSettings.AppSettings("SQLConn").ToString()

Where exactly do I place it? Under :


<configuration>

<system.web>

[Cander]

inside the <configuration> one but outside the <system.web> one

[jesus4u]

I did that and tget this error:


Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: This is an unexpected token. Expected 'NAME'. Line 6, position 2.

Source Error:


Line 4: <appSettings>
Line 5: <add key="SQLConn" value="data source=X-2000;initial catalog=Intranet;integrated security=SSPI;persist security info=False;workstation id=X-2000;packet size=4096"
Line 6: </appSettings>
Line 7:
Line 8: <system.web>

[Cander]

you didnt close the <add element

put /> on the end

[jesus4u]

duh :rolleyes: :rolleyes: :rolleyes: :rolleyes:

[Cander]

Dont worry over it. I did the exact same thing the first time I used that stuff and spent 3 hours trying to figure out what theheck was going on.:D

[jesus4u]

You have always been helpful! Thanks :)

[Cander]

Your welcome. :D