Hi,
I Have data stored with the following structure:

Version Month Amount
1 Brand1 Jan 100
1 Brand1 Feb 200
1 Brand1 Mar 150
1 Brand1 Apr 500
..
..
..


Id'like to transform it in the following table:


Version Jan Feb Mar Apr May ... Dec
1 Brand1 100 200 150 500 400 100


Can you address query to achieve this change?

Thanks in advance

well i have done that.. now i want to edit rows of datagrid . how do i do it?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.