jQuery and datatables: pass an array to server-side datasource

Question

I have a datatable which uses a server side datasource like this:

    $('.taskTable').dataTable({
       "bServerSide": true,
       "bProcessing": false,
       "fnServerData": function (sSource, aoData, fnCallback) {
          ...
          aoData.push({ "name": "groupIDs", "value": $("#groupIDs").val() });
          ...
          $.ajax({
             'dataType': 'json',
             'type': 'post',
             'url': "@Url.Action(MVC.Tasks.Tasks.DataTable())",
             'data': aoData
          });
      }
   });

Problem is, $("#groupIDs").val() doesn't format the values so they bind with my model (.NET MVC3). .NET wants to see something like groupIDs[0]=23&groupIDs[1]=42&... but instead it is sending it as groupIDs=[23,42,...]. How can I get datatables to send it in the right format?

mtmurdock · Accepted Answer · 2012-08-06 17:58:41Z

3

Figured it out. Rather than struggling with getting datatables to auto format it how I wanted, I decided to manually input the values as separate parameters.

"fnServerData": function (sSource, aoData, fnCallback) {
   var groupIDs = $("#groupIDs").val()
   if (groupIDs != null) {
      for (x = 0; x < groupIDs.length; x++) {
         aoData.push({ "name": "groupIDs[" + x + "]", "value": groupIDs[x] });
      }
   }
   ... // more code
}

Works great. Hope this helps someone else.

answered Aug 6, 2012 at 17:58

mtmurdock

13.1k21 gold badges68 silver badges108 bronze badges

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

Comments

chris · Accepted Answer · 2012-08-06 17:37:58Z

groups 23, 42, .... is the equivalent of an array, now I don't know much about .net, however I am sure just like PHP it has a for, while, foreach equivalent of which on your backend you would loop over this array and do with it as you wanted to otherwise.

In this case your example groupdIDs=[23,42] on the back end you would do something like

(note this is PHP I apologize for it not being .net)

foreach($_POST['groupIDs'] as $groupid)
{
   echo $groupid."<br>";
}

or

for($i=0;$i < count($_POST['groupIDs']);$i++)
{
    echo $_POST['groupIDs'][$i]."<br>";
}

or

echo $_POST['groupIDs'][0]."<br>";
echo $_POST['groupIDs'][1]."<br>";

This is all javascript on the client, not server side. Thanks though.

Collectives™ on Stack Overflow

jQuery and datatables: pass an array to server-side datasource

2 Answers 2

Comments

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Related