webconfig 配置连接数据库字符串

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);

 

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);