Hi Friends,

I have created two functions that encrypt and decrypt the connection string in web.config. But whenever I want to use connection string. I have to always decrypt web.config and then again encrypt it back. Does there any other way which i can use.

I'm using section.SectionInformation.ProtectSection(" <encryption configuration provider> ") and section.SectionInformation.UnprotectSection()

Why do you want to encrypt / decrypt your connection string?

Is the web.config public?

I am using .NET with a Sql-Server as backend in windows authentication mode, so no password is required.

If you really need this encryption: Decrypt the connection string in the Global.asax and store it in the application object:

Application("connectionstring-decrypted") = yourDecryptFunction(Input)

and use it:

Dim conn As New Connection(CType(Application("connectionstring-decrypted"), String))