Call a web service that queries a SQL database and returns data to Flex

         

<?xml version="1.0" encoding="utf-8"?>
<mx:Application xmlns:mx="http://www.adobe.com/2006/mxml" xmlns="*" layout="absolute" creationComplete="userRequest.returnRecords()">
  <mx:VBox>
    <mx:Label text="Username" />
    <mx:TextInput id="username" />
    <mx:Button label="Submit" click="clickHandler()" />
      <mx:DataGrid id="dgUserRequest">
        <mx:columns>
          <mx:DataGridColumn headerText="User ID" dataField="USERID" />
          <mx:DataGridColumn headerText="User Name" dataField="USERNAME" />
        </mx:columns>
      </mx:DataGrid>
  </mx:VBox>
  <mx:WebService id="userRequest" wsdl="http://localhost/a.php?wsdl">
    <mx:operation name="returnRecords" resultFormat="object" fault="mx.controls.Alert.show(event.fault.faultString)"
      result="remotingCFCHandler(event)" />
    <mx:operation name="insertRecord" result="insertCFCHandler()" fault="mx.controls.Alert.show(event.fault.faultString)" />
  </mx:WebService>
  <mx:Script>
    
    import mx.rpc.events.ResultEvent;
    private function remotingCFCHandler(e:ResultEvent):void
    {
      dgUserRequest.dataProvider = e.result;
    }
    private function insertCFCHandler():void
    {
      userRequest.returnRecords();
    }
    private function clickHandler():void
    {
      userRequest.insertRecord(username.text);
    }
    
  </mx:Script>
</mx:Application>

Related examples in the same category

1.	Feed returning value from WebService to a DataGrid
2.	A load event for WebService
3.	A fault event for WebService
4.	Call service with WebService
5.	Call web service wsdl with WebService and operation in MXML
6.	Call WebService with ActionScript
7.	Call WebService with operation names
8.	Explicit parameter passing with RemoteObject and WebService components
9.	Define name space for WebService
10.	WebService error event
11.	Get result for WebService call
12.	Convert returning value from WebService to ArrayCollection
13.	Call a web service
14.	Use a web service to process form input data
15.	Call a web service and assign returning value to form controls
16.	Call web service with operation defined
17.	Web Service Fault Event
18.	Web Service Multiple Operations
19.	Web Service Operation
20.	Web Service Result Event
21.	Web Service With Bindings
22.	Web Service Bounded Params
23.	Get DataSet from ASP.net web service
24.	Call Asp.net asmx web service
25.	Call Asp.net web service and pass parameters
26.	Use Web service to validate input
27.	Adding a web service to process form input data.
28.	Call WSDL service
29.	Call method in WSDL file
30.	Create a namespace object for soap:Body

Call a web service that queries a SQL database and returns data to Flex : WebService « Data Model « Flex

Related examples in the same category