Grid orientation

[David Nazarov]

Is there an option or setting that will allow a grid to display a complete row vertically? In other words, "column headers" will be on the left and "row headers" on top?

I've seen the sample doc that says you can do this with a virtual grid by supplying the the inverted coordinates (y, x instead of x, y) in virtual mode. This does not fulfill my requirements, however, because I want to be able to have the grid bound to a datasource.

[haneefm]

Hi David,

Currently this feature is not possible in GridDataBoundGrid. But you can use the virtual events to swap the roles of the rows and columns. Please refer to the following KB article discusses about the steps to transpose the rows into columns and vice versa using the Virtual Grid.

http://www.syncfusion.com/support/kb/grid/Default.aspx?ToDo=view&questId=315

Best regards,
Haneef

[David Nazarov]

As I said in my previous message, I've read that sample, and it doesn't help me. I'm specifically trying to change the orientation of columns that are bound. To go virtual would mean to throw away all of the benefits I get from databinding.

Are there any plans to add support for this feature?

[haneefm]

Hi David,

We are glad of your interest on our products. The design of GridDataBoundGrid does not support for this feature. There is no simple way to do this that we know of. It would require deriving several classes to attempt it.

Best regards,
Haneef

[Ville Salomäki]

I need also similar solution. I see the thread is over 2 years old. Is this now solved?

[Rajadurai C]

Hi Ville,

Thanks for your interest in Syncfusion Products.

I apologize for the delay in responding.

Please refer to the following sample in which two griddataboundgrids were used. One grid displays the data of other grid in transposed manner(i.e., rows as columns and columns as rows).
http://files.syncfusion.com/support/samples/Grid.Windows/7.3.0.20/I58580/GDBG.zip

Regards,
Rajadurai

[Andrew Rosenblum]

Is there an example like this for wpf?

[Ramesh V]

Hi Andrew,

We have analyzed your requirements also we have prepared a sample based on this and please find the sample under the following location.
Sample: http://www.syncfusion.com/downloads/Support/DirectTrac/General/GDCTransformation501167373.zip

Please let us know if this helps.

Regards,
Ramesh

[Elliott]

Hi There,

 

I found this example is quite useful and suit in my case. Thanks a lot.

 

However, I want to swap the model and style (like the hidden setting, frozen count setting, background color, font, etc) of the columns and rows also, is it possible?

 

Cheers,

Elliott

[Saravanan M]

Hi Elliot,

We sorry for delay,

We have analyzed your query. If you want to swap the Styles(Foreground,Background,FontSize etc.,),you can use QueryCellInfo event. Please refer the codesnippet

 

this.SyncGrid1.Model.QueryCellInfo += new GridQueryCellInfoEventHandler(Model_QueryCellInfo);

 

void Model_QueryCellInfo(object sender, GridQueryCellInfoEventArgs e)

 {

 }

 

Please let us know if you have any queries.

Regards,

Saravanan.M

 

[William Gorelik]

Hi Rajadurai,

Is this sample still available? I have the exact same requirement, but get a Page Not Found error upon viewing.

Thanks,
William

[Neelakandan Kannan]

Hi William,

Thank you for using Syncfusion products.

Here is the uploaded sample link. Please make use of below sample and below sample illustrates the GridDataBoundGrid trapose,

http://www.syncfusion.com/downloads/support/forum/63333/ze/Sample_GDBG_Transpose-285145137

Please refer the below link for GridControl,
http://www.syncfusion.com/kb/658/how-do-i-swap-rows-and-columns

For more details, please refer the below link,
http://www.syncfusion.com/kb/windowsforms

Please let me know if you have any concerns.

Regards,
Neelakandan