Write Modify Web.Config Programmatically At Run Time

Write Modify Web.Config ConnectionString And AppSettings Programmatically At Run Time In Asp.Net

In this post I'm going to explain how to write or modify CnnectionStrings and AppSettings programmatically at run time in Web.Config file in Asp.Net.

To write or modify web.config programmatically we need to use ebConfigurationManager Class in System.Web.Configuration namespace.



We can add write or modify any section of web.config programmatically, here i m describing how to modify and write connectionStrings and AppSettings section of Web.Config file.

For this first of all add this namespace in code behind of page.

show source

1using System.Web.Configuration;

I have put two textbox on the page to display on Page Load and write new or modify existing connectionString in web.config file on Button Click Event.

HTML SOURCE OF PAGE

<form id="form1" runat="server">
<div>
<asp:TextBox ID="txtKey" runat="server">
</asp:TextBox>
<asp:TextBox ID="txtConnectionString" runat="server">
</asp:TextBox>
<asp:Button ID="btnWrite" runat="server" 
            onclick="btnWrite_Click" 
            Text="Modify/Write" />
</div>
</form>

Write below mentioned code in code behind of page to show existing connectionString in web.config on page Load.

C# CODE

show source

1protected void Page_Load(object sender, EventArgs e)

2    {

3        if (!IsPostBack)

4        {

5          txtConnectionString.Text = ConfigurationManager.ConnectionStrings[0].ConnectionString;

6 

7        }

8    }

VB.NET CODE

show source

1Protected Sub Page_Load(sender As Object, e As EventArgs)

2 If Not IsPostBack Then

3 

4  txtConnectionString.Text = ConfigurationManager.ConnectionStrings(0).ConnectionString

5 End If

6End Sub

To modify name of existing connection string in web.config programmatically write below mentioned code in Click Event of Button.

C# CODE

show source

1protected void btnWrite_Click(object sender, EventArgs e)

2    {

3        Configuration connectionConfiguration = WebConfigurationManager.OpenWebConfiguration("~");

4        connectionConfiguration.ConnectionStrings.ConnectionStrings["test"].Name = txtKey.Text;

5        connectionConfiguration.Save(ConfigurationSaveMode.Modified);

6        ConfigurationManager.RefreshSection("connectionStrings");

7    }

To modify value of existing connection string in web.config programmatically write below mentioned code in Click Event of Button.

C# CODE

show source

1protected void btnWrite_Click(object sender, EventArgs e)

2    {

3        Configuration connectionConfiguration = WebConfigurationManager.OpenWebConfiguration("~");

4        connectionConfiguration.ConnectionStrings.ConnectionStrings["test"].ConnectionString = txtConnectionString.Text;

5connectionConfiguration.Save(ConfigurationSaveMode.Modified);

6ConfigurationManager.RefreshSection("connectionStrings");

VB.NET CODE

show source

1Protected Sub btnWrite_Click(sender As Object, e As EventArgs)

2 Dim connectionConfiguration As Configuration = WebConfigurationManager.OpenWebConfiguration("~")

3 connectionConfiguration.ConnectionStrings.ConnectionStrings("test").Name = txtKey.Text

4 connectionConfiguration.ConnectionStrings.ConnectionStrings("test").ConnectionString = txtConnectionString.Text

5 connectionConfiguration.Save(ConfigurationSaveMode.Modified)

6 ConfigurationManager.RefreshSection("connectionStrings")

7End Sub

To add or write new name and value of connection string in web.config at run time write below mentioned code

C# CODE

show source

01protected void btnWrite_Click(object sender, EventArgs e)

02    {

03        Configuration connectionConfiguration = WebConfigurationManager.OpenWebConfiguration("~");

04 

05        ConnectionStringSettings csAddNewConString = new ConnectionStringSettings(txtKey.Text,txtConnectionString.Text ,"System.Data.SqlClient");

06 

07 ConnectionStringsSection csNewConSection = connectionConfiguration.ConnectionStrings;

08 

09 csNewConSection.ConnectionStrings.Add(csAddNewConString);

10 

11        connectionConfiguration.Save(ConfigurationSaveMode.Modified);

12 

13        ConfigurationManager.RefreshSection("connectionStrings");

14    }

VB.NET CODE

show source

01Protected Sub btnWrite_Click(sender As Object, e As EventArgs)

02 Dim connectionConfiguration As Configuration = WebConfigurationManager.OpenWebConfiguration("~")

03 

04 Dim csAddNewConString As New ConnectionStringSettings(txtKey.Text, txtConnectionString.Text, "System.Data.SqlClient")

05 

06 Dim csNewConSection As ConnectionStringsSection = connectionConfiguration.ConnectionStrings

07 

08 csNewConSection.ConnectionStrings.Add(csAddNewConString)

09 

10 connectionConfiguration.Save(ConfigurationSaveMode.Modified)

11 

12 ConfigurationManager.RefreshSection("connectionStrings")

13End Sub

To write or add new key and value of connectionstring in AppSettings Section of web.config we can write code as mentioned below.

C# CODE

show source

01protected void btnWrite_Click(object sender, EventArgs e)

02    {

03        Configuration connectionConfiguration = WebConfigurationManager.OpenWebConfiguration("~");

04 

05        connectionConfiguration.AppSettings.Settings.Add("writeAppSettingsString", txtConnectionString.Text);

06 

07        connectionConfiguration.Save(ConfigurationSaveMode.Modified);

08 

09        ConfigurationManager.RefreshSection("connectionStrings");

10    }

VB.NET CODE

show source

1Protected Sub btnWrite_Click(sender As Object, e As EventArgs)

2 Dim connectionConfiguration As Configuration = WebConfigurationManager.OpenWebConfiguration("~")

3 

4 connectionConfiguration.AppSettings.Settings.Add("writeAppSettingsString", txtConnectionString.Text)

5 

6 connectionConfiguration.Save(ConfigurationSaveMode.Modified)

7 

8 ConfigurationManager.RefreshSection("connectionStrings")

9End Sub

To remove any existing connection string in AppSettings we can use Remove() method

show source

1connectionConfiguration.AppSettings.Settings.Remove("writeAppSettingsString");

Hope this helps.

Tweet

If you like this post than join us or share