title: Retrieve data from xml file and insert into database table
body: <p>I am using c# .net 1.1 and SQL Server 2000....</p>
  
  <p>I want to retrive data from an xml file and store that data into the database table.</p>
  
  <p>XML file:</p>
  
  <pre><code>&lt;information&gt;
    &lt;data&gt;
      &lt;id="1"&gt;&lt;/id&gt;
      &lt;name&gt;peter&lt;/name&gt;
      &lt;age&gt;25&lt;/age&gt;
    &lt;/data&gt;
  &lt;/information&gt;
  </code></pre>
  
  <p>My databse table is</p>
  
  <pre><code>id int,
  name varchar(100),
  age int
  </code></pre>