Can not add rows using datatable.js Ajax

Question

I tried to create table using datatable.js ajax. I'm getting data from webmethod , but, result is not adding into the tables.

JS Method

 function getMyData() {
            alert('d');
            $.ajax({
                type: "POST",
                url: "AssignHistory.aspx/getModemAssign ",
                data: "{}",
                contentType: "application/json; charset=utf-8",
                dataType: "json",
                success: buildMyDatatable,
                error:
                    function (msg) {
                        alert(msg.status + " " + msg.statusText);
                    }
            });

            function buildMyDatatable(result) { 
                var data = JSON.stringify(result.d);
                $('#gvAssgin').dataTable({
                    retrieve: true,
                    JSON:data,
                    columns: [
                            { data: "ModemId" },
                            { data: "ModemName" }
                    ]
                }); 
            }
        }

HTML Code

   <table id="gvAssgin">
      <thead>
        <tr>
             <th>
                   Modem ID 
             </th>
             <th>
                   Modem Name 
             </th>
         </tr>
   </thead>

Result I'm getting is,

waiting for replies

Gyrocode.com · Accepted Answer · 2016-02-04 17:15:16Z

1

Correct option of JavaScript sourced data is data. Also there is no need to generate JSON again with JSON.stringify(result.d), just pass the array to jQuery DataTables.

See the corrected code below:

$('#gvAssgin').dataTable({
    data: result.d,
    columns: [
       { data: "ModemId" },
       { data: "ModemName" }
    ]
});

answered Feb 4, 2016 at 17:15

Gyrocode.com

59k16 gold badges157 silver badges192 bronze badges

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

3 Comments

Karthik Tv Over a year ago

thanks it helps me.I have one more query, that i trying to create a check box inside the Datatable column and i need to set data value to that check box

Gyrocode.com Over a year ago

@KarthikTv, regarding checkboxes, please see our article Row selection using checkboxes and Select extension and How to add a checkbox column

Karthik Tv Over a year ago

Thanks you so much. I have posted another one question similar to this. can you please Look into that. It will save my day. stackoverflow.com/questions/35219337/…

Collectives™ on Stack Overflow

Can not add rows using datatable.js Ajax

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related