Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
 

Tip: Encrypting and Decrypting a Database Connection String

Learn to encrypt your connection string to a database


advertisement

You can encrypt your connection string to a database. Let me rephrase that: you should encrypt data connections. Here is an example of encrypting a connection string and decryprting a connection string.

Create the Connection String in your App.Config:

connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source???;DatabaseName;"
            providerName="System.Data.OleDb" /


Form Code:

private void EncryptConnectionString()
        {
            System.Configuration.Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
            string provider = "DataProtectionConfigurationProvider";
            ConfigurationSection connstrings = config.ConnectionStrings;
            connstrings.SectionInformation.ProtectSection(provider);
            connstrings.SectionInformation.ForceSave = true;
            config.Save(ConfigurationSaveMode.Full);
        }
        private void DecryptConnectionString()
        {
            System.Configuration.Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
            ConfigurationSection connstrings = config.ConnectionStrings;
            connstrings.SectionInformation.UnprotectSection();
            connstrings.SectionInformation.ForceSave = true;
            config.Save(ConfigurationSaveMode.Full);
        }
        private void EncryptButton_Click(object sender, EventArgs e)
        {
            EncryptConnectionString();
        }
        private void DecryptButton_Click(object sender, EventArgs e)
        {
            DecryptConnectionString();
        }

 

Visit the DevX Tip Bank

 



   
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date