Web.config Connection String Access and SQL2005 With AppSettings

<appSettings>
<add key="DatabaseUse" value="DatabaseAccess"/>
<add key="SecretKey" value="xxx"/>
</appSettings>

<connectionStrings>
<add name="DatabaseAccess" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|Database.mdb;Jet OLEDB:Database Password='';" providerName ="System.Data.OleDb"/>
<add name="DatabaseSQL2005" connectionString="Data Source=localhost\SQLEXPRESS;Initial Catalog=DatabaseSql;User ID=sa;pwd=dbms;" providerName ="System.Data.SqlClient"/>
</connectionStrings>

เวลาเรียกใ้ช้

string connStr = ConfigurationManager.ConnectionStrings["DatabaseAccess"].ConnectionString;
string connSQL = ConfigurationManager.ConnectionStrings["DatabaseSQL2005"].ConnectionString;

หรือเรียกจาก AppSettings
ConfigurationSettings.AppSettings["DatabaseUse"]