A。用有密码的方式:
<connectionStrings>
<add name="ConnectionString" connectionString="server=服务器地址; user=用户名;pwd=密码;database=数据库名称"/>
</connectionStrings>
在程序中读取,
1,引用命名空间:using System.Configuration;
2,获取方法
public string connectionstring = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();
<configuration>
<appSettings>
<add key="SQLConnectionString" value="server=服务器地址;database=数据库名;User Id=用户名;Pwd=密码"/>
B.用WINDOWS帐号登录方式:
<add name="cmsConnectionString" connectionString="Data Source=.;Initial Catalog=数据库名;Integrated Security=True" providerName="System.Data.SqlClient" />