Hi guys,
im trying my best to learn LINQ but im still having a hard time coding it. Like this one, suppose I have a dataset or a List maybe and the names or fields of the of the collection object are the column names.
Id | Date |Mon |Tues |Wed |Thu |Fri |Sat |Sun |Count
1 | 01/05 |=1=|==1==|==1=|==1=| 1=|=0=|=0==|==5 <-- (1)
2 | 02/02 |=1=|==1==|==1=|==1=| 1=|=0=|=0==|==5 **|-- (2)
3 | 03/02 |=1=|==1==|==1=|==1=| 1=|=0=|=0==|==5 **|-- (2)
4 | 04/06 |=1=|==1==|==1=|==1=| 1=|=1=|=1==|==7 <-- (1)
5 | 05/04 |=1=|==1==|==1=|==1=| 1=|=1=|=1==|==7 **|-- (3)
6 | 06/01 |=1=|==1==|==1=|==1=| 1=|=1=|=1==|==7 **|-- (3)
7 | 07/06 |=1=|==1==|==1=|==1=| 0=|=0=|=0==|==4 <---- (1)
8 | 08/03 |=1=|==1==|==1=|==1=| 0=|=0=|=0==|==4 **|-- (4)
9 | 09/07 |=1=|==1==|==1=|==1=| 0=|=0=|=0==|==4 **|-- (4)
10 | 10/05 |1=|==1==|==1=|==1=| 0=|=0=|=0==|==4 **|-- (4)
All i want is first to get all the number (1)'s then the (2)'s because they belong to the first (1). Next the group of (3)'s because they belong to the second (1). Last the group of (4)'s because they belong to the last (1).
please help.
-- question rephrased. 1. how can i get the first group of 5's then the group of 7's and last the group of 4's?