davidsuescunpelegay/jquery-datatable-server-side-net-core

A simple Visual Studio solution using jQuery DataTable with Server-Side processing using .NET

👋 Hello, David here

💻 Full Stack Developer & Project Manager since 2017

📫 You can reach me at [email protected] or LinkedIn

🛠  Development environments

                   

📈  Some of my GitHub stats

jquery-datatable-server-side-net-core's Issues

A thanks from young developer

Sir, I want to thank you for this public repository. I'm a very beginner (junior) backend developer and I'm trying to learn asp.net core mvc. Thanks to this pre-installed code I easily understand the Datatable mechanism. Thank you a lot...

Show "All" entries throw ajax error.

Its working fine until we click on Show "All" entries - it throws an error: "DataTables warning: table id=test-registers - Ajax error. For more information about this error, please see http://datatables.net/tn/7"

Null reference in LoadTable method

Line 43 (dtparameters.Order reference) and 37 (dtParameters.Search reference) leave null references. Happy to do a PR and contribute if you'd like me to give a hand. Well done on setting 3.1 up.

How to add custom column defination jquery-datatables tag binding?

How to add custom column like edit, delete while binding jquery-datatables tag datatable?

Export All Rows Is Not Working

I have tried to export all rows but is exporting only displayed rows it would be very helpful if anyone can address this issue thanks.

make it work with DataTable Version 2

It is not working with Datatable v2

The ajax is not working with pagination

When click on page two the start variable doesn't update and server receives 0.

Your getting the full recordset every time?

Not sure what the point of this demo is since your controller is getting the full 1000 records each time and you are then just cutting the page number out of the pack to return back to the view.

Surely you should be formulating the resultant query to only be selecting the page number of records each time otherwise there is not much point.

Additionally, your controller is counting all the records a second time each call rather than just getting the count from the query before it is filtered.

No data

Runs but not getting any data in the table.
Migration run and can see the data in the TestRegisters table but not getting any in the table on run, seem to be getting a js error on line 1 of app.js

Edit: works when removing $(() => { ... }); from around the code.
Also, there's a reference to a function 'strtrunc' - is this missing? Can see it referenced in the demo at https://stackoverflow.com/questions/31809932/datatable-cell-string-truncate

Add PDF and Word output

Hello, how to create Word and PDF output both on the server side and on the client side? Of course, I mean the codes of both parts, thank you

DtParameters dtParameters error

DtParameters dtParameters can't initilize and getting ajaxy error in data loading.
Draw = 0,
search = null
column = null
length = null

[HttpPost]
public async Task LoadTable(DtParameters dtParameters, int districtid, int schoolid)
{
schoolid = 1;
var searchBy = dtParameters.Search?.Value;

        // if we have an empty search then just order the results by Id ascending
        var orderCriteria = "Id";
        var orderAscendingDirection = true;

        if (dtParameters.Order != null)
        {
            // in this example we just default sort on the 1st column
            orderCriteria = dtParameters.Columns[dtParameters.Order[0].Column].Data;
            orderAscendingDirection = dtParameters.Order[0].Dir.ToString().ToLower() == "asc";
        }
            //Direct table list into Grid
            using (var Context = new SchooldexAOIContext())
            {
                 var GridData = _context.UserSetupInfos.AsQueryable();

                if (!string.IsNullOrEmpty(searchBy))
                {
                    GridData = GridData.Where(r => r.FirstName != null && r.FirstName.ToUpper().Contains(searchBy.ToUpper()) ||
                                       r.LastName != null && r.LastName.ToUpper().Contains(searchBy.ToUpper()) ||
                                       r.Email != null && r.Email.ToUpper().Contains(searchBy.ToUpper()));                                          
                }
                GridData = orderAscendingDirection ? GridData.OrderByDynamic(orderCriteria, DtOrderDir.Asc) : GridData.OrderByDynamic(orderCriteria, DtOrderDir.Desc);

                // now just get the count of items (without the skip and take) - eg how many could be returned with filtering
                var filteredResultsCount = await GridData.CountAsync();
                var totalResultsCount =  await _context.UserSetupInfos.CountAsync();
                return Json(new DtResult<SchooldexAPI_DB.Contexts.UserSetupInfo>
                {
                    Draw = dtParameters.Draw,
                    RecordsTotal = totalResultsCount,
                    RecordsFiltered = filteredResultsCount,
                    // Data = GridData.ToList()
                    Data = await GridData
                .Skip(dtParameters.Start)
                .Take(dtParameters.Length)
                .ToListAsync()


                }); 


            }

           
        //}
        //return null;
    }

