DataTable based excel like PIVOTing

This is a very detailed source code for creating utility to provide column based summation data

 

Reference used :

http://support.microsoft.com/kb/326145

http://csharpdotnetfreak.blogspot.com/2008/11/merging-gridview-headers-to-have.html

http://www.codeproject.com/Articles/448762/GridView-column-header-merging-in-ASP-NET

 

 

 

 

 

CSV and DataSet Helper Classess

 

#region Using..

using System;

using System.IO;

using System.Text;

using System.Linq;

using System.Collections.Generic;

using System.Data;