Is it possible to insert a connection string into a web.config file at runtime, if it isn't there? Would this work?
The connection string is for a ASP.NET user login and create account database.
-
Do you want to manually or programatically add the connection string?LittleBobbyTables - Au Revoir– LittleBobbyTables - Au Revoir2010-08-05 16:08:30 +00:00Commented Aug 5, 2010 at 16:08
-
The solution I provided is what you're looking for. I added further explanation for your convenience :)Eton B.– Eton B.2010-08-05 16:37:50 +00:00Commented Aug 5, 2010 at 16:37
Add a comment
|
3 Answers
How do you mean "insert?" If you mean can you manually edit web.config: yes, you can. You'd add an entry for connectionStrings (if there wasn't one) an then a child node for your specific connectionString.
If you mean can you do it in code: theoretically yes. However, it is normally bad practice, and a pain the rear.
1 Comment
AndreasKnudsen
If you needed to be able to switch connectionstring at runtime you could chuck it into a database instead of web.config
Yes it is very possible:
<connectionStrings>
<add name="yourNameHere" connectionString="connectiongStringHere" providerName="nameHere"/>
</connectionStrings>
inside ConfigSections
2 Comments
Put a default connectionstring in your web.config and replace the username/password and database name at runtime as desired.
