No data available in table

Corobori

Hi,

I am trying to hook up a table to my SQL Server database and I am having some difficulties finding the correct way. The Ajax call appears to work, as shown in the print screen below, but no data is being displayed as I am getting "No data available in table"

I have uploaded my test form here

The data I am getting can be seen in the developer's tools

The table is has follow

  <table id="example" class="display" style="width:100%">
        <thead>
            <tr>
                <th>CustomerID</th>
                <th>CompanyName</th>
                <th>ContactName</th>
                <th>Address</th>
                <th>City</th>
                <th>Country</th>
            </tr>
        </thead>
        <tfoot>
            <tr>
                <th>CustomerID</th>
                <th>CompanyName</th>
                <th>ContactName</th>
                <th>Address</th>
                <th>City</th>
                <th>Country</th>
            </tr>
        </tfoot>
    </table>

The script is as this:

<script>

        $('#example').DataTable( {
            ajax: {
                type: "POST",
                contentType: "application/json; charset=utf-8",
                url: '/WebForm2.aspx/GetContacts',
                dataSrc: ''
            },
            columns:  [
                            { data: 'CustomerID' },
                            { data: 'CompanyName' }, 
                            { data: 'ContactName' },
                            { data: 'Address' },
                            { data: 'City' },
                            { data: 'Country' }
                        ]
            });

        </script>

kthorngren

Your response has the data in the d object. The d object value is a string. You will need to use ajax.dataSrc as a function to extract the JSON string and parse it to a Javascript object. Something like this I believe:

    "dataSrc": function ( data ) {

      data = JSON.parse(data.d);

      return data;
    }

Kevin

Corobori

Spot on ! Thank you