Datagrid columns to rows

Does anyone know how to swap columns with rows in the datagrid control. We're stuch with a particular format in the database that will successfully bring up data in a column which we'd like to 'transpose' into a row!

Any help would be much appreciated.

BOZ

I have this code which I use to transpose data in my C1 FlexGrid.

VB Code:

Dim NewGrd As C1FlexGrid = New C1FlexGrid
 
        'set up dimensions
        NewGrd.Rows.Count = grdView.Cols.Count
        NewGrd.Cols.Count = grdView.Rows.Count
        NewGrd.Rows.Fixed = grdView.Cols.Fixed
        NewGrd.Cols.Fixed = grdView.Rows.Fixed
 
        'copy data types, formats, styles, etc.
        'from source columns to dest rows
        Dim i As Integer
        For i = 0 To grdView.Cols.Count - 1
            CopyRowCol(grdView.Cols(i), NewGrd.Rows(i))
        Next
 
        'copy data types, formats, styles, etc
        'from source rows to dest columns
        For i = 0 To grdView.Rows.Count - 1
            CopyRowCol(grdView.Rows(i), NewGrd.Cols(i))
        Next
 
        'transpose data
        Dim r, c As Integer
        For r = 0 To grdView.Rows.Count - 1
            For c = 0 To grdView.Cols.Count - 1
                NewGrd(c, r) = grdView(r, c)
            Next
        Next
 
        'transfer all data back to original grid
        grdView.DataSource = NewGrd
 
        'and do an autosize
        grdView.AutoSizeCols()

Hope it helps

Regards

Prakash

Thanks Prakash

We used a table in the end (with datarowviews) but the code you've provided is bound to be useful. Thanks very much for your help.

BOZ