difference between two connection strings?

Question

what is the difference between the below connection strins?

1. cn.ConnectionString = ConfigurationManager.AppSettings["CnnStr"].ToString();

2. cn.ConnectionString = ConfigurationManager.Connectionstring["CnnStr"].ToString();

Pankaj Pandey · Answer

hii in your config file there are two keywords AppSettin and ConnectionString. MS define the Connectionstring for connect with ado.net with specified parameter but many times we use appsetting. Appsetting also do same task it store value but it is not a good practice always use connectionstring for connectivity and appstring for storing the other data.

Sanjeeb Lenka · Answer

The main difference is in appsettings section we can store any data string values including database connection strings also but in connectionStrings section only database connection strings can store those are our application connection strings and new features (Membership Personalization and Role Manager) connection strings only. for more detail check this link http://www.aspdotnet-suresh.com/2012/10/aspnet-difference-between-appsettings.html

Iftikar Hussain · Answer

Hi 1. ConfigurationManager.AppSettings[CnnStr].ToString() will read app setting value i.e. from 2. ConfigurationManager.Connectionstring[CnnStr].ToString() will read value from connectionStrings block of web.config The connectionStrings element specifies a collection of database connection strings as name/value pairs for ASP.NET applications and features. In previous versions of ASP.NET connection strings were stored in the appSettings. In ASP.NET 2.0 features such as Session Membership Personalization and Role Manager rely on connection strings that are stored in the connectionStrings element. You can also use the connectionStrings element to store connection strings for your own applications. Regards Iftikar

Abhineet Srivastava · Answer

In Connection string sectionwe can only store database connection. OtherhandAppSetting is used to store different data like website nameadmin email etc in Web.config

Ravi Shekhar · Answer

Hi ConfigurationManager.AppSettings[CnnStr].ToString() called your connectionstring from Appsetting file. ConfigurationManager.Connectionstring[CnnStr].ToString() called your connectionstring from web config file.