flex datagrid .net

最新推荐文章于 2019-03-02 15:32:26 发布

logenliqiang

最新推荐文章于 2019-03-02 15:32:26 发布

阅读量284

点赞数

分类专栏： ASP.NET 文章标签： datagrid flex .net webservice application dataset

本文链接：https://blog.youkuaiyun.com/logenliqiang/article/details/5329260

版权

ASP.NET 专栏收录该内容

38 篇文章

订阅专栏

==============flex===========

<?xml version="1.0" encoding="utf-8"?>
<mx:Application xmlns:mx="http://www.adobe.com/2006/mxml" layout="absolute" initialize="Service.GetCustomers.send();" width="689" height="592">

    <mx:WebService id="Service" wsdl="http://localhost:4702/flex/Service.asmx?WSDL" useProxy="false">
        <mx:operation name="GetCustomers">

        </mx:operation>

</mx:WebService>

    <mx:DataGrid x="25" width="100%" y="10" dataProvider="{Service.GetCustomers.lastResult.Tables.customer.Rows}">
        <mx:columns>
            <mx:DataGridColumn headerText="ID" dataField="id"/>
            <mx:DataGridColumn headerText="标题" dataField="title"/>
            <mx:DataGridColumn headerText="内容" dataField="content"/>
            <mx:DataGridColumn headerText="时间" dataField="time"/>
            <mx:DataGridColumn headerText="类型" dataField="type"/>
        </mx:columns>
    </mx:DataGrid>

</mx:Application>

=========flex=======================

==========.net===================

Imports System.Web
Imports System.Web.Services
Imports System.Web.Services.Protocols
Imports System.Data
Imports System.Data.SqlClient

'若要允许使用 ASP.NET AJAX 从脚本中调用此 Web 服务，请取消对下行的注释。
' <System.Web.Script.Services.ScriptService()> _
<WebService(Namespace:="http://tempuri.org/")> _
<WebServiceBinding(ConformsTo:=WsiProfiles.BasicProfile1_1)> _
<Global.Microsoft.VisualBasic.CompilerServices.DesignerGenerated()> _
Public Class WebService2
Inherits System.Web.Services.WebService

    <WebMethod()> _
Public Function GetCustomers() As DataTable
        Dim ds As New DataSet()
        Using conn As New SqlConnection("Data Source=20091204-0832/SQLEXPRESS;Initial Catalog=nengyuan;Integrated Security=True")
            Using ada As New SqlDataAdapter("select * from index1", conn)
                ada.Fill(ds, "customer")
            End Using
        End Using
        Return ds.Tables("customer")
    End Function

End Class