Difficulty in changing the Connection Server control path changing ...

[Samridhi Kumar Shukla]

I am facing technical difficulti in using server connection control because
we cannot change the path once fixed ..
one way is to edit the code of the form generated code but though it allow
to manipulate but again when i open the project one day latter the
connection string
cn.connection string goes away i have again write this code. is there any
way out for this

[Alvin Bruney]

why don't you store the connection string in the web config file, then just
read the config file for the string using appsettings.config("stringname") i
believe is the syntax or something close to that. This is the preferred
method where security is not an issue so that changing connection string
information can be done in real time without rebuilding the application each
time.

--
Regards,
Alvin Bruney
Got Tidbits? Get it here
www.networkip.net/tidbits
"Samridhi Kumar Shukla" <ss*****@mrinfosys.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

I am facing technical difficulti in using server connection control because we cannot change the path once fixed ..
one way is to edit the code of the form generated code but though it allow
to manipulate but again when i open the project one day latter the
connection string
cn.connection string goes away i have again write this code. is there any
way out for this