1.在web.config中配置连接字符串
<connectionStrings>
<add name="webLoginconn" connectionString="Data Source=PC-2010;Initial Catalog=webLogin;User
<connectionStrings>
<add name="webLoginconn" connectionString="Data Source=PC-2010;Initial Catalog=webLogin;User
ID=sy2010;Password=123456" providerName="System.Data.SqlClient"/>
</connectionStrings>
</connectionStrings>
2.在文件代码中添加对连接字符串的引用
(1)首先要导入System.Web.Configuration
即 using System.Web.Configuration 要添加在代码文件中
(2)写代码
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["webLoginconn"].ConnectionString);
conn.Open();
或
string strconn = ConfigurationManager.ConnectionStrings["webLoginconn"].ConnectionString;
SqlConnection conn = new SqlConnection(strconn);
conn.Open();
(1)首先要导入System.Web.Configuration
即 using System.Web.Configuration 要添加在代码文件中
(2)写代码
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["webLoginconn"].ConnectionString);
conn.Open();
或
string strconn = ConfigurationManager.ConnectionStrings["webLoginconn"].ConnectionString;
SqlConnection conn = new SqlConnection(strconn);
conn.Open();
3.进行加密
在dos中执行如下命令
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>aspnet_regiis -pe "connectionStrings" -app "/sy02" -prov "RsaProtectedConfigurationProvider"
在dos中执行如下命令
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>aspnet_regiis -pe "connectionStrings" -app "/sy02" -prov "RsaProtectedConfigurationProvider"
4.进行解密
在dos中执行如下命令
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>aspnet_regiis -pd "connectionStrings" -app "/sy02"
在dos中执行如下命令
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>aspnet_regiis -pd "connectionStrings" -app "/sy02"
5.如果加密后出现“打不开RSA密钥容器”的错误,请在dos中执行如下命令
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>aspnet_regiis -pa "NetFrameworkConfigurationKey" "NETWORK SERVICE"
然后就可以顺利访问你的网站了
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>aspnet_regiis -pa "NetFrameworkConfigurationKey" "NETWORK SERVICE"
然后就可以顺利访问你的网站了