C#将数据库连接方式写到配置文件中

1. asp.net 项目配置文件：Web.config；winfrom项目配置文件：App.config
   写入下面代码
   根据需要自行选择本地或者sa账户
   （1）方法一：

<configuration>
 <!--数据库连接-本地-->
 <!--<connectionStrings>
    <add name="connectionString"
         connectionString="server=.;Initial Catalog=ss;Integrated Security=True"
         providerName="System.Data.SqlClient"/>
  </connectionStrings>-->
  
  <!--数据库连接-sa-->
  <connectionStrings>
    <!--数据库  jjq_connStr_SQL Server-->
    <add name="ConnectionString"
         connectionString="Data Source=10.xx.xx.xx;Initial Catalog=D_xx;User ID=sa;Password=sa;"
         providerName="System.Data.SqlClient" />
  </connectionStrings>
</configuration>

（2）方法二：

<configuration>
  <appSettings>
    <!--配置数据库连接-->
    <!--数据库1-->  
    <add key="DBConnectionString1" value="Data Source=1.3.1.1;Initial Catalog=total;Persist Security Info=True;User ID=SC;Password=SCQSMPTD;MultipleActiveResultSets=true" />
    <!--数据库2-->
    <add key="DBConnectionString2" value="Data Source=1.3.1.3;Initial Catalog=SMT_PCP;Persist Security Info=True;User ID=micro;Password=micro;MultipleActiveResultSets=true" />
    <!--数据库3-->
    <add key="OraConn"
         value="Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=1.3.1.22)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=PACK)));User Id=e_re;Password=yhong;"/>   
  </appSettings>
</configuration>

2.cs代码中：

 using System.Configuration;//引用
 private static string constr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; //方法一
       //方法二：
       //数据库1
        public static string DBConnectionString1 = ConfigurationManager.AppSettings["DBConnectionString1"];
        //数据库2
        public static string DBConnectionString2 = ConfigurationManager.AppSettings["DBConnectionString2"];
        //Qracle数据库操作
        public static string QracleSring = ConfigurationManager.AppSettings["OraConn"];

数据库连接的其他方式