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

Question

how to switch rows of a table of sql server to column of gridview ?

Iftikar Hussain · Answer

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)') 11'') set @query = 'SELECT ' + @cols + ' from ( select value ColumnName from yourtable ) x pivot ( max(value) for ColumnName in (' + @cols + ') ) p ' execute(@query) Regards Iftikar