C# 批量执行sql脚本

  public void GetFilePath()
        {
            string ConfigPath = System.AppDomain.CurrentDomain.BaseDirectory + "web.config";
            XmlDocument xmlDoc = new XmlDocument();
            xmlDoc.Load(ConfigPath);
            XmlNode root = xmlDoc.SelectSingleNode("configuration");

            //解析connectionStringItems
            XmlNode list = root.SelectSingleNode("connectionStringItems");
            //循环遍历数据库连接Items
            foreach (XmlNode item in list.ChildNodes)
            {
                string ConnStr = item.InnerText;

                //获取数据库字符串中所有信息
                SqlConnection conn = new SqlConnection(ConnStr);
                SqlConnectionStringBuilder sqlSb = new SqlConnectionStringBuilder(ConnStr);
                string userId = sqlSb.UserID;  //获取登录名
                string password = sqlSb.Password; //获取数据库密码
                string ServerIP = c