PasswordEncryption

[NagamaniShastry]

Hi,

This is Nagamani. I have to encrypt the password in the connection string while connecting to SQL Server 2005 Database.And later I have to decrypt. I am using C#.net with Visual Studio 2008.


Please help me on this.

[PRR]

You should look into System.Security.Cryptography namespace...

using System.Web.Configuration;
Configuration config = WebConfigurationManager.
        OpenWebConfiguration("~");
 
        // Get the connectionStrings section.
        ConnectionStringsSection constr =
            config.GetSection("connectionStrings")
            as ConnectionStringsSection;
 
        if (constr != null)
        {
            if (constr.SectionInformation.IsProtected)
            {
                constr.SectionInformation.UnprotectSection();
            }
            Label1.Text = string.Empty+ constr.ConnectionStrings[0].ToString();
 
            string ss = constr.ConnectionStrings[0].ToString();
 
 
        }
 
 
        {
 
            constr.SectionInformation.ProtectSection(
                "DataProtectionConfigurationProvider");
//RsaProtectedConfigurationProvider
 
            constr.SectionInformation.ForceSave = true;
 
            config.Save(ConfigurationSaveMode.Full);
 
        }
 

[r035198x]

1) Web application or desktop application?
2.) Where does the password come from?
3.) For a simple DES check out the System.Security.Cryptography name space. You can find examples of how to use it all over internet.

Edit: Looks like DeepBlue's keyboard is faster than mine.

[PRR]

Take a look at this RsaProtectedConfigurationProvider

r035198x,
"Edit: Looks like DeepBlue's keyboard is faster than mine."
lol.. well not exactly ...

[r035198x]

@DeepBlue, do you by any chance know any chess?

[PRR]

@DeepBlue, do you by any chance know any chess?

i used to play... becoz of my name? "deepblue"? too horrible player though ...

[r035198x]

i used to play... becoz of my name? "deepblue"? too horrible player though ...

You are therefore are not worth challenging to a game.
I only play against very good players.

r035198x <------- Almost a grand master.

[PRR]

You are therefore are not worth challenging to a game.
I only play against very good players.

r035198x <------- Almost a grand master.

hmm perhaps i could learn from you....

[r035198x]

Most of my opponents ended up on their knees begging for mercy.

http://bytes.com/forum/thread578342-chess.html

[PRR]

Most of my opponents ended up on their knees begging for mercy.

http://bytes.com/forum/thread578342-chess.html

you are too ... way too good for me ....