Pivot Tables with ADO.NET and Display Horizontal Paged DataGrid
This is a new article I've added to ASPAlliance. It's been a while since I've written, but I'm happy to have some time to add some more articles that I've been sitting on.
"Pivot Tables with ADO.NET and Display in Horizontal Paged DataGrid".
This article 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. This is a common display technique used to compare, for instance, product features, where the product names appear across the top of the DataGrid with the Features listed down the side. http://aspalliance.com/538