How to display a dataTable with the columns arranged vertically?

[t_anjan]

VB .NET 2005 question:

I have a dataset with a datatable in it. This table has 44 columns. Using a DataGridView control to display this table takes the table beyond the width of an A4 sized paper (obviously).

So, I want to display the columns arranged vertically, one column header below another, instead of column headers being next to each other. Can someone tell me how this can be achieved?

I'm not very particular about using the DataGridView control. Any solution is OK. The objective is to print the data in the table.


Thank You.

Anjan

[jmcilhinney]

The fact that the data is very wide in the grid has no bearing on how it will be printed. You can print it any way you want, regardless of how it's displayed in the UI.

[t_anjan]

I want at least one complete record on one sheet of paper. That can't be achieved if some columns have to be wrapped onto a new page.

So, by having the column headers on the left hand side of the page, one below the other, I can get, 4 to 5 records(rows) on one sheet.

[jmcilhinney]

I repeat: you can print the data any way you want. How it's displayed in the grid has absolutely no bearing on how you print it. That is, unless you're just creating an image of the screen and printing that, which is a dodgy way to print.