convert row to column

Question

APRIL A 12 APRIL B 17 MAY A 23 MAY B 34 CONVERT TO A B APRIL 12 17 MAY 23 34

Manoj Mandal · Answer

hi thanks for the replay but i want display in gridview using c#

Ramesh Palanivel · Answer

Hi Manoj Kindly explain briefly whether you want to display the record row to column in sql query or datagridview? If it is sql server kindly try the below link it will help you to achieve your task they gave some samples with different way https://forums.asp.net/t/1967025.aspx?how+to+display+row+values+in+columns+in+sql+server+2008