Search   Articles   Dev Forums   Personalize   Favorites   Member Login   ASP.Net Hosting
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Friday, November 21, 2008

Dev Articles
Search Directory
ASP.NET
VB.Net
C-Sharp
SQL Server
 
FREE 12 month online training for ASP.NET & MS Expression Studio and a Free copy of MS Expression Web with Windows Server Purchase

User Rating!

Home > Search > Articles & Samples > ASP.Net > Database > SQL server
Display a SQL row vertically and column horizontally        
Total Hits: 38  |  Today: 0 Author: Xun Ding       Rating:  
Read Reviews | Write Review |   Your Rating: 

For displaying data in a table, DataGrid probably is the best choice. However, sometimes you may find it necessary to render your table in a different manner. Say, when you have a database table that has more than twenty fields and only a couple of records, I bet you would want to display all the rows vertically and the columns horizontally. Actually a week ago I stumbled into this problem myself. Checking online, I found some users had the same problem, yet there is not a workable answer ready for sharing. Therefore I present my solution below. It may not be the best answer, but it certainly is quick and simple to me.

DevASP.Net users Rating
What is your opinion?
Is this your listing?

    If this is your listing and you like to add the rating box
    displayed on the right side on your site you can use the following code.

Go Back
DevASP.Net - Disclaimer - Privacy
Copyright © 2008 DevASP.net