I am using code provided from the Code Gallery http://resources.esri.com/arcgisserver/apis/flex/index.cfm?fa=codeGalleryDetails&scriptID=15872 to try and populate a datagrid with data obtained in a HTTPservice. The webservice was written by me and works fine. I have used it in other applications. the code I am using on the HTTPserice is as follows: I know I need to take the results and create a ArrayCollection but I am having problems figuring out the correct code so it will iterate through the selected points and return the data to the datagrid. Any assistance would be greatly appriciated. Thanks Richard Krell Chicago Metropolitan Agency for Planning

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

populate a datagrid from a HTTPservice

RichardKrell

I am using code provided from the Code Gallery http://resources.esri.com/arcgisserver/apis/flex/index.cfm?fa=codeGalleryDetails&scriptID=15872 to try and populate a datagrid with data obtained in a HTTPservice. The webservice was written by me and works fine. I have used it in other applications. the code I am using on the HTTPserice is as follows:

<mx:HTTPService id="hsID"
url="http://data.cmap.illinois.gov/ws/tip/tipservice.asmx/getproject"
showBusyCursor="true"
requestTimeout="120"
useProxy="false"/>

I know I need to take the results and create a ArrayCollection but I am having problems figuring out the correct code so it will iterate through the selected points and return the data to the datagrid.
Any assistance would be greatly appriciated.

Thanks
Richard Krell
Chicago Metropolitan Agency for Planning

Trouver plus de publications taguées avec

Accepted answers

All comments

RobertScheitlin__GISP

Richard,

Good, as I am not in that list I can not test to see if it works but everything in the code looks good so give it a test.

RichardKrell

Thaks Robert,
I was just in the process of re-writing the code into 3. Yes, I am part of the crossdomain.

RobertScheitlin__GISP

Richard,

Here is Rene's code downgraded for Flex Builder 3

The real question is are you part of the domains that has access to this web service look at the http://data.cmap.illinois.gov/crossdomain.xml
is your machine part of one of these?

<allow-http-request-headers-from domain="*.pathfinder-development.com" headers="*"/>
<allow-http-request-headers-from domain="*.greatarc.com" headers="*"/>
<allow-http-request-headers-from domain="208.70.17.37" headers="*"/>
<allow-http-request-headers-from domain="localhost" headers="*"/>

If so then Rene's code should work.

<?xml version="1.0" encoding="utf-8"?>
<mx:Application xmlns:mx="http://www.adobe.com/2006/mxml" 
 layout="vertical" creationComplete="init()">
 <mx:Script>
  <![CDATA[
   import mx.collections.ArrayCollection;
   import mx.controls.Alert;
   import mx.rpc.events.FaultEvent;
   import mx.rpc.events.ResultEvent;
   import mx.rpc.soap.mxml.WebService;
   
   protected var service:WebService;
   
   protected function init():void {
    service = new WebService();
    service.showBusyCursor = true;
    service.wsdl = "http://data.cmap.illinois.gov/ws/tip/tipservice.asmx?wsdl";
    service.addEventListener(ResultEvent.RESULT, onResultsLoaded_handler);
    service.addEventListener(FaultEvent.FAULT, onFault_handler);
    service.loadWSDL();
   }
   
   protected function onFault_handler(event:FaultEvent):void {
    Alert.show("Error in calling service: " + event.message, "Error");
   }
   
   protected function onResultsLoaded_handler(event:ResultEvent):void {
    try {
     dgResults.dataProvider = event.result as ArrayCollection;
    }
    catch (e:Error) {
     Alert.show("An error occurred loading results: " + e.message, "Results error");
    }
   }
   
   
   protected function btnRequest_clickHandler(event:MouseEvent):void {
    
    service.getproject(input.text);
   }
  ]]>
 </mx:Script>

 <mx:TextInput id="input"
     width="200" />
 <mx:Button id="btnRequest"
     label="Send Request"
     width="200"
     click="btnRequest_clickHandler(event)" />
 <mx:DataGrid id="dgResults"
     width="800"
     height="300" />
</mx:Application>

RichardKrell

Is this code written in Flash 4 or Flex 3.6 because although we are due for upgrading we are still working in 3.6?

Ok, sorry. I got confused reading your earlier posts. Looking at what you have, you actually want to use a WebService, not an HTTPService. You'd use a WebService to send requests to a function and get results. An HTTPService would be used to load something like an XML or Text file.

Here is an example of using a WebService with your service. Don't worry about converting to XML unless that's your thing.

