Flex <-> asp <-> DB (WebService)

Flex Code
Flex mxml <?xml version="1.0" encoding="utf-8"?> <mx:Application xmlns:mx="http://www.adobe.com/2006/mxml" layout="absolute" width="697" height="592" borderStyle="inset"> <mx:Script> <![CDATA[ import mx.rpc.events.ResultEvent; import mx.controls.Alert; private function getHello(evt:ResultEvent):void { Alert.show(evt.result.toString()); } private function getTable(evt:ResultEvent):void { testgrid.dataProvider = evt.result.diffgram.DocumentElement.TestTable; }//모르겠으면 xml 데이터에서 내용 확인 ]]>//밑에 wsdl 주소를 그대로 치면 xml내용을 볼수 있음 </mx:Script> <mx:WebService id="WebTest" wsdl="http://localhost:1990/WebService1.asmx?wsdl"> <mx:operation name="HelloWorld" result="getHello(event)"/>//name 파라메터는 <mx:operation name="getData" result="getTable(event)" /> //C#에 있는 함수명 </mx:WebService> <mx:Button x="426" y="325" label="Button" click="WebTest.HelloWord()" borderColor="#004040"/> <mx:DataGrid x="329" y="355" id="testgrid"> <mx:columns> <mx:DataGridColumn headerText="No" dataField="NO"/> //dataField 명은 DB 컬럼명 <mx:DataGridColumn headerText="Hight" dataField="HEIGHT"/> <mx:DataGridColumn headerText="weight" dataField="WEIGHT"/> </mx:columns> </mx:DataGrid> </mx:Application>

ASP(C#)
using System.Data; using System.Web; using System.Collections; using System.Web.Services; using System.Web.Services.Protocols; using System.ComponentModel; using System.Data.OracleClient; namespace WebService_Test_01 { /// <summary> /// Service1의 요약 설명입니다. /// </summary> [WebService(Namespace = "http://tempuri.org/")] [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)] [ToolboxItem(false)] public class Service1 : System.Web.Services.WebService { [WebMethod] public string HelloWorld() { return "Hello World"; } private void InitializeComponent() { } [WebMethod] public DataTable getData() { DataTable table = new DataTable(); string strConn = "Server=XE;uid=metus;pwd=1111;"; string strQuery = "select * from TB_FLEX_TEST"; OracleConnection conn = new OracleConnection(strConn); conn.Open(); try { OracleDataAdapter da = new OracleDataAdapter(strQuery, conn); da.Fill(table); table.TableName = "TestTable"; } finally { conn.Close(); } return table; } } }