你要有app.config的文件
web的项目是web.config里面的内容是这样的
他可以取得ConnectionStrings
和appSettings.<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<connectionStrings>
<add name ="" connectionString=""/>
</connectionStrings>
<appSettings>
<add key ="" value=""/>
</appSettings>
web的项目是web.config里面的内容是这样的
他可以取得ConnectionStrings
和appSettings.<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<connectionStrings>
<add name ="" connectionString=""/>
</connectionStrings>
<appSettings>
<add key ="" value=""/>
</appSettings>
<connectionStrings>
<add name="SQL" providerName="System.Data.SqlClient" connectionString="server=(local);integrated security=SSPI;database=linyuan"/>
</connectionStrings>
using System.Configuration;
这个饮用需要右键工程 添加饮用
如果你都设置好了
那么你取得这样取得就可以 按照你的配置文件
ConfigurationManager.ConnectionStrings["SQL"];
是为了
DbProviderFactory factory = DbProviderFactories.GetFactory(s.ProviderName);不是要获取SqlConnection,来点有建设性的好不好
dbFactory = DbProviderFactories.GetFactory("System.Data.OleDb"); DbConnection conn = dbFactory.CreateConnection();
别告诉我不成。<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<connectionStrings>
<add name="Access" providerName="System.Data.OleDb" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|Northwind.mdb"/>
<add name="SqlExpress" providerName="System.Data.SqlClient" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;Database=Northwind;AttachDBFilename=|DataDirectory|Northwind.mdf"/>
</connectionStrings>
<appSettings>
<add key="Connection" value="Access"/>
</appSettings>
</configuration>
Web.config
<configuration>
<appSettings>
<add key="ConnectionString" value="server=.;database=Northwind;uid=sa;pwd=;"/>
</appSettings>
</configuration>