Deleting records from database using checkboxes in mvc

Swaminathan Ganapathy

I am trying to select few records from my database using checkboxes and I'm trying to delete them. I have surfed through the whole of internet but couldn't find a solution for my specific query i.e deleting multiple records from the table using checkboxes without using entity framework. Please help me with this.

Thanks in Advance!

10 Replies

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

Munesh Sharma7y ago
https://www.c-sharpcorner.com/article/how-to-delete-multiple-rows-using-checkbox-in-mvc-5/
Swaminathan Ganapathy7y ago
@Jignesh Kumar

Thanks for your valuable information but what I need is to do the operations without using entity framework which I have mentioned in the problem definition.
Jignesh Kumar7y ago
Hi,

Please find below links,

http://www.binaryintellect.net/articles/e869963c-fd70-4cb8-bd77-47d621c51408.aspx

Swaminathan Ganapathy7y ago

@model IEnumerable

ViewBag.Title = "List";

}

List

@foreach (var item in Model)

{

}

	@Html.DisplayNameFor(model => model.P_name)	@Html.DisplayNameFor(model => model.DOB)	@Html.DisplayNameFor(model => model.Player_Role)	@Html.DisplayNameFor(model => model.Ranking)	@Html.DisplayNameFor(model => model.Country)	@Html.DisplayNameFor(model => model.Age)
	@Html.DisplayFor(modelItem => item.P_name)	@Html.DisplayFor(modelItem => item.DOB)	@Html.DisplayFor(modelItem => item.Player_Role)	@Html.DisplayFor(modelItem => item.Ranking)	@Html.DisplayFor(modelItem => item.Country)	@Html.DisplayFor(modelItem => item.Age)	@Html.ActionLink("Edit", "Edit", "Home", new { id = item.P_id }, new { @class = "btn btn-sm btn-primary"}) @Html.ActionLink("Delete", "Delete", "Home", new { id = item.P_id }, new { @class = "btn btn-sm btn-danger"})

@Html.ActionLink("Add Player Details", "Details", "Home", new { @class = "btn btn-sm btn-info" })

@section Scripts {

@Scripts.Render("~/bundles/jqueryval")

}

This is my Source view code

Thiyagarajan E7y ago
You can append the rowid to checkbox name
.
and then get the id of the checked row from below JQuery code
var selected = [];
$('#checkboxes input:checked').each(function() {
    selected.push($(this).attr('name'));
});
Thiyagarajan E7y ago
Can you share me the view file code
Swaminathan Ganapathy7y ago
No I don't have have separate Id's for selected rows
Thiyagarajan E7y ago
Are you got an id of selected rows?
Swaminathan Ganapathy7y ago
Yes exactly. Select and delete multiple records which are selected in the checkbox
Thiyagarajan E7y ago
Hi,

Do you mean delete a record from the database while checkbox checked?