Integration between DataTables and ASP.NET Core MVC: form doesn't read all values

Question

In my ASP.NET Core MVC project, I have a page where I use DataTables. I added the code to render the table names logs with DataTables.

$(document).ready(function() {
    var logs = $('#logs').dataTable({
        "processing": true,
        "serverSide": true,
        "filter": true,
        "ajax": {
            "url": "/api/logs",
            "type": "POST",
            "dataType": "json"
        },
        "columns": [
            { className: 'dt-control', orderable: false, 
                         data: null, defaultContent: ''},
            { "data": "timeStamp" },
            { "data": "level" },
            { "data": "queueId" },
            { "data": "message" }
        ]
    })
}

The POST API method receives the call from the DataTables for search and order.

var orderColumn = Request.Form["order[0][column]"].FirstOrDefault();
var sortColumnName = "columns[" + orderColumn + "][name]";
var sortColumn = Request.Form[sortColumnName].FirstOrDefault();
var sortColumnDirection = Request.Form["order[0][dir]"].FirstOrDefault();
var searchValue = Request.Form["search[value]"].FirstOrDefault();

When I order for the column number 5, the sortColumnName tries to read from the RequestForm this column but the value is empty.

I don't understand why.

SpicyCatGames · Accepted Answer · 2025-06-15 16:16:15Z

1

I had this once, and it was because of the max length or one such property on kestrel. I'm not sure which one so might as well try all of them.

Here's how to configure all of the relevant options:

Form options:

builder.Services.Configure<FormOptions>(options =>
{
    options.MultipartBodyLengthLimit = 104857600; // 100 MB
    options.ValueLengthLimit = int.MaxValue;
    options.KeyLengthLimit = int.MaxValue;
    options.MultipartHeadersLengthLimit = int.MaxValue;
});

Max request body size:

builder.WebHost.ConfigureKestrel(serverOptions =>
{
    serverOptions.Limits.MaxRequestBodySize = 104857600; // 100 MB
});

You can also use the attribute only for that action if this is the issue.

answered Jun 15 at 16:16

SpicyCatGames

2,0121 gold badge21 silver badges39 bronze badges

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

Collectives™ on Stack Overflow

Integration between DataTables and ASP.NET Core MVC: form doesn't read all values

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related