ajax - mediante - recargar pagina al cerrar modal bootstrap

Cargar datos de DataTable a través del botón Click

Question

Quiero llenar DataTable con un clic de botón. Inicialmente, la tabla de datos debe estar vacía:

var searchText = $("#textBox").val();
Table = $("#customerTable").dataTable({
data:[],
"columns": [
{"data": "Id" },
{ "data": "Name" },
{ "data": "City" },
{ "data": "Country" }
]
//"serverSide": true
});

y el botón clic:

$("#SearchButton").on("click", function (event) {
$.ajax({
url: "/LoadCustomers",
type: "post"
});
Table.rows.add(result).draw();
});

Answer 1

Resuelto !!!

Mi mesa se ve así:

Table = $("#customerTable").DataTable({
data:[],
columns: [
{ "data": "CompanyId" },
{ "data": "CompanyName" },
{ "data": "City" },
{ "data": "Country" }
],
rowCallback: function (row, data) {},
filter: false,
info: false,
ordering: false,
processing: true,
retrieve: true
});

Controlador de clic de botón:

$("#customerSearchButton").on("click", function (event) {
$.ajax({
url: "",
type: "post",
data: { searchText: searchText }
}).done(function (result) {
Table.clear().draw();
Table.rows.add(result).draw();
}).fail(function (jqXHR, textStatus, errorThrown) {
// needs to implement if it fails
});
}

Answer 2

 $( document ).ready(function() {
Table = $("#datatable").DataTable({
data:[],
columns: [
{ data: "IAVDate" },
{ data: "ShiftID" },
{ data: "UserID" },
{ data: "IAV" },
{ data: "Type" },
{ data: "IAV Value"}
],
rowCallback: function (row, data) {},
filter: false,
info: false,
ordering: false,
processing: true,
retrieve: true
});
start = jQuery("#start").val();
end = jQuery("#end").val();
$("#generate").on("click", function (event) {
alert(''result'');
$.ajax({
url: "<?php echo base_url(); ?>Report/IAV_sale",
type: "post",
"data": {"start":start,"end":end},
}).done(function (result) {
Table.clear().draw();
Table.rows.add(result).draw();
}).fail(function (jqXHR, textStatus, errorThrown) {
// needs to implement if it fails
});
});
}); 

hey, no obtuve actualizar mi tabla de datos por el código anterior,

mi respuesta {"data": [{"IAVDate": "2017-03-17 07:08:32", "ShiftID": "30", "UserID": "111", "IAV": "45248022418", "Tipo": "efectivo", "valor de IAV": "1400"}, {"IAVDate": "2017-03-17 07:09:49", "ShiftID": "30", "ID de usuario": "111 "," IAV ":" 63094881690 "," Tipo ":" efectivo "," Valor IAV ":" 20 "}, {" IAVDate ":" 2017-03-17 07:12:14 "," ShiftID ": "30", "Id. De usuario": "111", "IAV": "55841613411", "Tipo": "tarjeta", "Valor IAV": "0"}, {"IAVDate": "2017-03-17 07 : 12: 16 "," ShiftID ":" 30 "," ID de usuario ":" 111 "," IAV ":" 27197239869 "," Tipo ":" efectivo "," Valor IAV ":" 0 "}, {" IAVDate ":" 2017-03-17 07:19:43 "," ShiftID ":" 30 "," UserID ":" 111 "," IAV ":" 82469287727 "," Tipo ":" efectivo "," IAV " Valor ":" 10 "}, {" IAVDate ":" 2017-03-17 07:20:33 "," ShiftID ":" 30 "," ID de usuario ":" 111 "," IAV ":" 22158170425 ", "Tipo": "efectivo", "Valor IAV": "200"}, {"IAVDate": "2017-03-17 07:20:44", "ShiftID": "30", "ID de usuario": "111 "," IAV ":" 91852461457 "," Tipo ":" efectivo "," Valor IAV ":" 50 "}, {" IAVDate ":" 2017-03-17 07:20:50 "," ShiftID ": "30", "Id. De usuario": "111", "IAV": "3906686807", "Tipo": "efectivo", "Valor IAV": "20"}, {"IAVDate": "2017-03-17 07 : 20: 52 "," ShiftID ":" 30 "," ID de usuario ":" 1 11 "," IAV ":" 28281616952 "," Tipo ":" efectivo "," Valor IAV ":" 200 "}, {" IAVDate ":" 2017-03-17 07:22:18 "," ShiftID " : "30", "Id. De usuario": "111", "IAV": "20432041716", "Tipo": "efectivo", "Valor IAV": "100"}, {"IAVDate": "2017-03-17 07:22:21 "," ShiftID ":" 30 "," UserID ":" 111 "," IAV ":" 43137123170 "," Tipo ":" efectivo "," Valor IAV ":" 50 "}, { "IAVDate": "2017-03-17 07:22:26", "ShiftID": "30", "UserID": "111", "IAV": "99290115936", "Tipo": "efectivo", " IAV Value ":" 5 "}, {" IAVDate ":" 2017-03-17 07:23:14 "," ShiftID ":" 30 "," UserID ":" 111 "," IAV ":" 69687310655 " , "Tipo": "tarjeta", "Valor IAV": "700"}, {"IAVDate": "2017-03-17 07:24:21", "ShiftID": "30", "ID de usuario": " 111 "," IAV ":" 5706858910 "," Tipo ":" tarjeta "," Valor IAV ":" 700 "}, {" IAVDate ":" 2017-03-17 07:25:44 "," ShiftID " : "30", "ID de usuario": "111", "IAV": "25842193589", "Tipo": "efectivo", "Valor IAV": "47"}]}