title: Trim whitespace from DataTable cells with Linq
body: <p>This piece of code works to trim all spaces in each datacell of each datarow.
  How can I get this code:</p>
  
  <pre><code>var dataRows = dataTable.AsEnumerable();
  foreach (var row in dataRows)
  {
       var cellList = row.ItemArray.ToList();
       row.ItemArray = cellList.Select(x =&gt; x.ToString().Trim()).ToArray();
  }
  </code></pre>
  
  <p>into one line of code so I don't have to loop through each row? Something like this but it doesn't work:</p>
  
  <pre><code>dataTable.AsEnumerable().Select(y =&gt; y.ItemArray.ToList()).Select(x =&gt; x.ToString().Trim());
  </code></pre>