<%@ Page Language="C#" AutoEventWireup="true"  %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
 
<script runat="server">
 
    protected void Page_Load(object sender, EventArgs e)
    {
        SqlDataAdapter da = new SqlDataAdapter("select id, name, email from test", 
	"Data Source=localhost;Initial Catalog=test;User Id=;Password=;");
        DataSet ds = new DataSet();
        da.Fill(ds);
        ds.DataSetName = "parent";
        ds.Tables[0].TableName = "child";
        Response.Write("<?xml version="1.0" encoding="utf-8"?>");
        Response.Write(ds.GetXml());
    }
</script>

<?xml version="1.0" encoding="utf-8"?>
<mx:Application xmlns:mx="http://www.adobe.com/2006/mxml" 
	layout="vertical" 
	backgroundColor="#FFFFFF"
	creationComplete="init()" >
 
	<mx:Script>
		<![CDATA[
			import mx.rpc.events.FaultEvent;
			import mx.controls.Alert;
			import mx.rpc.events.ResultEvent; 
 
			private function init():void{
				// Send request to httpservice
				hsData.send();
			}
 
			private function httpFaultHandler(event:FaultEvent):void{
				// If you want to something
				Alert.show("There was a problem","Error");
			}
 
			private function httpResultHandler(event:ResultEvent):void{
				// If you want to something		
			}
 
		]]>
	</mx:Script>
 
	<mx:HTTPService id="hsData" url="http://localhost/flextest/Default.aspx" 
		fault="httpFaultHandler(event)"
		result="httpResultHandler(event)"
		method="POST"
		/>
 
	<mx:DataGrid id="dg" dataProvider="{hsData.lastResult.parent.child}">
  		<mx:columns>
            <mx:DataGridColumn headerText="ID" dataField="id"/>
            <mx:DataGridColumn headerText="Name" dataField="name"/>
            <mx:DataGridColumn headerText="EMail" dataField="email"/>
        </mx:columns>
	</mx:DataGrid>
 
</mx:Application>