HOW TO: Pivot a DataTable

Solution

• CodeSnip: Pivot Tables with ADO.NET and Display in a DataGrid Paged Horizontally by Steve Sharrock (ASPAlliance) - describes a simple method to pivot a DataTable producing rows for each column and a column for each row. The pivoted DataTable is then displayed in a DataGrid using horizontal paging to view a limited number of Columns in each page.
• .NET CrossTabs: Transforming a Normalized DataReader into a Pivoted DataTable by Jeff Smith
  See also:
  • Pivot function (C#) - .NET 1.1 example.
  • Sorting Columns with the C# Pivot Function - .NET 2.0 example.
• Datatable Pivot/Crosstab by Bryan Reynolds - example code and unit tests in VB.NET

Related Resources

• .NET CrossTabs versus SQL Server CrossTabs by Jeff Smith - discusses how pivoting at the presentation layer results in clearer, shorter code and much better performance.
• MSDN: DataTable Class