如何在linq中基于Id计算总小时数和小组项目 [英] How to calculate total hours and group projects based on Id in linq

问题描述

嗨朋友，



我有一张桌子

Hi Friends,

I have a table

date            | ProjectID| hours | Task
----------------------------------------------------------
2012-01-01 1:00 | 1    | 10               | Coding
2012-01-01 1:00 | 2    | 10               | Design
2012-01-21 2:00 | 1    | 1                | R&D
2012-01-01 2:00 | 2    | 9                | Support
2012-01-01 3:00 | 1    | 3                | Design
2012-02-30 3:00 | 1    | 3                | Coding

i想要这样显示



项目-1

总小时数：17

日期：2012-01-01 1:00 - 2012-02-30 3:00

任务：编码，R& D，设计



任何帮助将不胜感激....



问候

Chinnu

i want to display like this

Project-1
total hours : 17
Date : 2012-01-01 1:00 - 2012-02-30 3:00
Task : Coding,R&D, Design

Any help will be appreciated....

Regards
Chinnu

推荐答案

尝试以下链接回答No.2

http://stackoverflow.com/questions/6551447/c-using -linq-to-group-by-multiple-columns-in-a datatable [ ^ ]

try following link Answer No.2
http://stackoverflow.com/questions/6551447/c-using-linq-to-group-by-multiple-columns-in-a-datatable[^]

这篇关于如何在linq中基于Id计算总小时数和小组项目的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！