title: ChildNodes based on Parent xml Attribute in C#
body: <p>This is my Xml.</p>
  
  <pre><code>&lt;SCat&gt;
    &lt;S SId="1" SName="M" FName="MA"&gt;
      &lt;Cat&gt;
        &lt;C CId="2" CName="CAS" FName="c-a" /&gt;
        &lt;C CId="3" CName="DAC" FName="d-a" /&gt;
      &lt;/Cat&gt;
    &lt;/S&gt;
    &lt;S SId="2" SName="I" FName="IA"&gt;
      &lt;Cat&gt;
        &lt;C CId="2" CName="CAS" FName="c-a" /&gt;
        &lt;C CId="3" CName="DAC" FName="d-a" /&gt;
      &lt;/Cat&gt;
    &lt;/S&gt;
    &lt;S SId="3" SName="D" FName="DA"&gt;
      &lt;Cat&gt;
        &lt;C CId="2" CName="CAS" FName="c-a" /&gt;
        &lt;C CId="3" CName="DAC" FName="d-a" /&gt;
      &lt;/Cat&gt;
    &lt;/S&gt;
  &lt;/SCat&gt;
  </code></pre>
  
  <p>I wrote this code.</p>
  
  <pre><code>int Scode = 1;
  dsS = new DataSet();
  dsS.ReadXml(HttpContext.Current.Server.MapPath(Path));
  </code></pre>
  
  <p>This is where i am stucked.
  I want to get all "Cat" in the Datatable which has attribute "SId" = 1.</p>
  
  <p>Thanks</p>