using System;

using System.Data;

using System.Collections.Generic;

using System.Xml;

using System.Linq;

using System.Xml.Linq;

public class Program

{

    public static void Main()

    {

        var xml =@"<?xml version=""1.0"" encoding=""utf-8""?>

<Root>

  <orders>

    <OrderID>10248</OrderID>

    <CustomerID>VINET</CustomerID>

    <EmployeeID>5</EmployeeID>

    <OrderDate>1996-07-04T00:00:00</OrderDate>

    <RequiredDate>1996-08-01T00:00:00</RequiredDate>

    <ShippedDate>1996-07-16T00:00:00</ShippedDate>

    <ShipVia>3</ShipVia>

    <Freight>32.3800</Freight>

    <ShipName>Vins et alcools Chevalier</ShipName>

    <ShipAddress>59 rue de l'Abbaye</ShipAddress>

    <ShipCity>Reims</ShipCity>

    <ShipPostalCode>51100</ShipPostalCode>

    <ShipCountry>France</ShipCountry>

  </orders>

</Root>";

        var doc = XDocument.Parse(xml);

        var result= doc.Descendants("orders");

        var data = result.ToList(); 

        var table =ConvertToDataTable(data);

        foreach(DataRow row in table.Rows){

            foreach(var col in row.ItemArray)

            {

                Console.WriteLine(col);

            }

        }

    }

    public static DataTable ConvertToDataTable(IEnumerable<XElement> data)

    {       

        var table = new DataTable();

        // create the columns

        foreach(var xe in data.First().Descendants())

            table.Columns.Add(xe.Name.LocalName,typeof(string));

        // fill the data

        foreach(var item in data)

        {

            var row = table.NewRow();

            foreach(var xe in item.Descendants())

                row[xe.Name.LocalName] = xe.Value;

            table.Rows.Add(row);

        }

        return table;

    }

​

}

​

​