title: Add XmlNode to XmlElement
body: <p>I get a soap envelope back from a web service with customer data such as name and address etc. The address does not contain city/suburb but postcode. I have all the city and suburbs with their post codes in a CSV file so I want to insert the correct name for each post code. I can store it in a database or something else but this is more about how to insert the node before I pass the data on.</p>
  
  <p>The code is like :</p>
  
  <pre><code>XmlDocument xDoc = new XmlDocument();
  xDoc.LoadXml(searchResponse);
  
  XmlNamespaceManager nsmgr = new XmlNamespaceManager(xDoc.NameTable);
  nsmgr.AddNamespace("ns", wsNamespace);
  
  XmlNodeList postCodeNodes = xDoc.SelectNodes("//ns:postcode", nsmgr);
  string applicationPath = AppDomain.CurrentDomain.BaseDirectory;
  
  foreach (XmlNode node in postCodeNodes)
  { 
      using (StreamReader readFile = new StreamReader(applicationPath + "postcodes.csv"))
      {
          string line;
          string[] row;
  
          while ((line = readFile.ReadLine()) != null)
          {
                  row = line.Split(',');
                  if (row[0].ToString() == node.InnerText)
                  {
                      string suburb = row[1].ToString();
                      //XmlNode ndSuburb = xDoc.CreateElement("suburb");
                      //ndSuburb.Value = suburb;
                      //node.ParentNode.AppendChild(ndSuburb);
                      break;
                  }
          }
      }
  }
  </code></pre>
  
  <p>and I am not sure what to do where I have commented out the code. Any suggestions? Tips on how to make this more efficient would also be appreciated.</p>
  
  <p>Thanks in advance.</p>