1.Access
<appSettings>
<add key="ACCESSCONNECTIONSTRING" value="Provider = Microsoft.Jet.OLEDB.4.0;Data Source="> </add>
</appSettings>
...
using System.Configuration;
using System.Data.OleDb;
...
private readonly string ACCESSCONNECTIONSTRING = ConfigurationSettings.AppSettings[ " ACCESSCONNECTIONSTRING " ].ToString();
.....
string accessString = ACCESSCONNECTIONSTRING + Server.MapPath( " PowerEasy5.mdb " );
OleDbConnection accessConn = new OleDbConnection(accessString);
using System.Configuration;
using System.Data.OleDb;
...
private readonly string ACCESSCONNECTIONSTRING = ConfigurationSettings.AppSettings[ " ACCESSCONNECTIONSTRING " ].ToString();
.....
string accessString = ACCESSCONNECTIONSTRING + Server.MapPath( " PowerEasy5.mdb " );
OleDbConnection accessConn = new OleDbConnection(accessString);
2.SQL
<appSettings>
add key="SQLCONNECTIONSTRING" value="data source=127.0.0.1;uid=sa;pwd=final_2008;database=Northwind"></add>
</appSettings>
using
System.Configuration;
using System.Data.SqlClient;
private readonly string SQLCONNECTIONSTRING = ConfigurationSettings.AppSettings[ " SQLCONNECTIONSTRING " ].ToString();
SqlConnection Conn = new SqlConnection(SQLCONNECTIONSTRING);
using System.Data.SqlClient;
private readonly string SQLCONNECTIONSTRING = ConfigurationSettings.AppSettings[ " SQLCONNECTIONSTRING " ].ToString();
SqlConnection Conn = new SqlConnection(SQLCONNECTIONSTRING);