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

[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.

[jesus4u]

You have always been helpful! Thanks

[Cander]

Your welcome.