Connection String WOES

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

Quote:

---

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.

in web.config in the configuration element

Code:

---

        <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()

I was to lazy to post a sample. Thanks Cander

cool, thanks

Quote:

---

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

Code:

---

        <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 :

Code:

---

<configuration>
 
  <system.web>

---

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

I did that and tget this error:

Code:

---

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>

---

you didnt close the <add element

put /> on the end

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

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

You have always been helpful! Thanks :)

Your welcome. :D