ASP.Net MVC and jQuery DataTables plugin trouble

Question

I am trying to integrate the jQuery DataTables plugin into an ASP.Net MVC project. I am following the example here. When I run just the sample code in a test project everything works. But when I try and debug it in my real application the AjaxHandlerdoes not even get executed. Am I missing something?

Here is the calling jQuery Code:

    $(document).ready(function () {

        $('#myDataTable').dataTable({
            "bServerSide": true,
            "sAjaxSource": "/UX/AjaxHandler",
            "bProcessing": true,
            "aoColumns": [

                {
                    "sName": "ID",
                    "bSearchable": false,
                    "bSortable": false,
                    "fnRender": function (oObj) {

                        return '<a href=\"Details/' + oObj.aData[0] + '\">View</a>';
                    }
                },
                { "sName": "NAME" },
                { "sName": "ADDRESS" },
                { "sName": "TOWN" },

            ]

        });
    });

</script>

Then my handler;

 public ActionResult AjaxHandler(jQueryDataTableParamModel param)
    {

        return Json(new
        {
            sEcho = param.sEcho,
            iTotalRecords = 97,
            iTotalDisplayRecords = 3,
            aaData = new List<string[]>() {
                new string[] {"1", "Microsoft", "Redmond", "USA"},
                new string[] {"2", "Google", "Mountain View", "USA"},
                new string[] {"3", "Gowi", "Pancevo", "Serbia"}
                }


        },
         JsonRequestBehavior.AllowGet);


    }

I recall that its a little weird with the Ajax data, you may need to provide a first page of data when you first render the table. — Peter
– Peter, Commented Apr 8, 2013 at 19:38
Nothing showing in the network tab in developer tools on the browser? — Code Monkey
– Code Monkey, Commented Apr 8, 2013 at 19:40
Not in my main application. If I run the exact same code in a new project then I get the Json response in the network tab — Andy J
– Andy J, Commented Apr 8, 2013 at 19:50

Robert · Accepted Answer · 2013-04-08 20:07:57Z

2

If the call to this view is being made from another controller other than ux:

"sAjaxSource": "ux/AjaxHandler",

If the call to this view is made from ux then you only need:

"sAjaxSource": "AjaxHandler",

The extra slash you have in front of the ux is causing your grief

Also I as per our discussion your Id on your table was not the same as the ID your JS was referencing.

edited Apr 8, 2013 at 20:07

answered Apr 8, 2013 at 19:36

Robert

4,40611 gold badges56 silver badges99 bronze badges

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

8 Comments

Andy J Over a year ago

I tried that too, but didn't help. If I set a break point in the AjaxHandler during debugging it is not even getting hit. I think it may be something in the script but not sure.

Code Monkey Over a year ago

ActionResult is a 'super-set' of JsonResult so that shouldn't make a difference.

Andy J Over a year ago

The AjaxHander is in the UX controller

Robert Over a year ago

Is this view populated from a different controller that ux?

Andy J Over a year ago

No. It is all part of the UX controller

|

Collectives™ on Stack Overflow

ASP.Net MVC and jQuery DataTables plugin trouble

1 Answer 1

8 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Related