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();
??? }

//运行结果