Read Database Connection String from Web.config

Read Database Connection String from Web.config

1.Place the connection string in AppSetting the Web.Config File

<appSettings>

<add key="dbcon" value="Data Source=Ipaddress Or Hostname;

Initial Catalog=DatabaseName;User ID=sa;Password=password123;"/>

</appSettings>

Read the Connection String in the Code:

public static string dbconn = ConfigurationManager.AppSettings["dbcon"].ToString();

2.Place the connection string in connectionStrings in the Web.Config File
<connectionStrings>
<add name="ImageUploaded" connectionString="Data Source=10.200.2.28;Initial Catalog=CoolDB;User ID=sa;Password=123" providerName="System.Data.SqlClient" />
</connectionStrings>
Read the Connection String in the Code:

public static string CONN_STRING1 = ConfigurationManager.ConnectionStrings["ImageUploaded"].ConnectionString;