DataTable row not getting removed

Ramco Ramco

5y627.NET

Record in Database is getting deleted but row is not getting removed from table

$("#row_" + Id).remove(); is not working.

public JsonResult Delete(string ID)

{

dbLocation.Delete(ID);

return Json(new { success = true, message = "Saved Successfully" });

}

function Delete() {

var Id = $("#hiddenId").val().replace(/\r?\n|\r/g, "");

Id = Id.trim();

$.ajax({

url: "/Location/Delete",

data: { Id: Id },

type: "POST",

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

dataType: "json",

success: function (result) {

$("#row_" + Id).remove();

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

clearTextBox();

$.notify(result.message, {

globalposition: "top center",

className: "success"

})

error: function (errormessage) {

alert(errormessage.responseText);

}

});

}

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

@foreach (var item in Model)

{

@Html.DisplayFor(modelItem => item.Id)

@Html.DisplayFor(modelItem => item.Description)

@Html.DisplayFor(modelItem => item.IsActive)

Edit

@{ if(item.IsActive == "N")

{

@:disabled="disabled"

}

}> Delete

}

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

$(document).ready(function () {

$("#tblLocation").dataTable({

});

Thanks

5 Replies

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

Sachin Singh5y ago
Accepted answer
change
to this
"[email protected]">
now, it will work.
+1

Ramco Ramco5y ago

Hi Sachin

i.e o.k , Record gets deleted from database but datatable does not get refreshed

@model IEnumerable < MyApplication.Models.Location >

@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 @{ if(item.IsActive == "N") { @:disabled="disabled" } }> Delete @* Delete*@

Thans

Sachin Singh5y ago
Okk,
this means, you have given each tr and id of [email protected]
"[email protected]">
if this is the case then
$("#row_" + Id).remove();
will always work. You can check the console.
+1
Ramco Ramco5y ago
Hi Sachin

I am deleting record from Database. Friom database record gets deleted but $("#row_" + Id).remove(); is not working

Datatable does not get refreshed.

Thanks
+1
Sachin Singh5y ago
Delete means, you are setting the IsActive column to false. so do it as shown below
step 1.
public ActionResult Index()
{
var res= _context.Locations.Where(x=>x.IsActive==true).ToList();
return View(res);

}

public ActionResult Delete(int Id)
{
var obj=_context.Locations.Single(x=>x.Id==Id);
obj.IsActive=false;
  _context.Entry(obj).State=EntityState.Modified;
// _context.Locations.Remove(obj);
  _context.SaveChanges();

return redirectToAction("Index");
}
+2