Create Coulmns Dynamiclly with changed of values over time

[Ane]

Hi there;

I’m tryring to create a radGrid with data from database

What I want to do that I already convert some rows to columns in the database query:

SELECT  Z.id , WR. NAME,

 NVL(MAX(DECODE (Z.ZONE , 'A', Z.n )),0) A,

 NVL(MAX(DECODE ( Z.ZONE , 'B', Z.n )),0)B,

 NVL(MAX(DECODE ( Z.ZONE , 'M', Z.n )),0) M

 FROM  ………………

And I need to publish this data in a radgrid

What is the problem?

That this columns actually change over time, so I can’t keep them static

 

My idea is to loop through this values(A,B,M,….) in c# code-behind  and  convert them to columns in a command string ? Is it possible to do so?

[Eyup]

Hello Afra,

You can achieve this requirement using the implementation demonstrated in the following article:
http://docs.telerik.com/devtools/aspnet-ajax/controls/grid/defining-structure/changing-the-grid-structure-dynamically-on-postback

I hope this will prove helpful.

Regards,
Eyup
Telerik by Progress