Click here to Skip to main content
15,867,306 members
Articles / Programming Languages / C#

Displaying Vertical Rows in a DataGrid

Rate me:
Please Sign up or sign in to vote.
4.46/5 (40 votes)
21 Sep 20032 min read 281.4K   51   47
Displaying vertical rows in a datagrid by flipping the tables horizontally
This is the solution that I came up with to display a DataGrid in a horizontal manner (vertical rows). 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.

Introduction

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:

Column1 Column2 Column3
Neeraj Jain Carios
Tashan Yen Agknow
Andrew Ferriere Feedback

Flipped DataSet

New DataTable looks like this:

0 1 2 3
Column1 Neeraj Tashan Andrew
Column2 Jain Yen Agknow
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.

Code

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:

C#
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;
    this.my_DataGrid.DataBind();
}

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++)
        {
            table.Columns.Add(Convert.ToString(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];
        }
        table.Rows.Add(r);
    }
    ds.Tables.Add(table);
}
return ds;
}

Conclusion

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

History

  • 22nd September, 2003: Initial version

License

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.


Written By
Web Developer
United States United States
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Comments and Discussions

 
GeneralNot working for me Pin
_drifter19-Jan-11 11:40
_drifter19-Jan-11 11:40 
GeneralRemoving Column names. Pin
srikantha_nagaraj9-Aug-09 20:02
srikantha_nagaraj9-Aug-09 20:02 
Questionhow can i modify the columnheader name 0 1 2 3 column? Pin
rkhiev22-Sep-08 10:50
rkhiev22-Sep-08 10:50 
QuestionHow we can perform Update on this transposed grid Pin
msaqu2-Aug-08 20:25
msaqu2-Aug-08 20:25 
GeneralThis Article very Good Pin
RRavi Kumar25-Feb-08 1:48
RRavi Kumar25-Feb-08 1:48 
GeneralGreat Pin
naveenj3-Jan-08 22:34
naveenj3-Jan-08 22:34 
GeneralSame thing Different approach! Pin
hengrr21-Aug-07 13:52
hengrr21-Aug-07 13:52 
GeneralDemo Project in C#.NET 2005 Pin
Gamil Mohamad23-Jun-07 3:06
Gamil Mohamad23-Jun-07 3:06 
Nice Jop Neeraj Jain,
but i found some bugs in your code so, i make anouther application shown your idea in a working Visual C#.NET 2005 Application.

here is the article link:
http://www.codeproject.com/useritems/Mmg.asp[^]


Cool | :cool:



Mohamad Gamal

GeneralThank you Pin
Baroon10-Mar-07 18:27
Baroon10-Mar-07 18:27 
GeneralEdited : Added Headerstyle, ItemStyle, and AlternatingStyles to columns [modified] Pin
beyerch22-Aug-06 10:24
beyerch22-Aug-06 10:24 
QuestionRotate with nonString field Pin
Konstantin_STD24-Jul-06 2:23
Konstantin_STD24-Jul-06 2:23 
GeneralColumn Paging on this datagrid [modified] Pin
vaishika23-Jun-06 13:49
vaishika23-Jun-06 13:49 
GeneralGridView instead of DataGrid Pin
yaip19-Jun-06 13:40
yaip19-Jun-06 13:40 
Generalcorrected code Pin
ZoneTrader17-Apr-06 12:46
ZoneTrader17-Apr-06 12:46 
GeneralShort and sweet - Nice Pin
Jorge Da Silva7-Feb-06 8:38
Jorge Da Silva7-Feb-06 8:38 
GeneralU need to alter one { curly brace Pin
Cinni10-Jan-06 18:54
Cinni10-Jan-06 18:54 
QuestionHow do you format a column? Pin
ramsay_s29-Nov-05 6:51
ramsay_s29-Nov-05 6:51 
GeneralNice job there! Pin
alkisman4-Sep-05 21:38
alkisman4-Sep-05 21:38 
GeneralVB Port Pin
brad_morga18-May-05 3:58
brad_morga18-May-05 3:58 
QuestionRe: VB Port Pin
Member 436544317-Aug-08 20:19
Member 436544317-Aug-08 20:19 
GeneralRe: VB Port Pin
The Web Developer19-Aug-08 20:29
The Web Developer19-Aug-08 20:29 
GeneralRe:Displaying vertical rows in a DataGrid Pin
Amr EL-Nasser29-Mar-05 3:51
Amr EL-Nasser29-Mar-05 3:51 
GeneralPush button,hyperlink or image button Pin
amit__85-Feb-05 1:49
amit__85-Feb-05 1:49 
GeneralRe: Push button,hyperlink or image button Pin
miltash11-Feb-05 18:19
miltash11-Feb-05 18:19 
QuestionDid anyone got the .NEt Version working?? Pin
youngoz27-Jan-05 6:07
youngoz27-Jan-05 6:07 

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.