asp.net Ajax 直接返回DataTable

1. 在 aspx 页面加入

    <asp:ScriptManager ID="ScriptManager1" EnablePageMethods="true" runat="server">
    </asp:ScriptManager>

                    注意：  EnablePageMethods="true"

 

2.在后台加上共享方法

      <System.Web.Services.WebMethod()> _
    Public Shared Function queryShipSetting() As DataTable
        Dim db As BaseDataProvider = DbSelector.GetDbClass
        Dim sqlText = " select * from sp_getshipprintsetting('01','ois')as(compid varchar,empid varchar,date varchar,fieldname varchar,fielddesc varchar,posx integer,posy integer,posalign varchar,fontfamily varchar,fontsize integer,islock varchar,selected varchar);"
        Dim dt As DataTable = db.GetDataTable(sqlText)
        Return dt
        'Dim json As New System.Web.Script.Serialization.JavaScriptSerializer()
        'Dim JsonString As String = json.Serialize(dt)
        'Return JsonString
    End Function

 

 

3. 在 js 中调用

        function loadFields() {
            PageMethods.queryShipSetting(queryShipSetting_success);

        }

 

        function queryShipSetting_success(result) {
            var rows = result.rows;
            for (var i = 0; i < rows.length; i++) {
               
                ArrFields[i] = new Object()
                ArrFields[i].text = rows[i]["fielddesc"];
                ArrFields[i].fieldName = rows[i]["fieldname"];

        }