<?xml version="1.0" encoding="utf-8"?>
<s:Application xmlns:fx="http://ns.adobe.com/mxml/2009"
               xmlns:s="library://ns.adobe.com/flex/spark"
               xmlns:mx="library://ns.adobe.com/flex/mx"
               minWidth="955"
               minHeight="600"
               applicationComplete="init()">
 
    <fx:Declarations>
        <!-- Place non-visual elements (e.g., services, value objects) here -->
    </fx:Declarations>
    <fx:Script>
        <![CDATA[
            import mx.collections.ArrayCollection;
            import mx.controls.Alert;
            import mx.rpc.events.FaultEvent;
            import mx.rpc.events.ResultEvent;
            import mx.rpc.soap.mxml.WebService;
 
            protected var service:WebService;
 
            protected function init():void {
                service = new WebService();
                service.showBusyCursor = true;
                service.wsdl = "http://data.cmap.illinois.gov/ws/tip/tipservice.asmx?wsdl";
                service.addEventListener(ResultEvent.RESULT, onResultsLoaded_handler);
                service.addEventListener(FaultEvent.FAULT, onFault_handler);
                service.loadWSDL();
            }
 
            protected function onFault_handler(event:FaultEvent):void {
                Alert.show("Error in calling service: " + event.message, "Error");
            }
 
            protected function onResultsLoaded_handler(event:ResultEvent):void {
                try {
                    dgResults.dataProvider = event.result as ArrayCollection;
                }
                catch (e:Error) {
                    Alert.show("An error occurred loading results: " + e.message, "Results error");
                }
            }
 
 
            protected function btnRequest_clickHandler(event:MouseEvent):void {
 
                service.getproject(input.text);
            }
        ]]>
    </fx:Script>
    <s:layout>
        <s:VerticalLayout gap="5"
                          horizontalAlign="center"
                          paddingTop="25" />
    </s:layout>
    <s:TextInput id="input"
                 width="200" />
    <s:Button id="btnRequest"
              label="Send Request"
              width="200"
              click="btnRequest_clickHandler(event)" />
    <mx:DataGrid id="dgResults"
                 width="800"
                 height="300" />
</s:Application>

Now as far as how this relates to the example you linked in your first post, the above will get you the ArrayCollection of results you were looking for in your first post. Now you can use those results to create a "where" query on your map service.

RichardKrell

Thanks for the latest response and believe me I will look at it. I spent last evening working on this and I came up with something different.

I am also attaching the file and the actionscript class file. Again, unfortunetly these are examples I found as I was researching this. I know it is probably that I have been working on this for so long that it has become so hard but I really do appriciate everyone's help.

datagrid.txt.zip

NestedDataGridColumn.txt.zip

ReneRubalcava

<?xml version="1.0" encoding="utf-8"?>
<s:Application xmlns:fx="http://ns.adobe.com/mxml/2009"
      xmlns:s="library://ns.adobe.com/flex/spark"
      xmlns:mx="library://ns.adobe.com/flex/mx"
      minWidth="955"
      minHeight="600"
      applicationComplete="init()">

 <fx:Declarations>
  <!-- Place non-visual elements (e.g., services, value objects) here -->
 </fx:Declarations>
 <fx:Script>
  <![CDATA[
   import mx.collections.ArrayCollection;
   import mx.controls.Alert;
   import mx.rpc.events.FaultEvent;
   import mx.rpc.events.ResultEvent;
   import mx.rpc.soap.mxml.WebService;
   
   protected var service:WebService;
   
   protected function init():void {
    service = new WebService();
    service.showBusyCursor = true;
    service.wsdl = "http://data.cmap.illinois.gov/ws/tip/tipservice.asmx?wsdl";
    service.addEventListener(ResultEvent.RESULT, onResultsLoaded_handler);
    service.addEventListener(FaultEvent.FAULT, onFault_handler);
    service.loadWSDL();
   }
   
   protected function onFault_handler(event:FaultEvent):void {
    Alert.show("Error in calling service: " + event.message, "Error");
   }
   
   protected function onResultsLoaded_handler(event:ResultEvent):void {
    try {
     dgResults.dataProvider = event.result as ArrayCollection;
    }
    catch (e:Error) {
     Alert.show("An error occurred loading results: " + e.message, "Results error");
    }
   }
   
   
   protected function btnRequest_clickHandler(event:MouseEvent):void {
    
    service.getproject(input.text);
   }
  ]]>
 </fx:Script>
 <s:layout>
  <s:VerticalLayout gap="5"
        horizontalAlign="center"
        paddingTop="25" />
 </s:layout>
 <s:TextInput id="input"
     width="200" />
 <s:Button id="btnRequest"
     label="Send Request"
     width="200"
     click="btnRequest_clickHandler(event)" />
 <mx:DataGrid id="dgResults"
     width="800"
     height="300" />
</s:Application>

RichardKrell

Robert,
To be honest I am getting confused and that is probably my biggest problem. I took some code as I mentioned in the beginning that was using the querytask and now I am trying to re-write it to use HTTPservice.

I have always had problems with this and I don't know why. I have done apps in VB, Avenue, and many others for years but this Flex for some reason has me tearing my hair out.

