Get data from controller in json form inside a datatable

Question

Here's the case.

I am using ajax call in datatable js to bind json data in my table.
Right now I am using directly json file for databinding.
Now I want to access the data from my db for which I have written a method inside my controller which returns json value.

But I am not able to call this method like I was calling my json file in ajax. Kindly suggest the solution.

Below are the code sample

var table = $('#example').DataTable({
        "ajax": "/content/data/dataList.json", //here I want the url of my method.
        "bDestroy": true,
        "iDisplayLength": 15,
        "columns": [
            {
                "class": 'details-control',
                "orderable": false,
                //"data": null,
                "defaultContent": ''
            },
            { "data": "name" },
        ],
        "order": [[1, 'asc']],
        "fnDrawCallback": function (oSettings) {
            runAllCharts();
        }
    });

And my method id :

//Controller Name AppDetail
    public string getData(string ddlid)
    {
        DataTable ddl = new DataTable();
        string query = string.Empty;
        if (ddlid == "O1")
        {
            query = "SELECT for O1";
        }
        else if (ddlid == "O2")
        {
            query = "SELECT for O2";
        }
        con.Open();
        MySqlDataAdapter da = new MySqlDataAdapter(query, con);
        da.Fill(ddl);
        con.Close();
        System.Web.Script.Serialization.JavaScriptSerializer jSearializer = new System.Web.Script.Serialization.JavaScriptSerializer();
        return jSearializer.Serialize(ddl);               
    }

And here is the json data sample

    {
    "data": [
         {
            "name": "Aladdin"
        }  
    ]
}

Kindly Help.

Rajeev Shrestha · Accepted Answer · 2016-08-01 05:19:03Z

1

if you are not using server side processing method get all data first using ajax method and use that data on data table. look at the code below... it might help you for getting some idea.

  $.ajax({
            url: 'api/AppDetail/getData',
            method: 'get',
            data :{ddlid:'01'},          // this is input parameter for your function
            dataType: 'json',
            contentType: 'text/json',
            success: function(res){
                var table=$('#example').dataTable({
                    data: res,
                    columns:[
                           {'data':'name'}
                      ],
                     bDestroy : true,
                iDisplayLength : 15,
                 });  
            }
        });

answered Aug 1, 2016 at 5:19

Rajeev Shrestha

756 bronze badges

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

Comments

Bas1c · Accepted Answer · 2016-07-31 11:08:03Z

0

If your controller works you can call it before DataTables and insert the data via the data (https://datatables.net/reference/option/data) source of DataTables

answered Jul 31, 2016 at 11:08

Bas1c

761 silver badge4 bronze badges

Comments

rajiv · Accepted Answer · 2016-08-01 06:36:29Z

On the Controller if u are getting Data which u want, then u can return this Data to a partial view. Note that the partial view is nothing a html table which u bulild upon Razor syntax or anything. Then make ajax call to return this partial view, On success u can apply data table plugin.

<div id=MyTable></div>
$.ajax({
        type: 'GET',
        url: ControllerName/ActionName=partialView Which makes table. 
        success: function (data) {
            debugger;
            $('#MyTable').html(data); //Puting result of ajax call to the  div which containg Id,
            $('#PartilView_Table').DataTable({  // Applying DataTable Plugin table inside partialView                               
                "bProcessing": true,
                "bDeferRender": true,
                "scrollX": true,
                "stateSave": true,
                "bAutoWidth": true,
                "bSort": false,
                "columnDefs": [
                  {

                  }
                ]
              });
      },
      });

Hope this will help you..

Collectives™ on Stack Overflow

Get data from controller in json form inside a datatable

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related