datatable js ajax pass variable to C# serverside method

Question

I have a datatable that is being populated via serverside ajax. I need to pass variables to the serverside C# method. The variables are not getting to the serverside.

I've tried a few different approaches. It should be pretty easy.

 var tblApplication = $('#tblApplication').DataTable({
    "ajax": {
        "url": '../../Search/ApplicationList',
        "type": 'POST',
        "data":{
            yearh: 2014,
            make: ''
        }
    },        
    "autoWidth": false,
    "fnRowCallback": function (nRow, aData, iDisplayIndex, iDisplayIndexFull) {
        $(nRow).addClass("parent");
        return nRow;
    },
    "order": [[1, "desc"]],
    "deferRender": true,
    "columns": [
        {
            "title": '',
            "class": 'details-control',
            "orderable": false,
            "data": null,
            "defaultContent": '<img src="../../assets/images/details_open.png" />'
        },
        { "title": 'ApplicationId', "data": 'ApplicationId', "visible": false },
        { "title": 'Year', "data": 'Year' },
        { "title": 'Make', "data": 'Make' },
        { "title": 'Model', "data": 'Model' },
        { "title": 'Qualifier', "data": 'Qualifier' },
        { "title": 'Axle', "data": 'Axle' },
        { "title": 'Pad Set', "data": 'PadSet' },
        { "title": 'Side', "data": 'Side' },
        { "title": 'Part List', "data": 'PartListId' }
    ]
});

[HttpPost]
public JsonResult ApplicationList(int year = 0, string make = null )
{
}

a mistake? in the ajax call you write "yearh" and in the method "year"... can check that? — Gabriel, Aug 12 '14 at 18:58
have a look at this [example](http://stackoverflow.com/questions/10688951/calling-webmethod-ina-aspx-cs-file-using-jquery-ajax) — Blake, Aug 12 '14 at 19:49
It is datatable .js and the syntax for this is not going to be like a reqular jquery ajax call. Something is wrong with the js ajax call. — Jim Kiely, Aug 12 '14 at 19:53

Mahib · Answer 1 · 2016-02-25T23:25:15.130

According to datatables.js reference you need to extend "data" something like following to make it work;

$('#example').dataTable( {
  "ajax": {
    "url": "data.json",
    "data": function ( d ) {
      return $.extend( {}, d, {
        "extra_search": $('#extra').val(),
        "year": 2014,
        "make": 'Nissan'
      } );
    }
  }
} );

For further documentation please see the this. Hope this helps.

datatable js ajax pass variable to C# serverside method

1 Answers1