Pivot: How can i store Pivot data into List<T>

[Sudip_inn]

I am calling a sql server store procedure which return pivot data which i store in data table but i like to know how could i design my call as a result i can store Pivot format data in my List<T> class.

here i am giving a screen shot which show what kind of data i am dealing with.



all the quarter data is not fixed. it is coming from database and it can be up-to any year. so please guide how to design my class as a result store the above data in my List<T> class instead of data table.

if possible please explain this with a sample code and scenario.

thanks

Continue reading...