在ASP.NET开发中,我们经常要用到数据库的连接字符串,下面是我经常用的用来获取web.config中数据库连接字符串的2种方法
Web.Config中的连接字符串:
<
connectionStrings
>
< add name = " WebJakeCS " connectionString = " server=202.197.79.159;database=WebJake;uid=WebJake;pwd=Jake@Web "
providerName = " System.Data.SqlClient " />
</ connectionStrings >
< add name = " WebJakeCS " connectionString = " server=202.197.79.159;database=WebJake;uid=WebJake;pwd=Jake@Web "
providerName = " System.Data.SqlClient " />
</ connectionStrings >
数据库操作类中的获取方法:
return
new
SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[
"
WebJakeCS
"
].ConnectionString);
return new SqlConnection(System.Web.Configuration.WebConfigurationManager.ConnectionStrings[ " WebJakeCS " ].ToString());
return new SqlConnection(System.Web.Configuration.WebConfigurationManager.ConnectionStrings[ " WebJakeCS " ].ToString());
这两种方法写在一个专门的数据库操作类中,便于重复调用