数据库连接

最新推荐文章于 2025-08-15 10:38:51 发布

xiajing12345

最新推荐文章于 2025-08-15 10:38:51 发布

阅读量197

点赞数

CC 4.0 BY-SA版权

文章标签：数据库 string user security

本文链接：https://blog.youkuaiyun.com/xiajing12345/article/details/5480681

本文介绍了一种从XML配置文件中读取数据库连接信息的方法，并展示了如何使用这些信息来初始化数据库上下文。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

        public static string connstring ="";
        private static string getConnstring()
        {
            XmlDocument xmlDoc = new XmlDocument();
            xmlDoc.Load("./user.config");
            String Ip = xmlDoc.SelectSingleNode("/configuration/userSettings/DBSetting.Properties.Settings/setting[@name='IP']").FirstChild.InnerText;
            String user = xmlDoc.SelectSingleNode("/configuration/userSettings/DBSetting.Properties.Settings/setting[@name='USER']").FirstChild.InnerText;
            String pass = xmlDoc.SelectSingleNode("/configuration/userSettings/DBSetting.Properties.Settings/setting[@name='Password']").FirstChild.InnerText;
            String DB = xmlDoc.SelectSingleNode("/configuration/userSettings/DBSetting.Properties.Settings/setting[@name='DB']").FirstChild.InnerText;
            connstring = "Data Source=" + Ip + ";Initial Catalog=" + DB + ";Persist Security Info=True;User ID=" + user + ";Password=" + pass + "";
            return connstring;
        }

  public FeeDataDataContext() :
        base(getConnstring(), mappingSource)
  {
   OnCreated();
            if (!this.DatabaseExists())
            {
                MessageBox.Show("数据库连接失败");
                throw new ApplicationException();
            }
  }