Thanks for reply. Please ignor my sample code of LINQ to SQL above. If there's another way for this problem, I'm all for it. All I need right now is to get the result like the following , given the data sample above:
- Name ,Jan/2010 , Feb/2010 and so on
- John Maslow , 2 , 3
- Crystal Hood , 4...
Advice on how to solve this problem
I'm stuck with this for 2 days now. Please give me some advice on how to solve this problems. If possible, please give links to other sites that might help me with this. Thanks
Hi,
I have two tables Students and Origami. Origami has Foreign Key of Students table. Each student can make one or more origami for each month.
Students sample data:
StudentId, FirstName, LastName
- 187 , John , Maslow
- 196 , Crystal , Hood
- 195 , Sarah , Lewis
Origami sample data...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.