Trim whitespace from DataTable cells with Linq

Question

This piece of code works to trim all spaces in each datacell of each datarow. How can I get this code:

var dataRows = dataTable.AsEnumerable();
foreach (var row in dataRows)
{
     var cellList = row.ItemArray.ToList();
     row.ItemArray = cellList.Select(x => x.ToString().Trim()).ToArray();
}

into one line of code so I don't have to loop through each row? Something like this but it doesn't work:

dataTable.AsEnumerable().Select(y => y.ItemArray.ToList()).Select(x => x.ToString().Trim());

Answer 1

If you love LINQish stype:

  dataTable.AsEnumerable().ToList()
        .ForEach(row =>
        {
            var cellList = row.ItemArray.ToList();
            row.ItemArray = cellList.Select(x => x.ToString().Trim()).ToArray();
        });

Answer 2

With linq you can't change item values finally you should run for loop (or foreach) to change fields value.