flex调用webservice中的datatable结果写入datagrid

webservice配置文件

 

<appSettings>
		<add key="sqlConDuke" value="server=10.9.34.88;database=PanoSalado;uid=sa;pwd=123"/>
	</appSettings>

Webservice代码

 

 

 //测试数据库连接
    [WebMethod(Description = "！！！测试数据库连接,链接字符串在web.config中")]
    public bool conectDB()
    {
        strCon = ConfigurationSettings.AppSettings["sqlConDuke"];
        conn = new SqlConnection(strCon);
        try
        {
            conn.Open();
            return true;
        }
        catch (Exception)
        {
            return false;
        }
        finally
        {
            conn.Close();
        }
    }

    [WebMethod(Description = "！！！获得所有数据(DataTable)，strTb,eg:PanView")]
    public DataTable getAllDT(string strTb)
    {
        bool ifCon = conectDB();
        if (ifCon)
        {
            string sql_BfCar = "SELECT * FROM " + strTb;
            da = new SqlDataAdapter(sql_BfCar, conn);
            myds = new DataSet();
            da.Fill(myds);
            mydt=myds.Tables[0];
            return mydt;
        }
        else
        {
            return null;
        }
    }

 

Flex代码：

 

<?xml version="1.0" encoding="utf-8"?>
<s:Application xmlns:fx="http://ns.adobe.com/mxml/2009" 
			   xmlns:s="library://ns.adobe.com/flex/spark" 
			   xmlns:mx="library://ns.adobe.com/flex/mx" minWidth="955" minHeight="600">
	<fx:Script>
		<![CDATA[ 
			import mx.collections.ArrayCollection;
			import mx.controls.Alert;
			import mx.rpc.events.FaultEvent;
			import mx.rpc.events.ResultEvent;

			[Bindable]
			public var arr:ArrayCollection=new ArrayCollection();
			
			protected function button1_clickHandler(event:MouseEvent):void
			{
				myWeb.getAllDT("PanView"); //分别为webservice中的方法和参数
			}
			internal function onSuccess(evt:ResultEvent):void
			{
				 arr=this.myWeb.getAllDT.lastResult.Tables.Table.Rows; //Table为webservice中的datatable名字
				 Alert.show(arr.length.toString());
			}

			protected function button2_clickHandler(event:MouseEvent):void
			{
				myWeb.getLinkDTByImgName("PanView","20131019072740-0000150");
			}
			internal function onSuccess1(evt:ResultEvent):void
			{
				arr=this.myWeb.getLinkDTByImgName.lastResult.Tables.Table.Rows;
				Alert.show(arr.length.toString());
			}
			
			internal function onFault(evt:FaultEvent):void
			{
				Alert.show("调用WebService方法失败，详细：" + evt.fault.faultDetail.toString());
			}

		]]>
	</fx:Script>
	<s:layout>
		<s:BasicLayout/>
	</s:layout>
	<fx:Declarations>
		<!-- 将非可视元素（例如服务、值对象）放在此处 -->
		<s:WebService id="myWeb" wsdl="http://10.19.1.55/serverPano/WebServiceDuke.asmx?WSDL" fault="onFault(event)">
			<s:operation name="getAllDT" result="onSuccess(event)"></s:operation>
			<s:operation name="getLinkDTByImgName" result="onSuccess1(event)"></s:operation>
		</s:WebService>
	</fx:Declarations>
	<mx:DataGrid x="121" y="177" width="737" height="402" id="dg1" dataProvider="{arr}"> 
		<mx:columns>
			<mx:DataGridColumn headerText="ID" dataField="ID"/> <!--webservice中datatable中的字段-->
			<mx:DataGridColumn headerText="ImageName" dataField="ImageName"/>
			<mx:DataGridColumn headerText="LinkGuid" dataField="LinkGuid"/>
		</mx:columns>
	</mx:DataGrid>
	<s:Button x="254" y="82" label="返回所有" click="button1_clickHandler(event)"/>
	<s:Button x="500" y="82" label="按照片名查询" click="button2_clickHandler(event)"/>
</s:Application>

 

 

转载于:https://www.cnblogs.com/riasky/p/3455215.html