Pivot-like functionality

[User (Old forums)]

#14146 |

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)

[User (Old forums)]

#14147

I recently asked a similar question:

http://www.xceedsoft.com/Forums/ShowPost.aspx?PostID=3654

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)

[Author]

Posts