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

Web/ASP .Net

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

Lㅓ부ㄹI 2009. 1. 24. 20:15

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;
        }
    }
}