how to switch rows of table of sql to column of gridview

Hi,
Create a procedure in your sql for the below query and then call your stored procedure from your code

DECLARE @cols AS NVARCHAR(MAX),

@query AS NVARCHAR(MAX)

select @cols = STUFF((SELECT ',' + QUOTENAME(ColumnName)

from yourtable

group by ColumnName, id

order by id

FOR XML PATH(''), TYPE

).value('.', 'NVARCHAR(MAX)')

,1,1,'')

set @query = 'SELECT ' + @cols + ' from

(

select value, ColumnName

from yourtable

) x

pivot

(

max(value)

for ColumnName in (' + @cols + ')

) p '

execute(@query)

Regards,
Iftikar