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.