1.webconfig文件内连接数据库方式1
<connectionStrings>
<add name="ConnectionString" connectionString="Data Source=数据库所在的ip地址;Initial Catalog=数据库名称;Persist Security Info=True;User ID=用户名;Password=密码;Connect Timeout=2;" providerName="System.Data.SqlClient"/>
</connectionStrings>
在程序端调用ConnectionString,
using System.Configuration;
string connstr = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
2.webconfig内数据库连接还有如下方式,以及定义变量
<configration>
<appSettings>
<add key="connString1" value="server=localhost;user id=sa;pwd=;database=数据库名字"/> //连接数据库的方式2
<add key="connString2" value="provider=Microsoft.Jet.OleDb.4.0;Da
<add key="bl" value="123456"/>
</appSettings>
<system.web>
</system.web>
</configration>
在程序端调用ConnectionString,
using System.Configuration;
string conn1 = System.Configuration.ConfigurationManager.AppSettings["connString1"];
string conn2 = System.Configuration.ConfigurationManager.AppSettings["connString2"];
string str=System.Configuration.ConfigurationManager.AppSettings["bl"];