How to retrieve specific connection string from App.Config file using C# (.NET)

Get specific connection string from App.Config file using C# (.NET)

The connection string can be retrieved from the App.Config file using ConnectionStrings method of ConfigurationManager. You need to add the following directive in the code:

using System.Configuration;

The ConnectionStrings method without any arguments will return a collection of Connection strings in the App.Config file. If you want to retrieve specific ones you can either pass an index or string to it

private static string retsettings(String sConnName)
        {
            try
            {
                ConnectionStringSettings sConnection = ConfigurationManager.ConnectionStrings[sConnName];
                return sConnection.ConnectionString;
            }
            catch (Exception ex1)
            {
                return null;
            }
            finally
            { }

            
        }