Click here to Skip to main content
15,868,164 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.5K   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

 
GeneralRe: nice job... Pin
gmsm19-Mar-04 8:58
gmsm19-Mar-04 8:58 
GeneralVB.Net version Pin
crodri13-Feb-04 11:05
crodri13-Feb-04 11:05 
GeneralRe: VB.Net version Pin
Anonymous14-Mar-04 14:45
Anonymous14-Mar-04 14:45 
GeneralRe: VB.Net version Pin
GanesanM3-May-04 4:35
GanesanM3-May-04 4:35 
GeneralRe: VB.Net version Pin
geeta yadav23-Sep-04 0:47
geeta yadav23-Sep-04 0:47 
GeneralRe: VB.Net version Pin
stsong5-Nov-04 4:30
stsong5-Nov-04 4:30 
Questionextra bracket? Pin
Anonymous10-Oct-03 10:36
Anonymous10-Oct-03 10:36 
AnswerRe: extra bracket? Pin
Neeraj Jain12-Oct-03 21:18
Neeraj Jain12-Oct-03 21:18 
I put the working code before but may be these people edit it to make it look right and ... Anyway here it is:
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
GeneralRe: extra bracket? Pin
Anonymous14-Oct-03 9:59
Anonymous14-Oct-03 9:59 
GeneralNice job. Pin
GanesanM3-May-04 4:40
GanesanM3-May-04 4:40 
GeneralAlternative Pin
George L. Jackson22-Sep-03 10:11
George L. Jackson22-Sep-03 10:11 

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.