VB Datagrid - swapping columns to rows

[basdewaard]

Is there an easy way to swap info displayed in a datagrid column so that it is displayed in a row instead? I envisage some sort of 'swap columns with rows' property.

 

BOZ

[Robby]

What exactly are you trying to do?

[basdewaard]

We've got a database with a set structure that we're accessing using a datagrid. The problem seems that the datagrid is set to read the columns of the database and display them in the datagrid as they are. We would like to be able to 'transpose' a column from the database into a row on the datagrid.

 

Our solution has been to use a table instead, creating datarowviews from the dataview and populating the table rows that way.

[Robby]

No doubt that it can be done, iterate the datatable creating a row for every column found.

 

I still can't understand the reason for this design unless it's some sort of aggregate report or pivot table you want to setup you may be better off doing this in the database using strored procs and such.