读书人

.net2005 webconfig中调用数据库连接串

发布时间: 2012-03-07 09:13:51 作者: rapoo

.net2005 webconfig中调用数据库连接串问题?
.net2005 webconfig代码如下:
<configuration>
<appSettings/>
<connectionStrings>
<add name= "qkgj_webConnectionString " connectionString= "Data Source=.;Initial Catalog=qkgj_web;User ID=sa;Password=sa "
providerName= "System.Data.SqlClient " />
</connectionStrings>

在程序中如何调用数据库连接串?大家帮帮忙 谢谢了

[解决办法]
protected SqlConnection GetConnetcion ()
{
string ConnectionString = ConfigurationManager.ConnectionStrings[ "qkgj_webConnectionString "].ToString();

SqlConnection Connection = null;
try
{
Connection = new SqlConnection(ConnectionString);
Connection.Open();
}
catch (Exception ex)
{
}
return Connection;
}

读书人网 >asp.net

热点推荐