Encrypt & Decrypt ConnectionString Section

Encrypt & Decrypt ConnectionString Section

Sometimes we need to secure ConnectionString to prevent anyone can knows it. whatever your purpose from securing ConnectionString, there is a way to Encrypt and Decrypt ConnectionString by special codes as we will see now...

In the Web.Config file we found <connectionStrings> section that enable us to add ConnectionStrings

<connectionStrings>

  <add name="ConnectionString" connectionString="Provider=SQLNCLI10.1;Data 

Source=My-pc\sqlexpress;Integrated Security=SSPI;Initial Catalog=Northwind"

   providerName="System.Data.OleDb" />

 </connectionStrings>

Now we have to go to see how can we Encrypt and Decrypt ConnectionStrings don't foreget add System.Web.Configuration name space

 protected void Encryption(bool EncryptoValue)

    {

        Configuration config = WebConfigurationManager.OpenWebConfiguration("~");

        ConfigurationSection sec = config.GetSection("connectionStrings");

        if (EncryptoValue == true)

        {

            sec.SectionInformation.ProtectSection("DataProtectionConfigurationProvider");

        }

        else

        {

            sec.SectionInformation.UnprotectSection();

        }

        config.Save();

    }

    protected void Button1_Click(object sender, EventArgs e)

    {

        Encryption(true);

    }

    protected void Button2_Click(object sender, EventArgs e)

    {

        Encryption(false);

    }

You can test that now hope that useful