how use pivot concept in mysql data base in asp.net c#

Question

hi sir/mam

 

i need to show some gridview columns in both vertically and horzontally

using  pivto concept but here i'm using mysql database.

 

how can i use pivot in mysql