C# Datatable to Multi Dimensional Array
===

I have a datatable like below. I am having a difficult time creating an easy way to group the rows like i listed. I need to be able to perform various calculations like sum all years for one id, sum all ids for one year or similar. I also need systematically assign all the years and values for one id to a set of text boxes, variables, or someway i can access them logically. I guess the biggest issue i am having is determining how to convert the datatable and what would be the best way to handle what i need to do.


Current

    ID		Year		Value

    1       2010		25
    1		2010		25	
    1		2009		30
    1		2008		5	
    1		2008		5		
    1		2008		5		
    2		2010		1
    2		2010		4
    2		2009		0
    2		2008		25	
    2		2008		25		
    2		2008		25

What i Want
		
    ID		Year		Value

    1		2010		50
     		2009		30	
     		2008		15
	
    2		2010		5
     		2009		0
     		2008		75

