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

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

Home > Search > Articles & Samples > ASP.Net > Database > SQL server
Display a SQL row vertically and column horizontally        
Total Hits: 20  |  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.


What's New at DevASP.Net
07/19  Global Windows Hooks
07/19  Automatically Starting your Appli..
07/19  Simple Programming Challenges - E..
07/19  Create Data-entry Forms in Minute..
07/19  Combo Box control in Javascript
07/19  Thunk and Its Uses
07/19  Calling A Web Service From HTML P..
07/19  A GPS keep-alive utility and test..
07/19  Script Running Wizard Add-In for ..
07/19  DNS.NET Resolver (C#)
07/19  Delegates, events and namespaces ..
07/19  How to Start and Debug a Windows ..
07/19  JavaScript Extension Methods
07/19  Game Application "- Memory Plus +..
07/18  ActiveX Privileges, Making Icon F..
07/18  Moving DataGrid Rows Up and Down
07/18  Combine Web and Windows Services ..
07/18  ICustomTypeDescriptor, Part 1
07/18  Lightweight UI Test Automation fo..
07/18  Get Authentication Type, Get Scre..
Latest Posts at Dev Forums
displaying an xml file in datagridview
Tory Block
Deploying website to offline and onlin..
Deploying website to offline and onlin..
window service c#
kiossru
Regular expression
asp.net
Very urgent--
submit to the server
load gif image
focus
filter combo boxes in formview control
ASP Composite Control and Position
Caching as a Master DataSource w/t Rea..
Method returning values in Threadpool!
ADVERTISEMENTS USING XML FILE
DATALIST PROBLEM
FTP Downloading using C#
Nested gridview footer total by using ..

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