一、app.config文件配置
<?xml version="1.0" encoding="utf-8" ?>< configuration>
< connectionStrings>
sqlserver身份认证
< add name=“messsqlserver” connectionString=“Data Source=127.0.0.1;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword ;Integrated Security=false” providerName=“System.Data.SqlClient”/>
windows身份认证
< add name=“messsqlserver” connectionString=“Data Source=127.0.0.1;Initial Catalog=CYYFCheckUPV5_HNTHYY;Integrated Security=true” providerName=“System.Data.SqlClient”/>
< /connectionStrings>
< /configuration>
二.app.config文件调用
1.添加System.configuration引用
2.读取配置文件中的值
private static readonly string constr = ConfigurationManager.ConnectionStrings[“messsqlserver”].ConnectionString;