Home › Forums › WinForms controls › Xceed Grid for WinForms › Pivot-like functionality
Given a datasource (DataTable) that has grid position and value columns;GridCol GridRow CellValue
Is it possible somehow to bind to the source so it puts the value in the right cell based on GridCol and GridRow and saves edits correctly?
Alternately, is there a way to set up an SQL view or something to get the grid to handle this?
Imported from legacy forums. Posted by japhar81 (had 1957 views)
I recently asked a similar question:
To answer yours, I think you should be able to do it within your SQL Server database and return the results already transposed, but there is nothing built-in to the grid that will do what you want.
Imported from legacy forums. Posted by IdleHand (had 3029 views)