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

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