数据库连接

<?xml version="1.0" encoding="utf-8" ?>
配置文件

<configuration>

  <appSettings>
    <add key="ConnectionString" value="Data Source=20120516-0951\SQLEXPRESS;Initial Catalog=sky_rvcs;Persist Security Info=True;User ID=sa;Password=123 "/>
  </appSettings> 

</configuration>

 

 

得到配置文件字符串

using System;
using System.Configuration;
namespace Maticsoft.DBUtility
{

    public class PubConstant
    {
        /// <summary>
        /// 获取连接字符串
        /// </summary>
        public static string ConnectionString
        {
            get
            {
                string _connectionString = ConfigurationManager.AppSettings["ConnectionString"];
                string ConStringEncrypt = ConfigurationManager.AppSettings["ConStringEncrypt"];
                if (ConStringEncrypt == "true")
                {
                    _connectionString = DESEncrypt.Decrypt(_connectionString);
                }
                return _connectionString;
            }
        }

        /// <summary>
        /// 得到web.config里配置项的数据库连接字符串。
        /// </summary>
        /// <param name="configName"></param>
        /// <returns></returns>
        public static string GetConnectionString(string configName)
        {
            string connectionString = ConfigurationManager.AppSettings[configName];
            string ConStringEncrypt = ConfigurationManager.AppSettings["ConStringEncrypt"];
            if (ConStringEncrypt == "true")
            {
                connectionString = DESEncrypt.Decrypt(connectionString);
            }
            return connectionString;
        }

    }
  
}

转载于:https://www.cnblogs.com/lmcblog/archive/2012/08/10/2631576.html