Ajax call .net web service

deadmask

Hi,
i used a Server-Side processing to load a data. When I call my .net Web Service, return this error :

DataTable warning : table id=example -Ajax error. For more information about this error, please see http://datatables.net/tn/7

But I don't understand this error.

This is my code

        $('#example').dataTable( {
           "processing": true,
           "serverSide": true,
           "ajax": "WebService.asmx/GetData"
        } ); 

Can you help me?

Thanks

tangerine

But I don't understand this error.

It's explained in the link: http://datatables.net/tn/7

You should follow the explanation to find out what status code was returned by the ajax request.

deadmask

500 Internal Error is the error.

Error description :

                Request format not recognized. URL ends unexpectedly with '/ GetData'

If I call the WebMethod with Jquery ajax i have a positive return.
Code :

        $.ajax({
           type: "POST",
           url: "WebService/GetData",
           cache: false,
           contentType: "application/json; charset=utf-8",
           data: "{}",
           dataType: "json",
           success: function (data) {
             alert(data.d);
           }
        });

I also decorated my WebService with <System.Web.Script.Services.ScriptService()>.

allan

Sounds like there might be a routing problem, or if you need to add the contentType header,t hen you can use ajax as an object and pass the option in.

Allan

deadmask

I solved this problem. The error was due to the configuration of the call to the WebMethod.
This is the correct code :

         $('#example').dataTable({
            "processing": true,
            "serverSide": true,
            "ajax": {
                type: "POST",
                url: "WebService/GetData",
                contentType: "application/json; charset=utf-8",
                data: "{}",
                dataType: "json"
            }
        });

Now, I have a new error : -.-

         Sys.ParameterCountException: Mismatch in the number of parameters

I followed this guide : http://datatables.net/manual/server-side, for set the input parameters.

This is the first definition of the method that i used:

         Public Function GetData(draw As Integer, start As Integer, length As Integer, searchValue() As String, searchRegex() As String, order() As Object, columns() As Object) As String 

This is the second:

            Public Function GetData(draw As Integer, start As Integer, length As Integer, searchValue() As String, searchRegex() As String, orderColumn() As Integer, orderDir() As String, columnsData() As String, columnsName() As String, columnsSearchable() As Boolean, columnsOrderable() As Boolean, columnsSearchValue() As String, columnsSearchregex() As String) As String

And this is the last :

         Public Function GetData(draw As Integer, start As Integer, length As Integer, searchValue As String, searchRegex As String, orderColumn As Integer, orderDir As String, columnsData As String, columnsName As String, columnsSearchable As Boolean, columnsOrderable As Boolean, columnsSearchValue As String, columnsSearchregex As String) As String

Can you help (again) me?

Thanks