So yes I am trying to use HTTPservice to retrieve these records. I know the webservice is OK because I have been using it. You can try it if you want and just enter a ID 01-06-0068. I will return one record.

RobertScheitlin__GISP

Richard,

You definently have me confused then as your code snippet above had

var queryTask:QueryTask = new QueryTask();

 
queryTask.url = "http://data.cmap.illinois.gov/ArcGIS/rest/services/Maps/TIP_Test/MapServer/0";

So are you talking about querying a map service layer using the query task or a web service like you began this thread with???

RichardKrell

I am trying to retrieve the information from a SQL database via a HTTPservice not through the featureset.

RobertScheitlin__GISP

Richard,

Just change your onXMLResult to

function onXMLResult(featureSet:FeatureSet, token:Object = null):void

RichardKrell

I started this thread the other day in an attempt to resolve a coding problem I am having and received some really good answers. But after being deverted for a day on another project I am back and hate to keep being such a bother but I am truely over my perverbial head. Below is the funtion I am trying to get working but I keep getting an error 1034 telling me I cannot covert a featureset into an resultevent. I believe I understand the error but don't understand where it is coming from.


//*************************************************************************
public function runQueryTask(geometry:Geometry):void {

 
//*************************************************************************
[INDENT]

var queryTask:QueryTask = new QueryTask();


 

queryTask.url = "http://data.cmap.illinois.gov/ArcGIS/rest/services/Maps/TIP_Test/MapServer/0";

 
 
 
[LEFT]var query:Query = new Query();

query.geometry = geometry;
[LEFT]query.returnGeometry = true;
query.spatialRelationship = "esriSpatialRelContains";
query.outFields = ['PROID','PROGRAMMIN','COMPLETION'];[/LEFT]
[/LEFT]

 
 
 
 

queryTask.execute(query, new AsyncResponder(onXMLResult, onFault));

 
 
 

function onXMLResult(event:ResultEvent, token:Object=null):void{

 
 
[INDENT]

//xml = event.result.ArrayOfTipproject.tipproject;


 
[LEFT]var xmlListCollection:XMLListCollection = new XMLListCollection;

xmlListCollection.source = new XMLList(event.result.ArrayOfTipproject.tipproject);
[LEFT]var items:Array = [];
foreach(var queryXML:XML in xmlListCollection){[/LEFT]
[/LEFT]

 
 
 
[INDENT]

var obj:Object = {


 

project:queryXML.@PROID,

agency:queryXML.@PROGRAMMIN


 
 
 
 
[/INDENT]}
 
[/INDENT]}

items.push(obj);

 
[/INDENT]}

ReneRubalcava

Try this
You can go XML -> Array or ArrayCollection
Don't forget to set your result format.
service.resultFormat = "e4x";

var xml:XML = event.result as XML;
var items:Array = [];
for each (var queryXML:XML in xml.tipProject) {
 var obj:Object = {
 project:queryXML.@project,
 agency:queryXML.@agency // and so on adding the fields you want
 }
 items.push(obj);
}

You can also turn it into an XMLListCollection
var xmlListCollection:XMLListCollection = new XMLListCollection();
xmlListCollection.source = new XMLList( event.result );

You can then treat the XMLListCollection like an ArrayCollection

When dealing with an HTTPService, your results are easy to parse in XML, I never used ArrayCollection with an HTTPService result, but I think the event.result object is xml by default.

RichardKrell

A little more info.

Here is what I am working with right now trying to get it working.

function onXMLResult(event:ResultEvent, featureSet:FeatureSet, token:Object = null😞void{
for(var i:uint = 0; i < featureSet.features.length; i++){
xml = event.result.ArrayOfTipproject.tipproject;
}
dgrid1.dataProvider = xml;

}

Needless to say, it is not working but I have just written it and am working through the errors.

RichardKrell

I appriciate everyone's response and I guess I haven't explained myself. The progblem is not the service call. As I said that is working fine. Where I am having problems is creating an ArrayCollection that will populate my grid with all the records that have been selected.

thanks
Richard Krell
Chicago Metropolitian Agency for Planning.

RobertScheitlin__GISP

Richard,

If you what to know how to do it without using adobes autogenerated code than all you have to do is this

private function getproject_result(evt:ResultEvent):void {
       var pRslt:Object = evt.result;
}

<mx:WebService id="webService" wsdl="http://data.cmap.illinois.gov/ws/tip/tipservice.asmx?wsdl" showBusyCursor="true">
        <mx:operation name="getproject"
                resultFormat="object"
                fault="getproject_fault(event);"
                result="getproject_result(event);">
                <mx:request><projectid>{sProjectId}</projectid></mx:request>
        </mx:operation>
    </mx:WebService>

DasaPaddock

You may want to try using Flash Builder's Data -> Connect to HTTP... menu option. This wizard will generate code that you can use to call your service.

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.