本文整理汇总了C#中Entities.List.ToDataTable方法的典型用法代码示例。如果您正苦于以下问题：C# List.ToDataTable方法的具体用法？C# List.ToDataTable怎么用？C# List.ToDataTable使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Entities.List的用法示例。
在下文中一共展示了List.ToDataTable方法的1个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: TestPivot
public static DataTable TestPivot(ref DataTable src)
{
var week_days = new List<Sales>();
week_days.Add(new Sales { Sequence = 1, Sequence2 = 8, Day = "Sun", Amount = 23 });
week_days.Add(new Sales { Sequence = 2, Sequence2 = 8, Day = "Mon", Amount = 18 });
week_days.Add(new Sales { Sequence = 3, Sequence2 = 8, Day = "Tue", Amount = 30 });
week_days.Add(new Sales { Sequence = 4, Sequence2 = 8, Day = "Wed", Amount = 15 });
week_days.Add(new Sales { Sequence = 5, Sequence2 = 8, Day = "Thu", Amount = 20 });
week_days.Add(new Sales { Sequence = 6, Sequence2 = 8, Day = "Fri", Amount = 08 });
week_days.Add(new Sales { Sequence = 7, Sequence2 = 8, Day = "Sat", Amount = 0 });
week_days.Add(new Sales { Sequence = 8, Sequence2 = 0, Day = "Fri", Amount = 18 });
src = week_days.ToDataTable();
// before transpose
foreach (var day in week_days)
Console.WriteLine("{0} {1} {2}", day.Sequence, day.Day, day.Amount);
var tr = from row in week_days
group row by "SALES" into g
where g.FirstOrDefault() != null
select new
{
DAY = g.Key,
Sun = g.Where(sales => sales.Day == "Sun").Sum(sales => sales.Amount),
Mon = g.Where(sales => sales.Day == "Mon").Sum(sales => sales.Amount),
Tue = g.Where(sales => sales.Day == "Tue").Sum(sales => sales.Amount),
Wed = g.Where(sales => sales.Day == "Wed").Sum(sales => sales.Amount),
Thu = g.Where(sales => sales.Day == "Thu").Sum(sales => sales.Amount),
Fri = g.Where(sales => sales.Day == "Fri").Sum(sales => sales.Amount),
Sat = g.Where(sales => sales.Day == "Sat").Sum(sales => sales.Amount)
};
return tr.ToDataTable();
}