ASP.NET ListView/GridView Horizontal Orientation

I am kind of new to ASP.NET and I need some help with a particular display format. It is an item comparison tool. Essentially it is a GridView control but with a horizontal orientation. I have researched every data grid control and cannot find a way to do this with an ASP.NET control.  Attached is visual representation of what kind of layout I am trying to accomplish. You will see that this is an html table where the actual record/rows enumerate from left to right. The first column is for the labels of the data columns. The rest of the table columns are the record columns. I have attempted to build this from the code behind using a StringBuilder to generate the html. I cannot find any control that can do this for me. I write and know C#. All the data is from a single SQL table. Any help would be greatly appreciated.
MockUp.jpg
Skeller106Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Nathan BoveSoftware EngineerCommented:
The only control I can think of to accomplish what you are looking for is the Repeater control.  You would set up the repeater to output a series of DIV or TABLE elements which each of your columns being a separate DIV/TABLE.  You can find more information about the Repeater control here:
http://msdn.microsoft.com/en-us/library/x8f2zez5.aspx
Skeller106Author Commented:
That is pretty much what I am attempting now, just looping in the code-behind to build the html instead of the Repeater. Here is an HTML table that I am trying to build with C#. I am not proficient enough in the looping or nested looping that would be required here to accomplish the view in my screen shot.
<table width="100%" border="1" cellspacing="0" cellpadding="0">
    <tr>
        <td>Test Information</td><!-- Hard-coded label -->            
        <!-- Begin Loop -->
        <td>Record Name 1</td>
        <td>Record Name 2</td>
        <!-- End Loop -->
    </tr>
    <!-- Begin Empty Row -->
    <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
    </tr>
    <!-- End Empty Row -->
    <tr>            
        <td>Column Name 1</td> <!-- Colum names from DB -->            
        <!-- Begin Loop -->
        <td>Column Data 1</td>
        <td>Column Data 1</td>
        <!-- End Loop -->
    </tr>        
</table>

Open in new window

MlandaTCommented:
you can achieve this by manipulating your data in the database. if SQL Server you can use the PIVOT and/or UNPIVOT commands to do this. then just bind the already formatted data.
Exploring SQL Server 2016: Fundamentals

Learn the fundamentals of Microsoft SQL Server, a relational database management system that stores and retrieves data when requested by other software applications.

Nathan BoveSoftware EngineerCommented:
The repeater control is definately your friend here.  The key is that you will not have a single table that will contain all of your data.  Each column will be it's own independent DIV/TABLE.
Skeller106Author Commented:
I unfortunately do not have access to the SQL database. It is a home-grown CMS system. I just have query access.
MlandaTCommented:
you could also follow this series of articles which talks about an implementation used for http://public.presalesadvisor.com/. It might be a bit of reading, but well worth it http://delradiesdev.blogspot.com/2010/10/vertical-gridviews-in-aspnet-part-1.html

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
MlandaTCommented:
You amy also get a few additional ideas at: http://forums.asp.net/t/1233650.aspx
Skeller106Author Commented:
MlandaT:

Do you know if the solution outlined here: http://delradiesdev.blogspot.com/2010/10/vertical-gridviews-in-aspnet-part-1.html is available for download anywhere? That is exactly what I need.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
C#

From novice to tech pro — start learning today.