title: file xml put in datagridview C#
body: <p>I wrote code in order to put data read from file to a datagridview.</p>
  
  <pre><code>private void button1_Click(object sender, EventArgs e)
          {
              XmlDataDocument xmlsach = new XmlDataDocument();
              xmlsach.DataSet.ReadXml(Application.StartupPath + "\\cm_exp_20170712_221837.xml");
              dataGridView1.DataSource = xmlsach.DataSet;
              dataGridView1.DataMember = "ExternalUtranCell";
  
          }
  </code></pre>
  
  <p>But it only shows id of ExternalUtranCell, I want to show everything put in only one table. How can I achieve this?
  Here is a part of my table definition.</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="utf-8" ?&gt;
  &lt;root xmlns:un ="abc" xmlns:xn="def" xmlns:es="ghi"&gt;
  &lt;un:ExternalUtranCell id="12345-16-11"&gt;
    &lt;un:attributes&gt;
      &lt;un:rac&gt;11&lt;/un:rac&gt;
      &lt;un:lac&gt;11&lt;/un:lac&gt;
      &lt;un:primaryCpichPower&gt;300&lt;/un:primaryCpichPower&gt;
      &lt;un:primaryScramblingCode&gt;0&lt;/un:primaryScramblingCode&gt;
      &lt;un:uarfcnDl&gt;10588&lt;/un:uarfcnDl&gt;
      &lt;un:uarfcnUl&gt;&lt;/un:uarfcnUl&gt;
      &lt;un:mnc&gt;45&lt;/un:mnc&gt;
      &lt;un:mcc&gt;123&lt;/un:mcc&gt;
      &lt;un:rncId&gt;16&lt;/un:rncId&gt;
      &lt;un:cId&gt;11&lt;/un:cId&gt;
      &lt;un:userLabel&gt;&lt;/un:userLabel&gt;
    &lt;/un:attributes&gt;
    &lt;xn:VsDataContainer id="12345-16-11"&gt;
      &lt;xn:attributes&gt;
        &lt;xn:vsDataType&gt;vsDataExternalUtranCell&lt;/xn:vsDataType&gt;
        &lt;xn:vsDataFormatVersion&gt;EricssonSpecificAttributes.16.28&lt;/xn:vsDataFormatVersion&gt;
        &lt;es:vsDataExternalUtranCell&gt;
          &lt;es:individualOffset&gt;0&lt;/es:individualOffset&gt;
          &lt;es:maxTxPowerUl&gt;100&lt;/es:maxTxPowerUl&gt;
          &lt;es:qQualMin&gt;100&lt;/es:qQualMin&gt;
          &lt;es:qRxLevMin&gt;100&lt;/es:qRxLevMin&gt;
          &lt;es:agpsEnabled&gt;1&lt;/es:agpsEnabled&gt;
          &lt;es:cellCapability&gt;
            &lt;es:hsdschSupport&gt;0&lt;/es:hsdschSupport&gt;
            &lt;es:edchSupport&gt;0&lt;/es:edchSupport&gt;
            &lt;es:edchTti2Support&gt;0&lt;/es:edchTti2Support&gt;
            &lt;es:enhancedL2Support&gt;0&lt;/es:enhancedL2Support&gt;
            &lt;es:fdpchSupport&gt;0&lt;/es:fdpchSupport&gt;
            &lt;es:multiCarrierSupport&gt;0&lt;/es:multiCarrierSupport&gt;
            &lt;es:cpcSupport&gt;0&lt;/es:cpcSupport&gt;
            &lt;es:qam64MimoSupport&gt;0&lt;/es:qam64MimoSupport&gt;
          &lt;/es:cellCapability&gt;
          &lt;es:transmissionScheme&gt;0&lt;/es:transmissionScheme&gt;
          &lt;es:parentSystem&gt;SubNetwork=ONRM_ROOT_MO_R,vsDataExternalUtranPlmn=1&lt;/es:parentSystem&gt;
          &lt;es:mncLength&gt;2&lt;/es:mncLength&gt;
          &lt;es:hsAqmCongCtrlSpiSupport&gt;1&lt;/es:hsAqmCongCtrlSpiSupport&gt;
          &lt;es:hsAqmCongCtrlSpiSupport&gt;2&lt;/es:hsAqmCongCtrlSpiSupport&gt;
          &lt;es:hsAqmCongCtrlSpiSupport&gt;3&lt;/es:hsAqmCongCtrlSpiSupport&gt;
          &lt;es:hsAqmCongCtrlSpiSupport&gt;4&lt;/es:hsAqmCongCtrlSpiSupport&gt;
          &lt;es:hsAqmCongCtrlSpiSupport&gt;7&lt;/es:hsAqmCongCtrlSpiSupport&gt;
          &lt;es:hsAqmCongCtrlSupport&gt;0&lt;/es:hsAqmCongCtrlSupport&gt;
          &lt;es:srvccCapability&gt;1&lt;/es:srvccCapability&gt;
          &lt;es:reportingRange1a&gt;0&lt;/es:reportingRange1a&gt;
          &lt;es:reportingRange1b&gt;0&lt;/es:reportingRange1b&gt;
          &lt;es:timeToTrigger1a&gt;-1&lt;/es:timeToTrigger1a&gt;
          &lt;es:timeToTrigger1b&gt;-1&lt;/es:timeToTrigger1b&gt;
          &lt;es:rimCapable&gt;0&lt;/es:rimCapable&gt;
          &lt;es:lbUtranCellOffloadCapacity&gt;1000&lt;/es:lbUtranCellOffloadCapacity&gt;
        &lt;/es:vsDataExternalUtranCell&gt;
      &lt;/xn:attributes&gt;
    &lt;/xn:VsDataContainer&gt;
  &lt;/un:ExternalUtranCell&gt;
    &lt;un:ExternalUtranCell id="12345-16-11"&gt;
      &lt;un:attributes&gt;
        &lt;un:rac&gt;11&lt;/un:rac&gt;
        &lt;un:lac&gt;11&lt;/un:lac&gt;
        &lt;un:primaryCpichPower&gt;300&lt;/un:primaryCpichPower&gt;
        &lt;un:primaryScramblingCode&gt;0&lt;/un:primaryScramblingCode&gt;
        &lt;un:uarfcnDl&gt;10588&lt;/un:uarfcnDl&gt;
        &lt;un:uarfcnUl&gt;&lt;/un:uarfcnUl&gt;
        &lt;un:mnc&gt;45&lt;/un:mnc&gt;
        &lt;un:mcc&gt;123&lt;/un:mcc&gt;
        &lt;un:rncId&gt;16&lt;/un:rncId&gt;
        &lt;un:cId&gt;11&lt;/un:cId&gt;
        &lt;un:userLabel&gt;&lt;/un:userLabel&gt;
      &lt;/un:attributes&gt;
      &lt;xn:VsDataContainer id="12345-16-11"&gt;
        &lt;xn:attributes&gt;
          &lt;xn:vsDataType&gt;vsDataExternalUtranCell&lt;/xn:vsDataType&gt;
          &lt;xn:vsDataFormatVersion&gt;EricssonSpecificAttributes.16.28&lt;/xn:vsDataFormatVersion&gt;
          &lt;es:vsDataExternalUtranCell&gt;
            &lt;es:individualOffset&gt;0&lt;/es:individualOffset&gt;
            &lt;es:maxTxPowerUl&gt;100&lt;/es:maxTxPowerUl&gt;
            &lt;es:qQualMin&gt;100&lt;/es:qQualMin&gt;
            &lt;es:qRxLevMin&gt;100&lt;/es:qRxLevMin&gt;
            &lt;es:agpsEnabled&gt;1&lt;/es:agpsEnabled&gt;
            &lt;es:cellCapability&gt;
              &lt;es:hsdschSupport&gt;0&lt;/es:hsdschSupport&gt;
              &lt;es:edchSupport&gt;0&lt;/es:edchSupport&gt;
              &lt;es:edchTti2Support&gt;0&lt;/es:edchTti2Support&gt;
              &lt;es:enhancedL2Support&gt;0&lt;/es:enhancedL2Support&gt;
              &lt;es:fdpchSupport&gt;0&lt;/es:fdpchSupport&gt;
              &lt;es:multiCarrierSupport&gt;0&lt;/es:multiCarrierSupport&gt;
              &lt;es:cpcSupport&gt;0&lt;/es:cpcSupport&gt;
              &lt;es:qam64MimoSupport&gt;0&lt;/es:qam64MimoSupport&gt;
            &lt;/es:cellCapability&gt;
            &lt;es:transmissionScheme&gt;0&lt;/es:transmissionScheme&gt;
            &lt;es:parentSystem&gt;SubNetwork=ONRM_ROOT_MO_R,vsDataExternalUtranPlmn=1&lt;/es:parentSystem&gt;
            &lt;es:mncLength&gt;2&lt;/es:mncLength&gt;
            &lt;es:hsAqmCongCtrlSpiSupport&gt;1&lt;/es:hsAqmCongCtrlSpiSupport&gt;
            &lt;es:hsAqmCongCtrlSpiSupport&gt;2&lt;/es:hsAqmCongCtrlSpiSupport&gt;
            &lt;es:hsAqmCongCtrlSpiSupport&gt;3&lt;/es:hsAqmCongCtrlSpiSupport&gt;
            &lt;es:hsAqmCongCtrlSpiSupport&gt;4&lt;/es:hsAqmCongCtrlSpiSupport&gt;
            &lt;es:hsAqmCongCtrlSpiSupport&gt;7&lt;/es:hsAqmCongCtrlSpiSupport&gt;
            &lt;es:hsAqmCongCtrlSupport&gt;0&lt;/es:hsAqmCongCtrlSupport&gt;
            &lt;es:srvccCapability&gt;1&lt;/es:srvccCapability&gt;
            &lt;es:reportingRange1a&gt;0&lt;/es:reportingRange1a&gt;
            &lt;es:reportingRange1b&gt;0&lt;/es:reportingRange1b&gt;
            &lt;es:timeToTrigger1a&gt;-1&lt;/es:timeToTrigger1a&gt;
            &lt;es:timeToTrigger1b&gt;-1&lt;/es:timeToTrigger1b&gt;
            &lt;es:rimCapable&gt;0&lt;/es:rimCapable&gt;
            &lt;es:lbUtranCellOffloadCapacity&gt;1000&lt;/es:lbUtranCellOffloadCapacity&gt;
          &lt;/es:vsDataExternalUtranCell&gt;
        &lt;/xn:attributes&gt;
      &lt;/xn:VsDataContainer&gt;
    &lt;/un:ExternalUtranCell&gt;
  &lt;/root&gt;
  </code></pre>