edit web.config file

[Raghvendra Kumar Roy]

Hi all I have 5 databases.I want to connect them at runtime as the user's choice. is there any wayto edit web.config file at runtime to change connectionstring.it is very urgent plz reply me.

Raghvendra Kumar Roy

[Christian Graus]

Raghvendra Kumar Roy wrote:

it is very urgent

Of course it is.... You can add as many strings to your app config as you'd like. It would make more sense to store all the strings in your app config and add the functionality to select between them.

Christian Graus - Microsoft MVP - C++ "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

[Raghvendra Kumar Roy]

What i can do if i have to create anew connection string

Raghvendra Kumar Roy

[Christian Graus]

Try putting them all in an XML file, and then you can access it from your app. I didn't realise your web app would have a constantly changing list of connections, that seems unusual.

Christian Graus - Microsoft MVP - C++ "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

[Paddy Boyd]

You shouldn't have your system edit the web.config at runtime. Changing the web.config will cause the app domain to recycle - I imagine this could potentially cause you a few problems...

[Vasudevan Deepak Kumar]

Raghvendra Kumar Roy wrote:

edit web.config file at runtime

High risk. Application restarts when web.config is updated. Not recommended.

Vasudevan Deepak Kumar Personal Homepage Tech Gossips