Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> Windows Forms >> Windows Forms Data Controls and Databinding

DataGridView - switch cols and rows

I really need the DGV to display its cols (fields) down the left (as rows) and the data (there's a single row) as another col. I can't see how to do this. Is this possible?

Thanks, R

[197 byte] By [RogerR] at [2007-12-25]
«« Where has the Message Body Gone?
»» Problem with retriving the members after drill down
# 1
You should create a table with the rows and columns rotated. Check out this example. Is this what you want?
WangChi at 2007-9-3 > top of Msdn Tech,Windows Forms,Windows Forms Data Controls and Databinding...
# 2

Yes - it looks that this solution (via a coded intermediate table) will indeed switch/pivot the rows/cols. But it also seems that we lose the DB auto-updating functionality. And also, we lose the ability to define col attributes (since these are now rows).

It seems a pity that the DataGridView doesn't have a way to just natively pivot!

Thanks for your help and time Chi, Roger

RogerR at 2007-9-3 > top of Msdn Tech,Windows Forms,Windows Forms Data Controls and Databinding...
Windows Forms
Windows Forms Data Controls and Databinding

Windows Forms Hot Topic

Windows Forms New Topic

Windows Forms

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified