Pivoting DataTable Simplified

Anurag Gandhi

Rate me:

4.92/5 (131 votes)

20 Aug 2014CPOL5 min read

426.6K

28.6K

325

A class to pivot a DataTable with various aggregate functions

pivot.zip
- Pivot.cs
PivotDataTable_Demo.zip
- PivotDataTable
  - _Data
    - DataForPivot.xls
  - App_Code
  - App_Data
  - Bin
    - AjaxControlToolkit.dll
    - ReadMe.txt
  - Default.aspx
  - Default.aspx.cs
  - PivotDataTable.sln
  - PivotDataTable.suo
  - PivotDataTable.v12.suo
  - ReadMe.txt
  - web.config
PivotScript.zip
- PivotScript.sql
pivotdatatable_vb.zip
- PivotDataTable_Vb
  - _Data
    - DataForPivot.xls
  - App_Code
    - ExcelLayer.vb
    - Pivot.vb
  - App_Data
  - Bin
    - ReadMe.txt
  - Default.aspx
  - Default.aspx.vb
  - ReadMe.txt
  - web.config
pivot_vb.zip
- Pivot_Vb
  - Pivot.vb
PivotDataTable_2012-04-02_CSharp.zip
- DataForPivot.xls
- ExcelLayer.cs
- Pivot.cs
- AjaxControlToolkit.dll
- ReadMe.txt
- Default.aspx
- Default.aspx.cs
- PivotDataTable.sln
- PivotDataTable.suo
- ReadMe.txt
- web.config
Pivot_2012-04-02_CSharp.zip
- Pivot.cs
pivotdatatable.zip
- DataForPivot.xls
- ExcelLayer.cs
- Pivot.cs
- ReadMe.txt
- Default.aspx
- Default.aspx.cs
- ReadMe.txt
- web.config
PivotDataTable_Demo-noexe.zip
- DataForPivot.xls
- ExcelLayer.cs
- Pivot.cs
- SqlLayer.cs
- ReadMe.txt
- Default.aspx
- Default.aspx.cs
- PivotDataTable.sln
- PivotDataTable.suo
- PivotDataTable.v12.suo
- ReadMe.txt
- web.config

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

Anurag Gandhi

Architect

India

Anurag Gandhi is a Freelance Developer and Consultant, Architect, Blogger, Speaker, and Ex Microsoft Employee. He is passionate about programming.
He is extensively involved in Asp.Net Core, MVC/Web API, Node/Express, Microsoft Azure/Cloud, web application hosting/architecture, Angular, AngularJs, design, and development. His languages of choice are C#, Node/Express, JavaScript, Asp .NET MVC, Asp, C, C++. He is familiar with many other programming languages as well. He mostly works with MS SQL Server as the preferred database and has worked with Redis, MySQL, Oracle, MS Access, etc. also.
He is active in programming communities and loves to share the knowledge with others whenever he gets the time for it.
He is also a passionate chess player.
Linked in Profile: https://in.linkedin.com/in/anuraggandhi
He can be contacted at soft.gandhi@gmail.com

Pivoting DataTable Simplified

License

Comments and Discussions