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();
这是几种方法选择其中一种就行。