Js files

var table;

$(document).ready(function () {
// $.fn.dataTable.moment("DD/MM/YYYY HH:mm:ss");
// $.fn.dataTable.moment("DD/MM/YYYY");

table = $("#userlistgrid").DataTable({
    // Design Assets
    stateSave: true,
    autoWidth: true,
    // ServerSide Setups
    processing: true,
    serverSide: true,
    // Paging Setups
    paging: true,
    // Searching Setups
    searching: { regex: true },
    // Ajax Filter
    ajax: {
        url: "/Admin/LoadTable",
        type: "POST",           
        contentType: "application/json",
        dataType: "json",
        data: function (d) {
            d.districtid = 0;   //param 1
            d.schoolid = 1;    //param 2
            return JSON.stringify(d);
        }
    },
    // Columns Setups
    columns: [
        { data: "Id" },
        { data: "FirstName" },
        { data: "LastName" } ,
        { data: "Email" },
       // { data: "UserName" }
    ],
    // Column Definitions
    columnDefs: [
        { targets: "no-sort", orderable: false },
        { targets: "no-search", searchable: false },
        {
            targets: "trim",
            render: function (data, type, full, meta) {
                if (type === "display") {
                    data = strtrunc(data, 10);
                }

                return data;
            }
        },
        { targets: "date-type", type: "date-eu" },
        {
            targets: 10,
            data: null,
            defaultContent: "<a class='btn btn-link' role='button' href='#' onclick='edit(this)'>Edit</a>",
            orderable: false
        },
    ]
});

});

function strtrunc(str, num) {
if (str.length > num) {
return str.slice(0, num) + "...";
}
else {
return str;
}
}

function edit(rowContext) {
if (table) {
var data = table.row($(rowContext).parents("tr")).data();
alert("Example showing row edit with id: " + data["id"] + ", name: " + data["name"]);
}
}

MSB3021 and MSB3027 Error

Hi, I want to check the project but Ican't build it. Many thanks. Here is the error:

SSeverity Code Description Project File Line Suppression State
Error MSB3027 Could not copy "C:\Users\Ramazan.nuget\packages\system.security.cryptography.protecteddata\4.5.0\runtimes\win\lib\netstandard2.0\System.Security.Cryptography.ProtectedData.dll" to "bin\Debug\netcoreapp3.1\runtimes\win\lib\netstandard2.0\System.Security.Cryptography.ProtectedData.dll". Exceeded retry count of 10. Failed. jQueryDatatableServerSideNetCore C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\MSBuild\Current\Bin\Microsoft.Common.CurrentVersion.targets 4360
Error MSB3021 Unable to copy file "C:\Users\Ramazan.nuget\packages\system.security.cryptography.protecteddata\4.5.0\runtimes\win\lib\netstandard2.0\System.Security.Cryptography.ProtectedData.dll" to "bin\Debug\netcoreapp3.1\runtimes\win\lib\netstandard2.0\System.Security.Cryptography.ProtectedData.dll". Could not find a part of the path 'bin\Debug\netcoreapp3.1\runtimes\win\lib\netstandard2.0\System.Security.Cryptography.ProtectedData.dll'. jQueryDatatableServerSideNetCore C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\MSBuild\Current\Bin\Microsoft.Common.CurrentVersion.targets 4360