Click here to Skip to main content
15,891,981 members
Home / Discussions / C#
   

C#

 
GeneralRe: How to pass null ref type. Pin
DaveyM696-Dec-11 12:27
professionalDaveyM696-Dec-11 12:27 
GeneralRe: How to pass null ref type. Pin
Richard MacCutchan6-Dec-11 13:13
mveRichard MacCutchan6-Dec-11 13:13 
AnswerRe: How to pass null ref type. Pin
Peter_in_27806-Dec-11 13:04
professionalPeter_in_27806-Dec-11 13:04 
GeneralRe: How to pass null ref type. Pin
__John_7-Dec-11 4:36
__John_7-Dec-11 4:36 
QuestionMultilingual keyboard support for C# touchscreen application Pin
PetersCodeProject6-Dec-11 3:06
PetersCodeProject6-Dec-11 3:06 
QuestionRun code if event log entry is older than 12 hours - could you help Pin
CCodeNewbie6-Dec-11 0:15
CCodeNewbie6-Dec-11 0:15 
AnswerRe: Run code if event log entry is older than 12 hours - could you help Pin
Eddy Vluggen6-Dec-11 8:07
professionalEddy Vluggen6-Dec-11 8:07 
QuestionLinq operation [Grouping and Sum] Pin
nitin_ion5-Dec-11 23:16
nitin_ion5-Dec-11 23:16 
I have a table which has columns like this

EmpID | Hours | Date
1 | 7.5 | 20110105
1 | 7.5 | 20110106
1 | 7.5 | 20110107
1 | 7.5 | 20110108
1 | 7.5 | 20110208

date means 2011-01-05

Now i want to get consolidated record of employees like this


EmpID | Hours | Date
1 | 30 | 01
1 | 7.5 | 02

for this i am using this in linq [of course some joins]

C#
from lev in db.TimeTables
                        where lev.ActualDate.Contains(Year) &&
                        lev.PRJ_InternalID.Equals(36)
                        join
                        emp in db.Employees on lev.EMP_InternalID equals emp.InternalID
                        join
                        prj in db.Projects on lev.PRJ_InternalID equals prj.InternalID
                        select new LastYearVacationDetail
                        {
                            EmployeeID = lev.EMP_InternalID,
                            LeaveDays =  lev.Hours,
                            Month = lev.ActualDate.Substring(5, 2)
                        }).ToList();


Now i am not getting Sum and not able to group.
Any help is appreciated
AnswerRe: Linq operation [Grouping and Sum] Pin
OriginalGriff6-Dec-11 1:20
mveOriginalGriff6-Dec-11 1:20 
QuestionOpenDialogFile Issue Pin
PDTUM5-Dec-11 7:42
PDTUM5-Dec-11 7:42 
AnswerRe: OpenDialogFile Issue Pin
fjdiewornncalwe5-Dec-11 8:30
professionalfjdiewornncalwe5-Dec-11 8:30 
GeneralRe: OpenDialogFile Issue Pin
PDTUM5-Dec-11 12:29
PDTUM5-Dec-11 12:29 
AnswerRe: OpenDialogFile Issue Pin
OriginalGriff5-Dec-11 8:37
mveOriginalGriff5-Dec-11 8:37 
GeneralRe: OpenDialogFile Issue Pin
Luc Pattyn5-Dec-11 10:11
sitebuilderLuc Pattyn5-Dec-11 10:11 
GeneralRe: OpenDialogFile Issue Pin
OriginalGriff5-Dec-11 20:47
mveOriginalGriff5-Dec-11 20:47 
GeneralRe: OpenDialogFile Issue Pin
BillWoodruff6-Dec-11 9:54
professionalBillWoodruff6-Dec-11 9:54 
AnswerRe: OpenDialogFile Issue Pin
SilimSayo5-Dec-11 9:14
SilimSayo5-Dec-11 9:14 
QuestionDrawing wave forms from Wave files Pin
Federico Paolillo5-Dec-11 4:45
Federico Paolillo5-Dec-11 4:45 
AnswerRe: Drawing wave forms from Wave files PinPopular
Luc Pattyn5-Dec-11 5:11
sitebuilderLuc Pattyn5-Dec-11 5:11 
GeneralRe: Drawing wave forms from Wave files Pin
Federico Paolillo5-Dec-11 5:28
Federico Paolillo5-Dec-11 5:28 
AnswerRe: Drawing wave forms from Wave files Pin
Luc Pattyn5-Dec-11 6:08
sitebuilderLuc Pattyn5-Dec-11 6:08 
QuestionHow to Import data from excel to sql server 2005 Pin
rahul honey4-Dec-11 23:48
rahul honey4-Dec-11 23:48 
AnswerRe: How to Import data from excel to sql server 2005 Pin
RavinderaG5-Dec-11 1:36
RavinderaG5-Dec-11 1:36 
GeneralRe: How to Import data from excel to sql server 2005 Pin
Richard MacCutchan5-Dec-11 1:58
mveRichard MacCutchan5-Dec-11 1:58 
GeneralRe: How to Import data from excel to sql server 2005 Pin
#realJSOP5-Dec-11 2:29
mve#realJSOP5-Dec-11 2:29 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.