Error on Ajax Reload

Ramco Ramco

5y2.2k.NET

On this line i get error - $('#tblLocation').DataTable().ajax.reload();

DataTables warning: table id=tblLocation - Invalid JSON response. For more information about this error, please see http://datatables.net/tn/1

@foreach (var item in Model)

{

}

@Html.DisplayNameFor(model => model.Id)	@Html.DisplayNameFor(model => model.Description)	@Html.DisplayNameFor(model => model.IsActive)	Action
@Html.DisplayFor(modelItem => item.Id)	@Html.DisplayFor(modelItem => item.Description)	@Html.DisplayFor(modelItem => item.IsActive)	Edit Delete

****************************8

function Add() {

var res = validate();

if (res == false) {

return false;

}

var objLocation = {

Id: $('#txtId').val().toUpperCase(),

Description: $('#txtDescription').val().toUpperCase(),

IsActive: $('#txtIsActive').val().toUpperCase()

};

$.ajax({

url: "/Location/Add",

data: JSON.stringify(objLocation),

type: "POST",

contentType: "application/json;charset=utf-8",

dataType: "json",

success: function (result) {

$('#tblLocation').DataTable().ajax.reload();

$.notify(result.message, {

globalposition: "top center",

className:"success"

})

$('#myModal').modal('hide');

error: function (xhr, ajaxOptions, thrownError) {

$("#msgModalBody").html('Status : ' + xhr.status + ' Error : ' + thrownError);

$("#msgModal").modal('show');

}

});

}

***************************************

public List GetAllLocation()

{

List objLocation = new List();

using (SqlConnection con = new SqlConnection(cs))

{

con.Open();

SqlCommand com = new SqlCommand("sp_Location", con);

com.CommandType = CommandType.StoredProcedure;

com.Parameters.AddWithValue("@Action", "R");

SqlDataReader rdr = com.ExecuteReader();

while (rdr.Read())

{

objLocation.Add(new Location

{

Id = rdr["Id"].ToString(),

Description = rdr["Description"].ToString(),

IsActive = rdr["IsActive"].ToString(),

});

}

return objLocation;

}

Thanks

5 Replies

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

Ramco Ramco5y ago
Hi Sachin

Getting error - Status : 200 Error : SyntaxError: Invalid character. Secondly how thiscan be returned
return Json(new { success = true, message="Saved Successfully"});

public ActionResult Add(Location objLocation)
{
dbLocation.Add(objLocation);
return RedirectToAction("Index");
}

function Add() {
var res = validate();
if (res == false) {
return false;
}
var objLocation = {
Id: $('#txtId').val().toUpperCase(),
Description: $('#txtDescription').val().toUpperCase(),
IsActive: $('#txtIsActive').val().toUpperCase()
};
$.ajax({
url: "/Location/Add",
data: JSON.stringify(objLocation),
type: "POST",
contentType: "application/json;charset=utf-8",
dataType: "json",
success: function (result) {
//$('#tblLocation').DataTable().ajax.reload(null, false);
$.notify(result.message, {
globalposition: "top center",
//position:"center",
className:"success"
})
$('#myModal').modal('hide');
},
error: function (xhr, ajaxOptions, thrownError) {
$("#msgModalBody").html('Status : ' + xhr.status + ' Error : ' + thrownError);
$("#msgModal").modal('show');
}
});
}

Thanks
+1
Sachin Singh5y ago
for you nothing will work because you are not using ajax to load the table instead you are using MVC model to bind the table, so you don't need anything.
just remove the line
$('#tblLocation').DataTable().ajax.reload();
For you the above line has no use.
instead you need to do this
public List GetAllLocation()
{
List objLocation = new List();
using (SqlConnection con = new SqlConnection(cs))
{
con.Open();
SqlCommand com = new SqlCommand("sp_Location", con);
com.CommandType = CommandType.StoredProcedure;
com.Parameters.AddWithValue("@Action", "R");
SqlDataReader rdr = com.ExecuteReader();
while (rdr.Read())
{
objLocation.Add(new Location
{
Id = rdr["Id"].ToString(),
Description = rdr["Description"].ToString(),
IsActive = rdr["IsActive"].ToString(),
});
}
return objLocation;
}
public ActionResult Index()
{
var locations=GetAllLocation();
return view(locations); // returning view where table is present
}
public ActionResult Add()
{
// perform add
return redirectToAction("Index");
}
public ActionResult Delete(int Id)
{
// perform Delete
return redirectToAction("Index");
}
+1
Ramco Ramco5y ago
Hi Sachin

Error -
Unhandled exception at line 37, column 78 in http://localhost:6784/components/datatables.net/js/jquery.dataTables.min.js
0x800a138f - JavaScript runtime error: Unable to set property 'data' of undefined or null reference

$(document).ready(function () {
$("#tblLocation").dataTable({
});
});

**********************************************
function Add() {
var res = validate();
if (res == false) {
return false;
}
var objLocation = {
Id: $('#txtId').val().toUpperCase(),
Description: $('#txtDescription').val().toUpperCase(),
IsActive: $('#txtIsActive').val().toUpperCase()
};
$.ajax({
url: "/Location/Add",
data: JSON.stringify(objLocation),
type: "POST",
contentType: "application/json;charset=utf-8",
dataType: "json",
success: function (result) {
$('#tblLocation').DataTable().ajax.reload();
$.notify(result.message, {
globalposition: "top center",
//position:"center",
className:"success"
})
$('#myModal').modal('hide');
},
error: function (xhr, ajaxOptions, thrownError) {
$("#msgModalBody").html('Status : ' + xhr.status + ' Error : ' + thrownError);
$("#msgModal").modal('show');
}
});
}

********************** Controller

public JsonResult Add(Location objLocation)
{
if (ModelState.IsValid)
{
dbLocation.Add(objLocation);
return Json(new { success = true, message="Saved Successfully"});
}
return Json(dbLocation);
}
+1
Sachin Singh5y ago
for newer version
$('#table').DataTable().ajax.reload();
for older version
$('#table_data').dataTable( ).api().ajax.reload();
other solution in sucess function
$("#table_data").fnDestroy();
$("#table_data").dataTable();
+2
Asma Khalid5y ago
Do this instead i.e.
var myTable = $('#tblLocation').DataTable(
                        {
                                  // your initial configuration.
                        });

...
...
...

// in ajax success method.

myTable.ajax.reload(null, false);
Mark answer as accepted if helpful

Thanks & Regards,
Asma Khalid

For More Visit: www.asmak9.com or www.bytezaar.com
+1