VB.NET - To display gridview in vertical direction

Hi

I have some data in datatable and i am binding it to the grid view and it looks like this

header1 header2
value1    value2

but i want to display in this way

header1  value1
header2  value2

I am storing the data in datable like

dt.columns.add("header1")
dt.columns.add("header2")
dr.rows("header1")=value1
dr.rows("header2")=value2

dt.rows.add(dr)

You can assign this as your HeaderStyle

<style>

.verticaltext {

writing-mode: tb-rl;

filter: flipv fliph;

}

</style>

HeaderCssClass="verticaltext"

There's separate control in asp.net for this purpose.... detailsview


http://2.bp.blogspot.com/_P3ZJmNYimyo/SRwt8kVBelI/AAAAAAAAAmc/MOkycA9Yx5E/s1600-h/DesignDetailsView1.jpg

this is a working sample for vertical rows, but in c#, you can use any code conversion site to covert to vb.net.

Use Repeater control instead of GridView

You can flip all the entries inside each table of the dataset, 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;
    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;
}

Old DataSet

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

Flipped DataSet

0	1	2	3
Column1	Neeraj	Tashan	Andrew
Column2	Jain	Yen	Agknow
Column3	Carios	Agknow	Feedback