Is it possible to switch rows and columns in a datagridview?

by

You can create new DataTable, add appropriate number of collumns and then copy values from one table to the other, just swap rows and colums.

I don’t think you can set row header in the same way you can set column header (or at least I don’t know how), so you can put the field names in separate colum.

DataTable oldTable = new DataTable();

...

DataTable newTable = new DataTable();

newTable.Columns.Add("Field Name");
for (int i = 0; i < oldTable.Rows.Count; i++)
    newTable.Columns.Add();

for (int i = 0; i < oldTable.Columns.Count; i++)
{
    DataRow newRow = newTable.NewRow();

    newRow[0] = oldTable.Columns[i].Caption;
    for (int j = 0; j < oldTable.Rows.Count; j++)
        newRow[j+1] = oldTable.Rows[j][i];
    newTable.Rows.Add(newRow);
}

dataGridView.DataSource = newTable;

More Related Contents:

  1. How to add a new row to datagridview programmatically
  2. How to change row color in datagridview?
  3. Copy DataGridView values to TextBox
  4. How to Merge DataGridView Cell in Winforms
  5. How can we do pagination in datagridview in winform
  6. How to handle click event in Button Column in Datagridview?
  7. List vs BindingList Advantages/DisAdvantages
  8. How to detect DataGridView CheckBox event change?
  9. how to bind datatable to datagridview in c#
  10. CRUD Operations using DataGridView, DataTable and DataAdapter – Cannot add new row to DataGridView
  11. How to change the color of winform DataGridview header?
  12. How to sort databound DataGridView column?
  13. Index of Currently Selected Row in DataGridView
  14. Show Loading animation during loading data in other thread
  15. C#: multiline text in DataGridView control
  16. DataGridView keydown event not working in C#
  17. How to programmatically set cell value in DataGridView?
  18. Datagridview: How to set a cell in editing mode?
  19. DataGridView with Button Control – Delete Row
  20. How to prevent DataGridView from flickering when scrolling horizontally?
  21. How do you automatically resize columns in a DataGridView control AND allow the user to resize the columns on that same grid?
  22. DataGridView AutoFit and Fill
  23. How do I change the datagridview selected row background color?
  24. how to sort string as number in datagridview in winforms
  25. Create RDLC report dynamically at run-time from a DataGridView
  26. How to enable DataGridView sorting when user clicks on the column header?
  27. Populating a DataGridView with Text and ProgressBars
  28. How to refresh datagridview when closing child form?
  29. DataGridView Image for Button Column
  30. How to create a Button that can send keys to a control without stealing the focus – Virtual Keyboard

Leave a Comment