Set the db dynamically in web.config

[kandalu]

Hi, I am using .net 2.0. I want to connect the db dynamically using web.config. I have to pass the db name only at runtime. The server name, uid, password are static in web.config. Please help me to implement this. Thanks.

[Abhijit Jana]

Try to use System.Web.Configuration NameSpace There is a class WebConfigurationManager .This class allow you to accss web.config programmaticaly. For Every Section in web.config there is a Class in this namespce, like For AppSettingsSection there is a class AppSettingsSection, Similary for ConnectionString There is a Class ConnectionStringSection. You can retreive information by WebConfigurationManager.GetSection() . Now try to explore this area what ever i mention and try to implement. if you have anmy issue then ask me !!! Good luck :)

cheers, Abhijit Read My Latest Article : Exploring Caching In Asp.net

[kandalu]

Hi, I want to change the db according to the current month. I come to know that changing db in web.config at run time will restart the entire application. So, I used Global.asax to store the connection settings and i got it. Thanks for your reply.