asp.net 连接数据库

  <appSettings>
    <add key="connect" value="Data source=127.0.0.1;initial catalog=master;user id=sa; password=sa"/>
  webconfig配置： 
 </appSettings>

  <connectionStrings>
    <add name="oneConnect" providerName="System.Date.Sqlclient" connectionString="sever=127.0.0.1;databse=master;uid=sa;pwd=sa;connect timeout=30" />
    <add name="twoConnect" providerName="System.Date.Sqlclient" connectionString="Data source=127.0.0.1;initial catalog=master;user id=sa; password=sa"  />

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

后台调用

      string conn = ConfigurationManager.ConnectionStrings["oneConnect"].ConnectionString.ToString();

        //string conn = ConfigurationManager.AppSettings["connect"].ToString();

这是几种方法选择其中一种就行。

 

转载于:https://www.cnblogs.com/langge/archive/2009/10/23/1588670.html