webService asp.net + access
数据库名db1
数据库表名test
字段名 test1 test2 test3 都是文本类型
随便输入一些数据
webService端测试代码
1 OleDbConnection myConnection;
2 OleDbDataAdapter myDataAdapter;
3
4 public Service () {
5
6 //Uncomment the following line if using designed components
7 //InitializeComponent();
8
9
10
11 string dbname;
12 dbname=Server.MapPath("db1.mdb");
13 myConnection = new OleDbConnection( "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source="+dbname );
14 myConnection.Open();
15
16 }
17
18 [WebMethod]
19 public string getInfo()
20 {
21 string sql = "SELECT * from test";
22 myDataAdapter = new OleDbDataAdapter(sql, myConnection);
23
24
25 DataSet ds = new DataSet();
26 ds.DataSetName = "testName";
27 myDataAdapter.Fill(ds, "test");
28
29 return ds.GetXml();
30
31 }
32
2 OleDbDataAdapter myDataAdapter;
3
4 public Service () {
5
6 //Uncomment the following line if using designed components
7 //InitializeComponent();
8
9
10
11 string dbname;
12 dbname=Server.MapPath("db1.mdb");
13 myConnection = new OleDbConnection( "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source="+dbname );
14 myConnection.Open();
15
16 }
17
18 [WebMethod]
19 public string getInfo()
20 {
21 string sql = "SELECT * from test";
22 myDataAdapter = new OleDbDataAdapter(sql, myConnection);
23
24
25 DataSet ds = new DataSet();
26 ds.DataSetName = "testName";
27 myDataAdapter.Fill(ds, "test");
28
29 return ds.GetXml();
30
31 }
32
flex端测试代码
1 <?xml version="1.0" encoding="utf-8"?>
2 <mx:Application xmlns:mx="http://www.adobe.com/2006/mxml" layout="absolute" creationComplete="Init()">
3 <mx:WebService wsdl="http://127.0.0.1/web/Service.asmx?wsdl" useProxy="false" id="_webServer" >
4 <mx:operation name="getInfo" result="OnGetInfoResult(event)">
5
6 </mx:operation>
7
8 </mx:WebService>
9
10 <mx:Script>
11 <![CDATA[
12 import mx.rpc.events.ResultEvent;
13 import mx.controls.Alert;
14 [Bindable]
15 private var _dataSource:XMLList;
16
17 private function Init():void{
18 _webServer.getInfo();
19 }
20
21 private function OnGetInfoResult(e:ResultEvent):void{
22 _dataSource = XML(e.result).children();
23 }
24 ]]>
25 </mx:Script>
26 <mx:DataGrid x="48" y="88" width="387" height="304" dataProvider="{_dataSource}">
27 <mx:columns>
28 <mx:DataGridColumn headerText="test 1" dataField="test1"/>
29 <mx:DataGridColumn headerText="test 2" dataField="test2"/>
30 <mx:DataGridColumn headerText="test 3" dataField="test3"/>
31 </mx:columns>
32 </mx:DataGrid>
33 </mx:Application>
34
2 <mx:Application xmlns:mx="http://www.adobe.com/2006/mxml" layout="absolute" creationComplete="Init()">
3 <mx:WebService wsdl="http://127.0.0.1/web/Service.asmx?wsdl" useProxy="false" id="_webServer" >
4 <mx:operation name="getInfo" result="OnGetInfoResult(event)">
5
6 </mx:operation>
7
8 </mx:WebService>
9
10 <mx:Script>
11 <![CDATA[
12 import mx.rpc.events.ResultEvent;
13 import mx.controls.Alert;
14 [Bindable]
15 private var _dataSource:XMLList;
16
17 private function Init():void{
18 _webServer.getInfo();
19 }
20
21 private function OnGetInfoResult(e:ResultEvent):void{
22 _dataSource = XML(e.result).children();
23 }
24 ]]>
25 </mx:Script>
26 <mx:DataGrid x="48" y="88" width="387" height="304" dataProvider="{_dataSource}">
27 <mx:columns>
28 <mx:DataGridColumn headerText="test 1" dataField="test1"/>
29 <mx:DataGridColumn headerText="test 2" dataField="test2"/>
30 <mx:DataGridColumn headerText="test 3" dataField="test3"/>
31 </mx:columns>
32 </mx:DataGrid>
33 </mx:Application>
34
轻松搞定 flex 的dataGrid通过webService和数据库进行绑定
其中有一个设计理念就是 在不同的语言之间进行数据通讯的时候 设计的接口我提议使用标准的数据类型
至于到达表示端 如果不能满足表示端的需求 则只需要在表示端写适配器类