Data Not Populating The Table Created Using Jsgrid

I'm using jsgrid to create an editable table. i used the code from this demo. The only difference is im using mvc instead of web api. Looking at the network, the controller return

Solution 1:

Change your loadData call because its not specifying what to do when ajax call is done.

Try to rewrite it like below :

controller: {
        loadData: function() {
        var d = $.Deferred();
        $.ajax({
            url: "get",
            dataType: "json",
            data: filter
        }).done(function(response) {
            d.resolve(response.value);
        });

        return d.promise();
    }
},

Solution 2:

This is the client side javascript that I used which finally put some data in the grid: (just the controller part)

controller: {
                        loadData: function (filter) {
                            console.log("1. loadData");

                            return $.ajax({
                                type: "GET",
                                url: "/Timesheet/GetTimesheet/",
                                dataType: "json",
                                data: filter

                            console.log("3. loadData complete");
                        }

None of the posted explicit promise code functioned at all. Apparently $.ajax returns a promise.

and this was my MVC controller code that I called with ajax (C#):

publicasync Task<ActionResult> GetTimesheet()
    {
        int id = Convert.ToInt32(Session["UID"]);

        var tl = (
            from ts in db.Tasks
            orderby ts.Task_Date descendingwhere ts.Emp_ID == id
            selectnew
            {
                ID = ts.Task_ID,
                Date = ts.Task_Date,
                Client = ts.Customer_ID,
                Hours = ts.Total_Hours
            }
        ).Take(4);

        var jsonData = await tl.ToListAsync();

        return Json(jsonData, JsonRequestBehavior.AllowGet);
    }

There are no actual examples of required Json for jsGrid. anywhere but this worked for me - note no headers or anything.