My data is:
studentid cid cname place
row1 01 01 english shanghai
row2 01 02 math tokyo
row3 02 01 english shanghai
I want to show:
studentid english math
01 shanghai tokyo
02 shanghai
And I want to show the columns "english" and "math" according to the data in database.
if there is no math class. Just show
studentid english
01 shanghai
02 shanghai
Could you please tell me how to do that by telerik gridview, thanks.
Thank you so much for your help.
studentid cid cname place
row1 01 01 english shanghai
row2 01 02 math tokyo
row3 02 01 english shanghai
I want to show:
studentid english math
01 shanghai tokyo
02 shanghai
And I want to show the columns "english" and "math" according to the data in database.
if there is no math class. Just show
studentid english
01 shanghai
02 shanghai
Could you please tell me how to do that by telerik gridview, thanks.
Thank you so much for your help.