title: Importing XML Data From XML File To SQL Database
body: <p>I'm new to C# and have been working on learning database's. Currently I'm trying to import data from a XML document that has items stored as follows:</p>
  
  <pre><code>   &lt;CityData&gt;
          &lt;City&gt;Ada&lt;/City&gt;
          &lt;County&gt;Olmsted&lt;/County&gt;
          &lt;AreaCode&gt;507&lt;/AreaCode&gt;
          &lt;Founded&gt;1900&lt;/Founded&gt;
          &lt;CityWebSite&gt;www.adacity.com&lt;/CityWebSite&gt;
          &lt;Population&gt;1200&lt;/Population&gt;
          &lt;Zipcode&gt;56996&lt;/Zipcode&gt;
          &lt;ZipcodeMax&gt;57656&lt;/ZipcodeMax&gt;
      &lt;/CityData&gt;
  </code></pre>
  
  <p>I'm trying to save each data collection to a different row in a SQL Express database. I've been able to store other information in the database, I just don't know how to do this with a XML document. The database is stored locally on my machine along with the C# program I'm writing. I have a new table with columns named and ordered like the XML documents schema. The tutorials I'm finding online are for .asp programs. Has anyone ever done this? This is a C# Forms Program.</p>