2008中WEB.config及字符串

 <connectionStrings>

    <add name="DB2005_2"
    providerName="System.Data.SqlClient"
    connectionString="Data Source=.;Initial Catalog=Northwind;User ID=dbtester;Password=zhi;Trusted_Connection=False;Connect Timeout=30;Min Pool Size=16;Max Pool Size=100"/>

    <add name="DB2005_1"
    providerName="System.Data.SqlClient"
    connectionString="Server=.;Database=Northwind;User ID=dbtester;Password=zhi;Trusted_Connection=False;Connect Timeout=30;Min Pool Size=16;Max Pool Size=100"/>

    <add name="Northword2000"
    providerName="System.Data.SqlClient"
    connectionString="Initial Catalog=Northwind;User ID=dbtester;PassWord=zhi;Persist Security Info=false;Data Source=(local);Connect Timeout=30;Min Pool Size=16;Max Pool Size=100;"/>

    <add name="SQLExp"
       providerName="System.Data.SqlClient"
       connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\northwnd1.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"/>
   

    <add name="Oracle"
      connectionString="Data Source=TEST;User ID=sa;Password=sa;"
      providerName="System.Data.OracleClient" />

    <add name="oleconn"
       providerName="System.Data.OleDb"
       connectionString="Provider=Microsoft.Jet.OleDb.4.0;Data Source=|DataDirectory|northwind.mdb"/>

    <add name="MySql"
    providerName="MySql.Data.MySqlClient"
    connectionString="Server=172.29.131.27;Port=3311;DataBase=comctl;Persist Security Info=False;User ID=root;Password=123456;Allow Zero Datetime=true;" />

</connectionStrings>
    <system.data>
        <DbProviderFactories>
            <add name="MySQL Data Provider"
                 invariant="MySql.Data.MySqlClient"
                 description=".Net Framework Data Provider for MySQL"
                 type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version=5.2.5.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d"/>
        </DbProviderFactories>
    </system.data>
</configuration>

-------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------

using System.Data.SqlClient;
using System.Configuration;

/// <summary>
///Class1 的摘要说明
/// </summary>
public class Class1
{
 public Class1()
 {
  //
  //TODO: 在此处添加构造函数逻辑
        ////Persist Security Info如果数据库连接成功后不再需要连接的密码,建议False
        //string sql2000 = "Initial Catalog=Northwind;User ID=dbtester;PassWord=zhi;Persist Security Info=false;Data Source=(local);Connect Timeout=30;Min Pool Size=16;Max Pool Size=100;";
        //string sql2000 = "Initial Catalog=Northwind;User ID=sa;PassWord=5;Persist Security Info=false;Data Source=.";
        //string sql2000 = "Initial Catalog=Northwind;User ID=sa;PassWord=5;Persist Security Info=false;Data Source=newtime";
        string source = "server=(local);integrated security=SSPI;database=Northwind";
        string expressSource = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\northwnd.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
        //Integrated Security采用windows的集成身份验证,integraged   Security=SSPI;
        //Integrated Security=SSPI 这个表示以当前WINDOWS系统用户身去登录SQL SERVER服务器，如果SQL SERVER服务器不支持这种方式登录时，就会出错
        //表示你的连接安全验证方式,可用trusted_connection=yes取代 
       
        //Integrated Security 为 True。用户实例仅与集成安全性一起使用，带有用户名和密码的 SQL Server 用户不起作用。
        //
        string source3 = @"Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog= pubs;UserID=sa;Password=asdasd;";

        //(DBMSSOCN=TCP/IP instead of Named Pipes, at the end of the Data Source is the port to use (1433 is the default))
        //Standard Security:

        string source4 = "Data Source=Aron1;Initial Catalog= pubs;UserId=sa;Password=asdasd;"; 
        string source5 = "Server=Aron1;Database=pubs;UserID=sa;Password=asdasd;Trusted_Connection=False";
        //Trusted_Connection 'false' 当为 false 时，将在连接中指定用户 ID 和密码。当为 true 时，将使用当前的 Windows 帐户凭据进行身份验证。 
        //可识别的值为 true、false、yes、no 以及与 true 等效的 sspi（强烈推荐）。所以一定要设置Trusted_Connection=  false,以防被别人"登录"、"注入语句"等

        string source6 = "Data Source=Aron1;Initial Catalog=pubs;Integrated Security=SSPI;" ;
        string source7 = "Server=Aron1;Database=pubs;Trusted_Connection=True;"; 
//(use serverName\instanceName as Data Source to use an specifik SQLServer instance, only SQLServer2000)
        //Integrated   Security或Trusted_Connection   'false'   当为   false   时，
        //将在连接中指定用户   ID   和密码。当为   true   时，将使用当前的   Windows   帐户凭据进行身份验证

      
        //VS2003：string connStr=System.Configuration.ConfigurationSettings.AppSettings["SQLCONNECTIONSTRING"];2003中用的
        //VS2005：string connStr=System.Configuration.ConfigurationManager.ConnectionStrings["SQLCONNECTIONSTRING"].ToString();2005－8中用
        System.Configuration.ConnectionStringSettings i = System.Configuration.ConfigurationManager.ConnectionStrings["Northword2000"];
      

 }
}

---------------------------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------------------------