Datagrid, on the side?

[HenkeBenke]

Hi!
Does anyone know how to present data in columns instead of rows?
eg:
Result1 Result2 Result3 ... Result n
Surname
Given name
Born
....

By the way, the grid is bound to dataset.

Thanks in advance!
Henrik

 

[Marina]

It sounds like you need the data pivoted. The datagrid doesn't support that,
perhaps some of the 3rd party products do.

You can try pivoting the data on the database side. For SQL Server, I
believe there is no built in way to do that, so you would have to roll your
own solution in a stored procedure or something.

 

[Scott Allen]

Right, until SQL 2005 gets here, you'll have to pivot yourself. There
is a SQL Server example here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_qd_14_04j7.asp