c#在datatable中循环遍历不同的值
本文关键字:遍历 循环 datatable | 更新日期: 2023-09-27 18:28:15
我有一个数据表:
+----------+--------+
| Rep Name | Volume |
+----------+--------+
| Alex | 9 |
| Alex | 1 |
| Alex | 3 |
| Liza | 24 |
| Liza | 17 |
| Pam | 0 |
| Pam | 6 |
+----------+--------+
我为REP NAME
中的每个独特的人发送一封电子邮件
示例:
Hi Alex, Today your volume was 9, and 1, and 3.
下一封电子邮件:
Hi Liza, Today your valume was 24, and 17.
我想知道在REPNAME
的唯一值的数据表中循环的最简单方法
类似于:
var DistinctList = datatable123.Select(x=> x.repname).Distinct();
然后我会循环浏览DistinctList?
您应该对此任务使用GroupBy
。
更新:我已经重写了代码,所以您现在可以在DataTable
中使用它。
var list = from x in datatable123.AsEnumerable()
group x by (string) x["repname"] into g
select g;
foreach (var x in list)
{
Console.WriteLine("Hi {0}, Today your volume was {1}.", x.Key,
String.Join(", and ", x.Select(p => p["volume"])));
}