65.9K
CodeProject is changing. Read more.
Home

Programatically update connectionstring using C#

emptyStarIconemptyStarIconemptyStarIconemptyStarIconemptyStarIcon

0/5 (0 vote)

Nov 15, 2011

CPOL
viewsIcon

11400

var configuration = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration("~");var section = (System.Configuration.ConnectionStringsSection)configuration.GetSection("connectionStrings");section.ConnectionStrings["MySqlConnection"].ConnectionString = "Data Source=" + ...

var configuration = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration("~");
var section = (System.Configuration.ConnectionStringsSection)configuration.GetSection("connectionStrings");

section.ConnectionStrings["MySqlConnection"].ConnectionString = "Data Source=" + 
        txtserver.Text + ";Initial Catalog=" + txtdatabase.Text + ";User ID=" + txtuid.Text + 
        ";Password=" + txtpwd.Text;
configuration.Save();