配置数据库连接

  <configSections>
    <section name="testSettings" type="System.Configuration.NameValueFileSectionHandler, System, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
  </configSections> 
----------------------------------------
   <testSettings>
  <add key="connectionString" value="server=.;database=ERpilipf;uid=sa;pwd=sky1982"/>
  <add key="defaultPageSize" value="20"/>
  <add key="siteName" value="" />
  <add key="defaultDateFormat" value="dd MMM yyyy"/>
  <add key="defaultTimeFormat" value="hh:mm tt"/>
 </testSettings>

-------------------------------------------------

  /// <summary>
  /// SQL SERVER数据库ConnectionString
  /// </summary>
  public static string DBConnectionString
  {
   get
   {
    return SafeConfigString("testSettings", "connectionString", string.Empty);
    
   }
  }
  ///<summary>
  ///封装了从config文件读取string的方法
  ///</summary>
  private static string SafeConfigString(string configSection,string configKey,string defaultValue)
  {
   NameValueCollection configSetting = ConfigurationSettings.GetConfig(configSection) as NameValueCollection;
   if(configSetting !=null)
   {
    string configValue = configSetting[configKey] as string;
    if(configValue != null)
    {
     return configValue;
    }
   }
   return defaultValue;
  }