I want to know about the JQuery Datatables

Question

I have made a project as per the requirements. I create a controller of API but doesn't show the data in the view. In the below picture the view didn't access the data from the controller. If someone knows about this please let me know.

Thanks.

Farhan Ahmed · Answer

https://www.c-sharpcorner.com/article/how-to-retrieve-data-from-database-in-asp-net-web-api-using-jquery/

Sachin Singh · Answer

Datatable needs Json data. You have two option to use datatable 1st:- Convert table to datatable (not recommended by me) public ActionResult Index() { List emps= new List () { id=1,Name="Sachin", id=2,Name="Rakesh" } return View(emps); } // your class public class Employee { public int id{get;set;} public string Name {get;set;} } @model IEnumerable Id Name @foreach(var item in Model) { @item.Id @item.Name } $("#myTable").DataTable(); 2nd Option (Recommended):- public ActionResult Index() { return View(); } public ActionResult GetEmployees() { List emps= new List () { id=1,Name="Sachin", id=2,Name="Rakesh" } return Json(emps,JsonRequestBehavior.AllowGet); } } // your class public class Employee { public int id{get;set;} public string Name {get;set;} } // Index view Id Name $(function () { $.ajax({ type: "POST", url: "/Home/GetEmployees", data: '{}', contentType: "application/json; charset=utf-8", dataType: "json", success: OnSuccess, failure: function (response) { alert(response.d); }, error: function (response) { alert(response.d); } }); }); function OnSuccess(response) { $("#myTable").DataTable( { bLengthChange: true, bFilter: true, bSort: true, bPaginate: true, data: response, columns: [{ 'data': 'id' }, { 'data': 'Name' } ] }); };

I want to know about the JQuery Datatables

Answers (2)