Just add or Copy/past DataTablesRequest.cs to your project and follow the steps if you don't know how to use it
How to use : 1- First, add DataTablesRequest.cs to your project, don't forget to change the namespace as you wish.
2- Now, in your controller add this notation before you function : [HttpPost("/A_Custom_route_name")] or just [HttpPost]
3- The first thing is to extract the parameters from the datatable request and for that we have 2 options :
A/ Take your request as a string then convert it to JSon : Example : [HttpPost] public JsonResult RenderDataTable(string req) { var dtParms = req.FromJson<DataTablesRequest>(); ... } To use this option, consider installing the Newtonsoft package, in package manager write this : Install-Package Newtonsoft.Json -Version 10.0.3 in this case, for the frontend (the script part) take a look at Frontend-String-Request.js to know how your ajax request must look like B/ Directly take your request as a DataTableRequest Object : Example : [HttpPost] public JsonResult RenderDataTable( [FromBody] DataTablesRequest dtParms) { //You already have your dtParms so just use it } in this case, for the frontend (the script part) take a look at Frontend-DataTableRequest-Object.js to know how your ajax request must look like 4- now let's implement the rest, supposing that you got your dtParms, your function should look like this :
[HttpPost] public JsonResult RenderDataTable( [FromBody] DataTablesRequest dtParms) { //Get all your data, we need it to return the total count to dataTable var toQuery = _dbContext.YourTable.AsNoTracking().Where(f => true); //The TotalCount is required from DataTable so before filtring our records we place it somewhere var totalCount = toQuery.Count(); //Now let's define/get our records that we need var dataPage = toQuery; //First we check if there is a search filter, if yes we filter our results : if (!string.IsNullOrEmpty(dtParms.Search.Value)) { dataPage = dataPage.Where(u => u.The_Column_That_We_Will_Filter.ToUpper().Contains(dtParms.Search.Value)); //You can add as columns as you want } //Then we check if the datatable require a sorting for data : if (dtParms.Order != null) { //If true, we get the sorting informations (which column and direction "ASC" or "DESC" var requestedOrder = dtParms.Order.FirstOrDefault(); //And based on those informations we sort our data: switch (requestedOrder.Column) { //if the datatable requested a sorting on the column 0 you sort that column in your records: case 0: dataPage = requestedOrder.Dir.ToUpper().Equals("DESC") ? dataPage.OrderByDescending(f => f.The_column_that_corresponding_the_column0_in_your_datatable) : dataPage.OrderBy(f => f.The_column_that_corresponding_the_column0_in_your_datatable); break; case 1: dataPage = requestedOrder.Dir.ToUpper().Equals("DESC") ? dataPage.OrderByDescending(f => f.The_column_that_corresponding_the_column1_in_your_datatable) : dataPage.OrderBy(f => f.The_column_that_corresponding_the_column1_in_your_datatable); break; } } //Get the results : var results = dataPage.Skip(dtParms.Start).Take(dtParms.Length).Select(a => new Your_Model_or_object { Column0 = a.YourDBTable.Column_that_corresponding_Column0, Column1 = a.YourDBTable.Column_that_corresponding_Column0 }).ToList(); //The filtredCount is how much records will you return, DataTable require this informations to create the pagination var filteredCount = dataPage.Count(); //This will create the response desired by DataTable var res = DataTableResponse.Create(dtParms, totalCount, filteredCount, results); return new JsonResult(res); }