Hi,
Try this if could help...
DataTable x = new DataTable();
IEnumerable<DataRow> dtrow = x.AsEnumerable();
var dt = dtrow.GroupBy(dtl => dtl.Field<string>("TransDate"))
.Select(dtg => new dtg
{
dtl.Field<string>("TransDate") = dtg.Key,
dtrow.Sum(d => d.Field<double>("Amount"))
}).ToList();
Regards,
Algem