How to get SQL Connection String from App.Config / Web.Config using C#

TRAILER This may seems to be very hilarious to all ninja programmers but it possibly help starters and also save me the trouble to remember it !! MOTION PICTURE What would you do without a connection string when you wish to talk to a database from your application. Good practice – adding connection string in the app.config or web.config and use it wherever needed in application. This helps in changing connection string without changing (compiling or deploying) our code. How to define connection string: The configuration file has dedicated section for this purpose  called “connectionStrings”, where you can add multiple entries of connection strings you wish to configured for your application. The connection string element contains three elements: Name: Name for the connection string entry which can be used to reference that connection string. (Mandatory) ConnectionString: The connection string that contains the specification to make the connection to the underlying » Read more