Datatable.js - not able to display data

Question

I am not able to retrieve data in datatable using datatable.js. The Json response is a string but in the output I get every character of the string in each row rather that jst two entries.

Please help. Thanks in advance

function fillGrid() {

    $.ajax({
        type: 'POST',
        url: 'BehindCode/client.aspx/fillgrid',

        cache: false,
        dataType: "json",
        contentType: "application/json; charset=utf-8",
        beforeSend: function () {

            $('#gridLoadingDiv').attr('style', 'display:block');
        },
        complete: function () {

            $('#gridLoadingDiv').attr('style', 'display:none');
        },
        data: "{}",

        success: function (data) {
            data = data.d;
            alert(data);

            $("#clientTable").DataTable({
                "searching": true,
                    "processing": true,
                    "data": data,

                    "columns": [{
                    "title": "CLIENT NAME"
                }]
            });
        }
    });
}

C# code..from where data is being retreived..

[WebMethod]

    public static string fillgrid()
    {
        BehindCode_client client = new BehindCode_client();

        string strfetch = "SELECT CLIENT_NAME FROM k_client_master";

        string aadata = "";

        client.ds = client.DEngine.GetDataSet(strfetch, "Data", client.conn);

        if (client.ds != null && client.ds.Tables[0].Rows.Count > 0)
        {
             aadata = JsonConvert.SerializeObject(client.ds);
         //  aadata = "{'draw':1, 'recordsTotal':2, 'recordsFiltered':2, 'data':[{'CLIENT_NAME': 'Pyrotech'},{'CLIENT_NAME':'Workspace'}]}";  // tried this also
         //  aadata = "{'data':[{'CLIENT_NAME': 'Pyrotech'}, {'CLIENT_NAME':'Workspace'}]}";   // tried this as well
        }
            return (aadata.Replace("'","\""));
    }
}

JSON Response as in developer tools JSON Response which i got in designer view

Output in datatable Output Table.. It is not showing "pyrotech' and "workspace" but evry character in every row.

enteries in database which are retreived

The enteries in the database from where the datatable is to be filled.

Kevin Labécot · Accepted Answer · 2014-08-08 06:35:15Z

1

I'm not familiar with C# but on the JavaScript part you're not decoding the JSON data.

Try this:

success: function (data) {
    data = JSON.parse(data.d).Data;
    alert(data);

    $("#clientTable").DataTable({
        "searching": true,
        "processing": true,
        "data": data,

        "columns": [
            {data: "CLIENT_NAME"}
        ]
    });
}

edited Aug 8, 2014 at 6:35

answered Aug 8, 2014 at 6:10

Kevin Labécot

1,99513 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

A Beginner Over a year ago

tried this.. it alerts "object Object" and dataTable shows "No data available in table"

Kevin Labécot Over a year ago

Answer updated, try again. Your data array is contained in the Data attribute. This call was missing.

A Beginner Over a year ago

alerts two objects " object Object, object Object" and another error.."DataTables warning: table id=clientTable - Requested unknown parameter '0' for row 0. For more information about this error, please see datatables.net/tn/4" and the table is empty.

Kevin Labécot Over a year ago

Your datatable was misconfigured too. I updated my answer. See datatables.net/manual/data for configuration examples.

Collectives™ on Stack Overflow

Datatable.js - not able to display data

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related