No data available in table

No data available in table

CoroboriCorobori Posts: 5Questions: 1Answers: 0

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>

Replies

  • kthorngrenkthorngren Posts: 19,983Questions: 26Answers: 4,703

    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

  • CoroboriCorobori Posts: 5Questions: 1Answers: 0

    Spot on ! Thank you

Sign In or Register to comment.