Flex AdvancedDataGrid动态添加列并绑定数据库返回数据

//绑定数据库返回数据(myAVDG为AdvancedDataGrid的ID)

private function getStatInfoResult(e:ResultEvent):void
    {
    myAVDG.dataProvider=e.result;
    //动态生成图表
    orgAVDGData();
    }

    privatefunction orgAVDGData():void
    {
    myAVDG.validateNow();
    var counts:int=0;
    myAVDG.groupedColumns=new Array();

    var AdvHeards:AdvancedDataGridColumn=newAdvancedDataGridColumn();
    AdvHeards.dataField="id";
    AdvHeards.headerText="操作";
    
    var AdvHeardGroup:AdvancedDataGridColumnGroup=newAdvancedDataGridColumnGroup;
    AdvHeardGroup.headerText="日期为"+formatDate(startDate)+"-"+formatDate(endDate);
    
    myAVDG.groupedColumns=myAVDG.groupedColumns.concat(AdvHeards,AdvHeardGroup);
    
    AdvHeardGroup.children=[];
    var arrGroup:Array=new Array();
    for(var i:int=1;i<=arr.length;i++)
    {
      var AdvHeards1:AdvancedDataGridColumn=newAdvancedDataGridColumn();
      AdvHeards1.dataField="value"+i;
      AdvHeards1.headerText=busiNames[i-1];
      arrGroup.push(AdvHeards1);
    }
    //增加汇总列
    var AdvHeards2:AdvancedDataGridColumn=newAdvancedDataGridColumn();
    AdvHeards2.dataField="sum";
    AdvHeards2.headerText="汇总";
    arrGroup.push(AdvHeards2);
    
    AdvHeardGroup.children=AdvHeardGroup.children.concat(arrGroup);
    myAVDG.validateNow();
    }

//运行结果