how to add new connection string in web.config run time programatically in asp.net?

Question

I am working on construction ERP. When user adds new structure i have to create new database for each structure.Whether it is possible using script?

at the same time as i am creating new database for each structure then it is necessary to create one additional connection string in web.config file

very first i am trying to add new connection string in config file.for that i have written some code.but it gives me error.

 string path = Server.MapPath(@"Web.config"); 'or' string path = Server.MapPath("~/Web.config");
        var configuration = WebConfigurationManager.OpenWebConfiguration(path);
        var section = (ConnectionStringsSection)configuration.GetSection("connectionStrings");
        section.ConnectionStrings.Add(new ConnectionStringSettings(txtStructName.Text, txtStructName.Text, "System.Data.SqlClient"));
        configuration.Save();

Error is :The relative virtual path is not allowed here.

help me to solve this problem.....

Be aware that the connections strings section is read only. See this for details stackoverflow.com/questions/360024/… — Mike Goodwin
– Mike Goodwin, Commented Oct 7, 2013 at 12:46
i want to add new connection string.not change in existing string. — user1838502
– user1838502, Commented Oct 8, 2013 at 10:16

Daniel A. White · Accepted Answer · 2013-10-07 12:35:15Z

2

You shouldn't need to specify web.config.

Just do

WebConfigurationManager.OpenWebConfiguration("~");

answered Oct 7, 2013 at 12:35

Daniel A. White

192k49 gold badges389 silver badges473 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

user1838502 Over a year ago

i have try for it but "An error occurred loading a configuration file: Failed to map the path '/'." is the error.....

Daniel A. White Over a year ago

@user1838502 is iis configured for that directory to be an application?

user1838502 Over a year ago

An error occurred loading a configuration file: Failed to map the path '/'.

Daniel A. White Over a year ago

@user1838502 make sure you have an application configured in iis.

Collectives™ on Stack Overflow

how to add new connection string in web.config run time programatically in asp.net?

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related