Web.config中的设置:
<
appSettings
>
<
add
key
=
"ConnNew"value=".;uid=sa;pwd=123;database=GlassOffice"/>
</
appSettings
>
<
connectionStrings
>
<
add
name
=
"ConnKu"connectionString="Data Source=.;Initial Catalog=tongjinet;User ID=sa;Password=123"providerName="System.Data.SqlClient"/>
</
connectionStrings
>
App_Code中的connsql.cs中的设置:
using
System.Data.SqlClient;
public
class connsql
{
public connsql()
{
//
// TODO:
在此处添加构造函数逻辑
//
}
public static SqlConnection CreateConnection()
{
return new SqlConnection(ConfigurationManager.ConnectionStrings["ConnKu"].ToString());
}
public static SqlConnection CreateConnection2()
{
return
new SqlConnection("server=" + ConfigurationSettings.AppSettings["ConnNew"].ToString());
}
}
Default.asp.cs中的设置:
SqlConnection conn = connsql.CreateConnection();
SqlConnection
conn2 = connsql.CreateConnection2();
注:这样就可以同时访问不同的数据库了。