1 Reply Latest reply on Sep 19, 2006 2:53 PM by jasowill

    How to retrieve column names from XML or database?

    Anoopmu
      Hello. I want to populate a datagrid with the column names (not values of the columns) of an entity in a database (or from an XML file. Can anyone tell me how to tackle this?

      Thanks for your support.
        • 1. Re: How to retrieve column names from XML or database?
          jasowill
          Ideally you would probably want to make a remote procedure call to get the schema information for a given domain model which returns the column names, however, here is a simple example using e4x to extract the "column" names from some inline XML data.

          <?xml version="1.0" encoding="utf-8"?>
          <mx:Application xmlns:mx=" http://www.adobe.com/2006/mxml" initialize="initApp()">
          <mx:DataGrid id="customers" />
          <mx:XML id="custData" xmlns="">
          <customers>
          <customer name="Bob" company="Adobe" />
          <customer name="Sam" company="Google" />
          <customer name="Susan" company="Yahoo" />
          </customers>
          </mx:XML>
          <mx:Script>
          <![CDATA[
          import mx.controls.dataGridClasses.DataGridColumn;
          import mx.controls.List;
          private function initApp():void
          {
          var columnNames:XMLList = custData.customer[0].attributes();
          var columnList:Array = [];
          for (var i:int=0; i<columnNames.length(); i++)
          columnList.push(new DataGridColumn(columnNames .name()));
          customers.columns = columnList;
          }
          ]]>
          </mx:Script>
          </mx:Application>

          Hope that will give you a good start.