按多列分组 - LINQ

发布于 2024-11-08 15:28:54 字数 474 浏览 0 评论 0原文

我见过按列乘法分组的例子，但是对于类。我正在尝试为 EnumerableDataRowList 执行此操作。但我得到“无效的匿名类型成员声明符”。

                    EnumerableDataRowList<DataRow> enumerableRowCollection = new EnumerableDataRowList<DataRow>(reportData.Select("WeekKey <> '0'"));


                var groupedRows1 = from row in enumerableRowCollection
                                  group row by new {row["NETWORK"], row["Week"] };

另外，我看到有些人在某些情况下组合列以获得相同的结果。这样做有什么好处

原文

I have seen examples of multiply group by columns, but for classes. I am trying to do this for a EnumerableDataRowList. but I get "Invalid anonymous type member declarator."

                    EnumerableDataRowList<DataRow> enumerableRowCollection = new EnumerableDataRowList<DataRow>(reportData.Select("WeekKey <> '0'"));


                var groupedRows1 = from row in enumerableRowCollection
                                  group row by new {row["NETWORK"], row["Week"] };

also, I seen some people combine the columns in some case to get the same results. Any benefit in doing it that way

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

南街九尾狐 2024-11-15 15:28:54

您必须为值分配一个标识符：

         var groupedRows1 = from row in enumerableRowCollection
                            group row by new { Network = row["NETWORK"], Week = row["Week"] };

如果您使用字段或属性引用，通常不需要指定标识符，因为它只会重用该成员的名称 - 但在这种情况下您正在访问索引器属性，因此无法从中获取名称。

You have to assign an identifier to the values:

         var groupedRows1 = from row in enumerableRowCollection
                            group row by new { Network = row["NETWORK"], Week = row["Week"] };

You normally aren't required to specify an identifier if you're using a field or property reference as it'll just reuse the name of that member - but in this case you're accessing an indexer property, so there's no way to get a name from it.

回复收藏 0 原文

~没有更多了~