title: LINQ query does not load into data grid
body: <p>I want to load an XML into a DataGridView and correlated the changes from the datagridview to the XML file (CRUD). I've tried various methods, I'm trying to find the best, I've got the XML to load and display correctly and save the changes by iterating through the entire DataGridView and create a new XML document, but that requires a lot of processing. How can I do this in a simpler manner?
  I was thinking at loading the XML file into memory within an XDocument and operate the changes from the DataGridView upon that on an Edit_EventHandler so that when I want to save the changes I don't have to parse the entire GridView again. I've tried using LINQ but the query does not load into DataGridView:</p>
  
  <pre><code>string path = @"D:\WorkData\users.xml";
  
  xmlDoc = XDocument.Load(path);
  var q = from item in xmlDoc.Descendants("client")
          select new
          {
              Name = item.Element("ID").Value,
              Mail = item.Element("email").Value
          };
  
  dataGridView1.DataSource = q.ToList();
  </code></pre>
  
  <p>and the XML:</p>
  
  <pre><code>&lt;?xml version='1.0'?&gt;
  &lt;clients&gt;
    &lt;client ID='0000100000' email='email0@mail.com'/&gt;
    &lt;client ID='0000100001' email='email1@mail.com'/&gt; 
  &lt;/clients&gt;
  </code></pre>