在web.config中增加 <appSettings> <add key="BaseDBConn" alue="server=127.0.0.1;database=DBName;uid=sa;pwd=pwd" /> </appSettings> 程序中 using System.Configuration; private SqlConnection con; if (con == null ) { con = new SqlConnection(ConfigurationSettings.AppSettings["BaseDBConn"]); con.Open(); }
using System.Data.SqlClient;的命名空间和用不用provider没有关系呀,应该是SqlConnection对象的连接字符串属性好象简单点,差不多就是“server=127.0.0.1;database=DBName;uid=sa;pwd=pwd” 连接字符串不用记,用的时候直接生成一个连接对象,拷贝下就可以了
<appSettings>
<add key="BaseDBConn" alue="server=127.0.0.1;database=DBName;uid=sa;pwd=pwd" />
</appSettings>
程序中
using System.Configuration;
private SqlConnection con;
if (con == null )
{
con = new SqlConnection(ConfigurationSettings.AppSettings["BaseDBConn"]);
con.Open();
}
<add key="BaseDBConn" alue="server=127.0.0.1;database=DBName;uid=sa;pwd=pwd" />
</appSettings>
fellowcheng(浮云一小朵)
-------------------------------
同楼上想法,向导生成一个数据库连接,拷贝连接字符串
http://www.connectionstrings.com/
http://community.csdn.net//Expert/TopicView2.asp?id=4537158&datebasetype=now
http://blog.csdn.net/quou2002/archive/2005/12/21/558494.aspx====
~~~~ 我的Blog:http://blog.csdn.net/quou2002