Swapping the rows and columns

srikantha_nagaraj

Hi. I have table in the database. I want to show the table row as column in the gridview. How can i do that?

Coding C

Abhishek Sur

I think you need to do it in database.. Use TSQL PIVOT function to convert row into columns and vice-versa. Check this http://msdn.microsoft.com/en-us/library/ms177410.aspx for more help.:thumbsup:

Abhishek Sur

My Latest Articles **Create CLR objects in SQL Server 2005 C# Uncommon Keywords Read/Write Excel using OleDB

**Don't forget to click "Good Answer" if you like to.

singhkiran

Me too want to know, how to swap the rows and columns. Please help!! Thanks, Kiran _____________________ http://india-jobs-opening.blogspot.com/[^]