if you would like to do a select all and altering a column without visiting each element or
select * replace a column value without looping , here are what you can do
a very good post in stackOverflow can be found here:
in an Ienumerable list / the Linq way:
1) collection.Select(c => {c.PropertyToSet = value; return c;}).ToList();
2) collection.ToList().ForEach(c => c.PropertyToSet = value);
in data table:
make the good use of the .Expression , you can find MSDN documentation here :
1) column.Expression = "price * 0.0862";
2) column.Expression = anotherColumn's Name;