Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: LINQ
Hi All,
 
Can anyone suggest a linq query for the below requirement.
 
There is a Checkbox on the form..when we click on it...As per the below datatable it has to be grouped according to ItemCode,Sum(SoldQty),
 
stock in hand --- latest .. record.. value.. of sales.
amount
description
 
you can't group. the following columns
11)solddate.. show the latest sold date..
2)department
3)category..
ItemCode	Description	UOM	SoldQty	Stock in Hand	SellPrice	Amount	CostPrice	Barcode	SoldDate	Department	Category
100	Paracetamol 200MG	UOM1	5	-5	3	8	0	100	1/21/2013	MEAT	INDIAN BEAF
100	Paracetamol 200MG	UOM1	5	-5	3	8	0	100	1/21/2013	MEAT	INDIAN BEAF
200	frozen meat	Kilograms	0.005	88.19	4	4.01	0	200	1/21/2013	OTHERS	INDIAN BEAF
200	frozen meat	Kilograms	0.044	88.19	4	4.04	0	200	1/21/2013	OTHERS	INDIAN BEAF
100	Paracetamol 200MG	UOM1	5	-5	3	8	0	100	1/22/2013	MEAT	INDIAN BEAF
200	frozen meat	Kilograms	0.054	88.19	4	4.05	0	200	1/22/2013	OTHERS	INDIAN BEAF
200	frozen meat	Kilograms	0.055	88.19	4	4.06	0	200	1/22/2013	OTHERS	INDIAN BEAF
 

Thank you.
Posted 22-Jan-13 18:57pm

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 556
1 OriginalGriff 316
2 Maciej Los 170
3 DamithSL 145
4 PIEBALDconsult 140
0 Sergey Alexandrovich Kryukov 11,384
1 OriginalGriff 5,783
2 Maciej Los 5,684
3 CPallini 3,879
4 BillWoodruff 3,584


Advertise | Privacy | Mobile
Web04 | 2.8.141030.1 | Last Updated 23 Jan 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100