JQuery Datatable

Ramco Ramco

5y1.1k.NET

I have below DataTable . I want to use Sorting,Pagelength like settings Centralised thru Class so that it can be used on all DataTables, With the below code i have to write it on every Index.

$(document).ready(function () {
$("#tblLocation").dataTable({
ajax: {
type: "get",
url: "/Location/List",
dataType: "json",
dataSrc: ""
},
paging: true,
sort: true,
pageLength: 10,
searching: true,
columns: [
{ 'data': 'Id' },
{ 'data': 'Description' },
{ 'data': 'IsActive' },
{
"defaultContent": ''
}
//
//
]
});
$('body').on('click', '[id*=btnEdit]', function () {
var data = $(this).parents('tr').find('td');
var id = data.eq(0).html();
var description = data.eq(1).html();
$('[id*=txtId]').val(id);
$('[id*=txtDescription]').val(description);
$("#btnAdd").hide();
$(".modal-title").html("Update");
$("#btnUpdate").show();
$('#myModal').modal("show");
});
});

Thanks

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
how will it run? place that code in ready function in layout.
Now test.
$(function(){
$.extend( true, $.fn.dataTable.defaults, {
    "searching": true,
    "ordering": true,
    "PazeSize":10,
    "paging":true
} );


})
+1
Yogeshkumar Hadiya5y ago
Please refer below article. In this article @Saineshwar Bageri explain how to use datatable js in asp.net core.

https://www.c-sharpcorner.com/article/using-jquery-datatables-grid-with-asp-net-core-mvc/
+2
Ramco Ramco5y ago
Hi Sachin

Not Working

$(document).ready(function () {
$("#tblLocation").dataTable({
ajax: {
type: "get",
url: "/Location/List",
dataType: "json",
dataSrc: ""
},
//paging: true,
//sort: true,
//pageLength: 10,
//searching: true,
columns: [
{ 'data': 'Id' },
{ 'data': 'Description' },
{ 'data': 'IsActive' },
{
"defaultContent": ''
}
]
});
});

***************************
Layout File

Thanks
+1
Sachin Singh5y ago
you can centralize the values using defaults,
create a script having these lines of code and place the script in your Layout page.
$.extend( true, $.fn.dataTable.defaults, {
    "searching": true,
    "ordering": true,
    "PazeSize":10,
    "paging":true
} );
+2