jQuery Datatable-更改数据网址 [英] jQuery Datatable - changing data url

问题描述

当前使用的是jQuery Datatables插件.

Currently using the jQuery Datatables plugin.

我现在需要能够基于某些表单输入值更改ajax数据源，该表单输入值将在单击按钮时提交?

I now need to be able to change the ajax data source based on some form input values, which would be submitted on a button click?

推荐的实现方法是什么?

What is the recommended method for achieving this?

$(document).ready(function () {

        $('#btnReport')
            .click(function () {
                var table = $('#reports').DataTable();
                table.ajax.reload();
            });

        var querystring = '?from=' + $('#datetimepickerFrom').val() + '&till='  $('#datetimepickerFrom').val();

        var url = '/api/reports/custom';

        var table = $("#reports").DataTable({
            ajax: {
                url: url + queryString,
                dataSrc : ""
            },
            columns: [
                {
                    data: "fullName"
                },
                {
                    data: "timeIn"
                }
            ]
        });

    });

非常感谢

推荐答案

使用 ajax.url() 和 ajax.url().load() 设置网址表并从该URL加载数据.

Use ajax.url() and ajax.url().load() to set URL for the table and load data from that URL.

例如:

function getDataTableUrl(){
    return 
        '?from=' + $('#datetimepickerFrom').val() 
        + '&till=' +  $('#datetimepickerFrom').val();
}

$('#btnReport')
    .click(function () {
        var table = $('#reports').DataTable();
        table.ajax.url(getDataTableUrl()).load(); 
    });

这篇关于jQuery Datatable-更改数据网址的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！