XML配置文件

最新推荐文章于 2021-10-07 18:18:39 发布

CPU_2

最新推荐文章于 2021-10-07 18:18:39 发布

阅读量545

点赞数

文章标签： xml system 2010 user string 数据库

本文链接：https://blog.csdn.net/CPU_2/article/details/6978513

版权

   public static string SQLConnectionString
        {
            get
            {
                if (_SQLConnectionString != null)
                {
                    return _SQLConnectionString;
                }
                else
                {

                    //正式库
                    if (IsTest == 0)
                    {
                        _SQLConnectionString = "Data Source=" + ConfigurationManager.AppSettings["ServerName"] + ";Initial Catalog=" + ConfigurationManager.AppSettings["DatabaseName"] + ";User ID=" + ConfigurationManager.AppSettings["UserID"] + ";pwd=" + ConfigurationManager.AppSettings["Password"] + ";packet size=4096;Connect Timeout=60";
                    }
                    else //测试数据库
                    {
                        _SQLConnectionString = "Data Source=" + ConfigurationManager.AppSettings["ServerName"] + ";Initial Catalog=" + ConfigurationManager.AppSettings["DatabaseNameTest"] + ";User ID=" + ConfigurationManager.AppSettings["UserID"] + ";pwd=" + ConfigurationManager.AppSettings["Password"] + ";packet size=4096;Connect Timeout=60";

                    }
                    return _SQLConnectionString;

                }
            }
        }

<?xml version="1.0"?>
<configuration>
<configSections>
    <sectionGroup name="userSettings" type="System.Configuration.UserSettingsGroup, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
      <section name="WinForm.Properties.Settings" type="System.Configuration.ClientSettingsSection, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" allowExeDefinition="MachineToLocalUser" requirePermission="false"/>
    </sectionGroup>
</configSections>
<connectionStrings>
    <add name="connString" connectionString="Data Source=hyh;Initial Catalog=abc;User ID=sa;pwd=hyh2010;packet size=4096;Connect Timeout=30"/>
    <add name="connStringLog" connectionString="Data Source=hyh;Initial Catalog=abc;User ID=sa;pwd=hyh2010;"/>
</connectionStrings>
<appSettings>
    <add key="ServerName" value="farcn"/>
    <add key="DatabaseName" value="abc"/>
    <add key="UserID" value="sa"/>
    <add key="Password" value="hyh2010"/>
</appSettings>
</configuration>