Click here to Skip to main content
12,746,850 members (29,235 online)
Click here to Skip to main content
Add your own
alternative version


51 bookmarked
Posted 21 Sep 2003

Displaying vertical rows in a DataGrid

, 21 Sep 2003
Rate this:
Please Sign up or sign in to vote.
Displaying vertical rows in a datagrid by flipping the tables horizontally


Last week, when I wanted to display a DataGrid in a horizontal manner (vertical rows), I thought there may be some property in DataGrid to flip it, but it wasn’t the case or may be I couldn’t find it. I read online articles and forums but didn’t get very useful or easy solutions. One of the solutions I found was to nest a DataList into a DataSet but I didn’t find this easy; and the other was all together a new control called xrepeater but I found mine easier than the two of them.

Let’s say you have a dataset which you want to render through a datagrid but you don’t want to show horizontal rows, instead you want to show the rows vertically. There may be lot of cases when you want to do that, for example comparison between two things on several criteria (Column headings) or when you have just one or two rows to show then you would prefer the vertical rows for more clarity. Here is how the idea of flipping the table comes in.

The idea is to flip all the entries inside each table of the dataset. This is not a very good solution but it works fine. I wrote a method which takes a DataSet as a parameter and returns a new DataSet with all tables flipped and now you just have to bind this DataSet’s tables to the DataGrid as you do normally and DataGrid renders vertical rows.

Old DataSet

Old Table looks like below.

Column1Column2 Column3
NeerajJain Carios
Tashan Yen Agknow
Andrew Ferriere Feedback

Flipped DataSet

New DataTable looks like this

Column1 Neeraj Tashan Andrew
Column2 Jain YenAgknow
Column3 Carios Agknow Feedback

Please note that in flipped table there are column headings as integer numbers, so when bind you it to the datagrid, and set the property ShowHeader=false; you are all set to render the vertical dataRows properly.


Here is the code for FlipDataSet method, is in the code behind file for me. In method FlipDataSet, I am doing flipping of dataset and in BindData, I am binding the first table of it to the DataGrid. This is all:

private void BindData()
    DataSet ds = this.GetDetail(); // Some DataSet
    DataSet new_ds = FlipDataSet(ds); // Flip the DataSet
    DataView my_DataView = new_ds.Tables[0].DefaultView;
    this.my_DataGrid.DataSource = my_DataView;

public DataSet FlipDataSet(DataSet my_DataSet)
    DataSet ds = new DataSet();
    foreach(DataTable dt in my_DataSet.Tables)
        DataTable table = new DataTable();
        for(int i=0; i<=dt.Rows.Count; i++)
        DataRow r;
        for(int k=0; k<dt.Columns.Count; k++)
            r = table.NewRow();
            r[0] = dt.Columns[k].ToString();
            for(int j=1; j<=dt.Rows.Count; j++)
                r[j] = dt.Rows[j-1][k];
return ds;


Thanks for reading and please send any questions or comments you may have (I am sure you will).


This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here


About the Author

Neeraj Jain
Web Developer
United States United States
No Biography provided

You may also be interested in...

Comments and Discussions

GeneralNot working for me Pin
_drifter19-Jan-11 12:40
member_drifter19-Jan-11 12:40 
GeneralRemoving Column names. Pin
srikantha_nagaraj9-Aug-09 21:02
membersrikantha_nagaraj9-Aug-09 21:02 
Questionhow can i modify the columnheader name 0 1 2 3 column? Pin
rkhiev22-Sep-08 11:50
memberrkhiev22-Sep-08 11:50 
GeneralThis Article very Good Pin
R4Ravi Kumar25-Feb-08 2:48
memberR4Ravi Kumar25-Feb-08 2:48 
GeneralGreat Pin
naveenj3-Jan-08 23:34
membernaveenj3-Jan-08 23:34 
GeneralSame thing Different approach! Pin
hengrr21-Aug-07 14:52
memberhengrr21-Aug-07 14:52 
GeneralDemo Project in C#.NET 2005 Pin
M. Gamal23-Jun-07 4:06
memberM. Gamal23-Jun-07 4:06 
GeneralThank you Pin
Baroon10-Mar-07 19:27
memberBaroon10-Mar-07 19:27 
GeneralEdited : Added Headerstyle, ItemStyle, and AlternatingStyles to columns [modified] Pin
beyerch22-Aug-06 11:24
memberbeyerch22-Aug-06 11:24 
QuestionRotate with nonString field Pin
Konstantin_STD24-Jul-06 3:23
memberKonstantin_STD24-Jul-06 3:23 
GeneralColumn Paging on this datagrid [modified] Pin
vaishika23-Jun-06 14:49
membervaishika23-Jun-06 14:49 
GeneralGridView instead of DataGrid Pin
yaip19-Jun-06 14:40
memberyaip19-Jun-06 14:40 
Generalcorrected code Pin
ZoneTrader17-Apr-06 13:46
memberZoneTrader17-Apr-06 13:46 
GeneralShort and sweet - Nice Pin
Jorge Da Silva7-Feb-06 9:38
memberJorge Da Silva7-Feb-06 9:38 
GeneralU need to alter one { curly brace Pin
cinni10-Jan-06 19:54
membercinni10-Jan-06 19:54 
QuestionHow do you format a column? Pin
ramsay_s29-Nov-05 7:51
memberramsay_s29-Nov-05 7:51 
GeneralNice job there! Pin
alkisman4-Sep-05 22:38
memberalkisman4-Sep-05 22:38 
GeneralVB Port Pin
brad_morga18-May-05 4:58
memberbrad_morga18-May-05 4:58 
QuestionRe: VB Port Pin
Member 436544317-Aug-08 21:19
memberMember 436544317-Aug-08 21:19 
GeneralRe: VB Port Pin
The Developer19-Aug-08 21:29
memberThe Developer19-Aug-08 21:29 
GeneralRe:Displaying vertical rows in a DataGrid Pin
Amr EL-Nasser29-Mar-05 4:51
sussAmr EL-Nasser29-Mar-05 4:51 
GeneralPush button,hyperlink or image button Pin
amit__85-Feb-05 2:49
memberamit__85-Feb-05 2:49 
GeneralRe: Push button,hyperlink or image button Pin
mailtoanzar11-Feb-05 19:19
membermailtoanzar11-Feb-05 19:19 
QuestionDid anyone got the .NEt Version working?? Pin
4netvb27-Jan-05 7:07
member4netvb27-Jan-05 7:07 
AnswerRe: Did anyone got the .NEt Version working?? Pin
M. Gamal4-Jul-07 15:49
memberM. Gamal4-Jul-07 15:49 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.170215.1 | Last Updated 22 Sep 2003
Article Copyright 2003 by Neeraj Jain
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid