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

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

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

Answers

convert row to column

Manoj Mandal

673

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

CONVERT TO

	A	B
APRIL	12	17
MAY	23	34

Answers (2)

Next Recommended Forum

how to use pivot for this task

I need to pass textbox values into url

Forum Statistics

Please welcome our newest member Abhishek Yadav.
3,089,464 users have contributed to 147,411 threads and 483,549
In the past 24 hours, we have 4 new threads, 11 new posts, and 142 new users.
In last week, the most popular thread is 'what is Pandas how to use?'.

Upcoming Events

View all

Vibe Coding Bootcamp
Software Architecture Conference - 2025
AI Agents Conference - 2025