What are the Good Steps to be followed for maintaining Connection Strings in Asp.Net Web Applications ?

Answer:

There are some basic steps which should be followed inorder maintain Connection strings more efficiently they are

. Connection strings should allways be given in web.config file itself for security resons. Not only for security but also as more accessible at multiple places.

. We should never make connection strings as Declarative property for SqlDataSource control

. Allways Connection strings should be stored in an Encrypted format for secure Database server .

. Do not store it in a plain text format and also never store it in a .aspx page.