Inverting Rows and Columns

[Brent Hoskisson]

Is there a way to invert the rows and columns in a grid?  I have a table with almost 100 columns and I only need to show one or two rows ever.   It would make it much easier to find columns and edit them if they were the rows.

[Ashok N]

Hi Brent,

Thank you for contacting Syncfusion Support.

We analyzed your query. We can able to rotate the GridDataControl data’s like in the following attached sample. This is the only approach for rotating the GridDataControl. We have created a sample based on your requirement and attached in the following link for your reference. If your requirement defer from this, please share more details regarding your query or screenshot. That would be more helpful for us to serve you.

GDC Sample link: http://www.syncfusion.com/downloads/support/forum/118657/WpfApplication18656201887.zip

But in SfDataGrid, we can able to rotate the grid by using LayoutTransform.

Please refer the below KB link and sample for rotating SfDataGrid by using LayoutTransform.

KB Link: http://www.syncfusion.com/kb/2606/how-to-change-the-orientation-rotating-of-sfdatagrid

Sample Location: HorizontalOrientation_WPF_(2).zip

If you load lot of data in the grid, it causes some performance issue. We have SfDataGrid control like GridDataControl. But compared to GridDataControl, SfDataGrid having a better performance and flexibility. SfDataGrid assists you to create entirely customizable and highly interactive features used to display and manipulate huge amount of data. So, we suggest you to use SfDataGrid instead of GridDataControl.

Please refer the following UG links for SfDataGrid:

http://help.syncfusion.com/ug/wpf/default.htm#!documents/choosebetweendiffere.htm

http://help.syncfusion.com/ug/wpf/default.htm#!documents/performance1.htm

http://help.syncfusion.com/ug/wpf/default.htm#!documents/features2.htm

Please let us know if you require further assistance.

Thanks,

Ashok

[Brent Hoskisson]

Thanks for your response.  My main question is how does this transformation support editing?  I have dropdowns, textboxes, dates, and a few checkboxes.  But they would have to go by row instead of column obviously.   And what would be involved in adding a new row? 

I am looking at the gridcontrol and datagrid.  I am also looking at the CardView, but I haven't found a perfect solution yet.

Brent

[Ashok N]

Hi Brent,

We are sorry about the inconvenience caused.

We have analyzed your query and we regret inform you that we don’t have support to transform the rows and columns in GridDataControl and currently we are developing on SfDataGrid only. So, we suggest you to use SfDataGrid instead of GridDataControl/GridControl. We have modified the sample with editing support and we included dropdowns, textboxes, dates and a checkbox columns. Also, we have already logged feature report to transform the rows and columns in SfDataGrid. Please find the attached sample in the following location:

Sample link: http://www.syncfusion.com/downloads/support/forum/118657/HorizontalOrientation_WPF927592716.zip
Please let us know if you require further assistance.
Thanks,
Ashok