来自数据表的统计数据

发布于 2024-11-08 06:48:10 字数 846 浏览 0 评论 0原文

使用 VB .NET，我想知道从数据表中获取一些统计数据的最佳方法。我宁愿不使用另一个查询来访问数据库，而只是查看我已有的数据表。

那么，Linq 一定是答案吗？

我有一个包含两列的数据表（dtable）：tech_id 和 color。由此，我想要一个包含三列的新数据表：tech_id、color 和 count。当然，我试图找出每个“tech_id”使用每种不同“颜色”的次数。例如：

tech_id     colour     count
------------------------------
JM          brown      18
JM          purple     10
JM          green      3
PB          brown      51
PB          grey       8
TD          brown      4
TD          pink       67
TD          grey       41

我对 Linq 的最佳尝试根本不正确，但粘贴在下面以显示我已经走了多远：

Dim ColourCounts = From p In PGWorkingDataTable.AsEnumerable() _
         Group p By p.Field(Of String)("colour") Into Count() _
         Select tech_id, colour, ColourCount = Count

Dim colourStatsTable As DataTable = ColourCounts.CopyToDataTable()

谢谢您的帮助！

原文

Using VB .NET, I am wondering about the best way to get some statistical data out of a Datatable. I would rather not hit the database with another query, but just look through the datatable I already have.

So, Linq must be the answer?

I have a datatable (dtable) containing two columns: tech_id and colour. From this, I would like a new datatable containing three columns: tech_id, colour, and count. Of course, I'm trying to figure out how many times each "tech_id" used each distinct "colour". Something like:

tech_id     colour     count
------------------------------
JM          brown      18
JM          purple     10
JM          green      3
PB          brown      51
PB          grey       8
TD          brown      4
TD          pink       67
TD          grey       41

My best attempt with Linq is not at all correct, but is pasted below to show how far I've gotten:

Dim ColourCounts = From p In PGWorkingDataTable.AsEnumerable() _
         Group p By p.Field(Of String)("colour") Into Count() _
         Select tech_id, colour, ColourCount = Count

Dim colourStatsTable As DataTable = ColourCounts.CopyToDataTable()

Thank you for the help!

分享到QQ

分享到微博