show grid column dynamically

Hi. how to show grid columns dynamically; i.e users can select columns to display?
Parents
  • Hi.
    Thanks for your quick and complete replies. :)

    I have many columns in database (about 20 columns or much), displaying all of them at once isn't good and necessary always. So i just want if i can let user to select desired columns and time stamp condition. SQL query for this would be as simple as below:

    [code] select time_stamp, col1, col2, col3 from TrendData where time_stamp>=$t1 and time_stamp><=$t2[/code]

    I'm very pleased if you post your last works which you mentioned here.


    How i can apply this custom query to grid object?
    if it isn't possible i'm going to select all columns and hide undesired columns by applying blank label to that columns.
Reply
  • Hi.
    Thanks for your quick and complete replies. :)

    I have many columns in database (about 20 columns or much), displaying all of them at once isn't good and necessary always. So i just want if i can let user to select desired columns and time stamp condition. SQL query for this would be as simple as below:

    [code] select time_stamp, col1, col2, col3 from TrendData where time_stamp>=$t1 and time_stamp><=$t2[/code]

    I'm very pleased if you post your last works which you mentioned here.


    How i can apply this custom query to grid object?
    if it isn't possible i'm going to select all columns and hide undesired columns by applying blank label to that columns.
Children
No Data