app.config进行加密
1.打开"开始--所有程序--Microsoft Visual Studio 2012--Visual Studio Tools--VS2012 x86 本机工具命令提示";
2.将文件app.config改名为web.config(假设文件保存在 d:\123\xml\web.config );
3.输入命令:aspnet_regiis -pef "connectionStrings" "d:\123\xml";
4.解密该文件,在SDK命令提示里输入aspnet_regiis -pdf "connectionStrings" "d:\123\xml"
附:
如果app.config中有appSettings要进行加密,则
3.输入命令:aspnet_regiis -pef appSettings d:\123
4.解密该文件,在SDK命令提示里输入aspnet_regiis -pdf "connectionStrings" "d:\123\xml"
其中:
app.config的设置方法:
1.选择项目名称test,按右键选择"添加(D)--新建项(W)--常规--应用程序配置文件",输入app.config,按回车;
2.输入以下代码
<configuration>
<appSettings>
<!-- User application and configured property settings go here.-->
<!-- Example: <add key="settingName" value="settingValue"/> -->
<add key="ServerIP" value="127.0.0.1"/>
<add key="Server" value="ERP"></add>
<add key="user" value="sa"></add>
<add key="password" value="QzPk01478!"></add>
</appSettings>
</configuration>
在程式中的代码
using System.Configuration;
private void button1_Click(object sender, EventArgs e)
{
string con = string.Format("Server = {0};database = {1};user = {2};pwd = {3};Initial Catalog={4};","(local)\\SQLEXPRESS",ConfigurationManager.AppSettings["Server"],ConfigurationManager.AppSettings["user"],ConfigurationManager.AppSettings["Password"],ConfigurationManager.AppSettings["server"]);
string str1 = string.Format("SELECT [account] ,[Password] FROM [dbo].[user_data] where account='{0}'",textBox1.Text.Trim());
var conn = new SqlConnection(con);
var adapter = new SqlDataAdapter();
conn.Open();
adapter.SelectCommand = new SqlCommand(str1, conn);
adapter.Fill(dt);
dataGridView1.DataSource = dt;
}