我是这样的:
在web.config中
<appSettings>
<add key="connectionstring" value="server=dbserver\commerce;database=powersoft.com;uid=sa;password=admin" />
</appSettings>
在程序中:
Dim Conn As SqlClient.SqlConnection = New SqlClient.SqlConnection(ConfigurationSettings.AppSettings("ConnectionString"))
在web.config中
<appSettings>
<add key="connectionstring" value="server=dbserver\commerce;database=powersoft.com;uid=sa;password=admin" />
</appSettings>
在程序中:
Dim Conn As SqlClient.SqlConnection = New SqlClient.SqlConnection(ConfigurationSettings.AppSettings("ConnectionString"))
<!-- 应用程序配置 -->
<appSettings>
<add key="strConn" value="server=.;database=Realty;uid=sa;pwd=54321;Max Pool Size=20"/>
</appSettings>
[注] Max Pool 连接池实例数量 连接池将会自动生成.
<startup>
<requiredRuntime version="v1.0.3705" safemode="true"/>
</startup></configuration> /*-----------------------------------------------------*/
/*## 编号:02 ##*/
/// <summary>
/// 提供1个"已经打开的"数据库连接对象
/// </summary>
/// <returns>SqlConnection型数据库连接对象</returns>
public static SqlConnection GetConn()
{
string strConn = System.Configuration.ConfigurationSettings.AppSettings["strConn"]; SqlConnection conn = new SqlConnection(strConn); try
{
conn.Open();
}
catch
{
conn = null;
} return conn;
}
每次一个数据库连接用完后立即关闭 Close();
这样就不会有问题.
请从 web.config 中取得连接.加密STRING 更好.