Insert XML data in one of two data table according to Xml attribute value.
<blockquote>
  <p>I have 2 datatables fireCollarTable_ and electrofusionTable_.  </p>
</blockquote>

<pre><code>        fireCollarTable_ = new System.Data.DataTable("Fire Collar");
        fireCollarTable_.Columns.Add("Article", typeof(string));
        fireCollarTable_.Columns.Add("Description", typeof(string));
        fireCollarTable_.Columns.Add("Diameter", typeof(double));

        electroFusionCouplerTable_ = new System.Data.DataTable("Electrofusion Coupler");
        electroFusionCouplerTable_.Columns.Add("Article", typeof(string));
        electroFusionCouplerTable_.Columns.Add("Description", typeof(string));
        electroFusionCouplerTable_.Columns.Add("Diameter", typeof(double));
        electroFusionCouplerTable_.Columns.Add("Length", typeof(double));    
</code></pre>

<blockquote>
  <p>the above two datatables are defined,the XML file is</p>
</blockquote>

<pre><code>   &lt;Catalogue&gt;

     &lt;!--  1-Item, 2-Article, 3-Description, 4-PipeType, 5-Diameter --&gt;

     &lt;Record a1="Fire Collar" a2="VS0410001" a3="Fire Collar, 40 mm" a5="40" /&gt;
     &lt;Record a1="Fire Collar" a2="VS0410003" a3="Fire Collar, 50 mm" a5="50" /&gt;
     &lt;Record a1="Fire Collar" a2="VS0410005" a3="Fire Collar, 56 mm" a5="56" /&gt;

     &lt;!--  1-Item, 2-Article, 3-Description, 4-PipeType, 5-Diameter,9-Length--&gt;

     &lt;Record a1="Electrofusion Coupler" a2="VS0350001" a3="Electrofusion coupler, 40 mm"         a5="40" a9="64" /&gt;
     &lt;Record a1="Electrofusion Coupler" a2="VS0350003" a3="Electrofusion coupler, 50 mm" a5="50" a9="60" /&gt;

   &lt;/Catalogue&gt;
</code></pre>

<p>I want to parse the XML file and according to value of attribute "a1",i want to insert data into one of datatables. e.g.  if value of "a1" = "Fire Collar" then data should be inserted in firecollar table.</p>
