Hi Don, If you remove the columns specification from the mxml of your DataGrid declaration, I believe the grid should show all fields of your dataprovider by default. In that case, your DataGrid would look like the following:
<mx:DataGrid editable="true" alternatingItemColors="[#ece8ff, #ffffff]" id="cfgrid" width="100%" height="190" alpha="1.0" /> If you need greater control over which specific fields are to be displayed in the grid, you can create the grid column objects dynamically in the getQuery_result() function and assign an array populated with those objects to the grid's columns property. That code would look something like the following: var myColumns: Array = []; // maybe in some sort of loop based on RO results var myDGC: DataGridColumn = new DataGridColumn(); myDGC.dataField = someField; myDGC.headerText = "Some Header Text"; // ... set more properties as needed myColumns.push(myDGC); cfgrid.columns = myColumns; You can probably find some examples of this on CFlex or other sites. HTH, Doug --- In [email protected], "nasawebguy" <[EMAIL PROTECTED]> wrote: > > I have tables in the database that the user can change via a > ColdFusion application, therefore the columns in my Flex DataGrid > need to be dynamic. How do I modify the code below to dynamically > generate the gridcolumns? > > Thanks, > Don Kerr > > <?xml version="1.0" encoding="utf-8"?> > <mx:Application xmlns:mx="http://www.adobe.com/2006/mxml"; > layout="absolute" creationComplete="initApp()"> > > <mx:Script> > <![CDATA[ > import mx.collections.ArrayCollection; > import mx.rpc.events.ResultEvent; > > public function initApp():void > { > cfdata.getQuery(); > } > > public function getQuery_result(event:ResultEvent):void > { > cfgrid.dataProvider = event.result as > ArrayCollection; > } > > ]]> > </mx:Script> > > <mx:RemoteObject > id="cfdata" showBusyCursor="true" > destination="ColdFusion" > source="forms.Simple"> > <mx:method name="getQuery" result="getQuery_result > (event)" /> > </mx:RemoteObject> > > > <mx:Panel label="Simple Grid" width="100%" height="100%" > horizontalCenter="0"> > > > <mx:DataGrid editable="true" > alternatingItemColors="[#ece8ff, #ffffff]" id="cfgrid" width="100%" > height="190" alpha="1.0"> > <mx:columns> > <mx:DataGridColumn dataField="??" /> > </mx:columns> > </mx:DataGrid> > > </mx:Panel> > > </mx:Application> >
