asp.net零碎知识小结
1.vs2003和vs2005在web.Config中的连接字符串写法:
vs2003将连接字符串写在AppSettings中:
<appSettings >
<add key="connectionstringName" value="data source=服务器名或IP;initial catalog=数据库名;persist security info=False;user id=用户;password=密码;">
</add>
</appSettings >
取值方式:System.Configuration.ConfigurationManager.AppSettings["name"]
vs2005将连接字符串写在AppSettings外:
<connectionStrings>
<add name="ConnectionStringName" connectionString="Data Source=服务器名;Initial Catalog=数据库名;User ID=用户;Password=密码"
providerName="System.Data.SqlClient" />
</connectionStrings>
取值方式:System.Configuration.ConfigurationManager.ConnectionStrings["name"].ToString()
2.
vs2003将连接字符串写在AppSettings中:
<appSettings >
<add key="connectionstringName" value="data source=服务器名或IP;initial catalog=数据库名;persist security info=False;user id=用户;password=密码;">
</add>
</appSettings >
取值方式:System.Configuration.ConfigurationManager.AppSettings["name"]
vs2005将连接字符串写在AppSettings外:
<connectionStrings>
<add name="ConnectionStringName" connectionString="Data Source=服务器名;Initial Catalog=数据库名;User ID=用户;Password=密码"
providerName="System.Data.SqlClient" />
</connectionStrings>
取值方式:System.Configuration.ConfigurationManager.ConnectionStrings["name"].ToString()
2.
posted on 2010-12-06 13:01 LeeXiaoLiang 阅读(89) 评论(0) 收藏 举报
浙公网安备 33010602011771号