1、在启动项目中创建App.config文件,App.config文件内容为
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<configSections>
<section name="dataConfiguration" type="Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings, Microsoft.Practices.EnterpriseLibrary.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null" />
</configSections>
<dataConfiguration defaultDatabase="connString" />
<connectionStrings>
<add name="connString" connectionString="server=www.db4free.net;user id=kai76941058;password=chenkai149;database=kai76941058;"
providerName="System.Data.SqlClient" />
</connectionStrings>
</configuration>
2、在启动项目的Program.cs文件中添加方法如下:
static void EncryptConfiguration()
{
// 使用什么类型的加密
string provider = "RsaProtectedConfigurationProvider";
Configuration config = null;
config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
// 加密连接字符串
ConfigurationSection section = config.ConnectionStrings;
if ((section.SectionInformation.IsProtected == false) &&
(section.ElementInformation.IsLocked == false))
{
section.SectionInformation.ProtectSection(provider);
section.SectionInformation.ForceSave = true;
config.Save(ConfigurationSaveMode.Full);
}
}
3、在启动项目Program.cs文件中的主程序入口点中调用 EncryptConfiguration()方法如下:
/// <summary>
/// 应用程序的主入口点。
/// </summary>
[STAThread]
static void Main()
{
EncryptConfiguration();
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
Application.Run(new Mian());
}
4、在DBHelper.cs文件中代码改为如下:
namespace CKyun_DAL
{
public class DBHelper
{
public static string connString = ConfigurationManager.ConnectionStrings["connString"].ToString();
}
}