CODEWITHSUNDEEP
c#winformsdatagridview
dmigo
dmigo

Reputation: 3029

DataGridView with horizontal columns

Is it possible to have a horizontal columns in DataGridView, with ability to bind those columns?

Upvotes: 2

Views: 8448

Answers (1)

sajanyamaha
sajanyamaha

Reputation: 3198

You dont have to Flip the DataGridView instead Flip the DataSet to bind

Try this:

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;
}

For more details visit Displaying-Vertical-Rows-in-DataGrid-View

Upvotes: 1

Related Questions