How to delete multiple webgrid rows by using Checkboxes in asp.net MVC Application
Create sample Student table using below script
CREATE
TABLE
[dbo].[Student](
[Id]
[int] NOT
NULL,
[Name]
[varchar](50)
NULL,
[Class]
[int] NULL,
[Fees]
[int] NULL,
CONSTRAINT
[PK_Student] PRIMARY
KEY
CLUSTERED
(
[Id]
ASC
)WITH
(PAD_INDEX
=
OFF,
STATISTICS_NORECOMPUTE
=
OFF,
IGNORE_DUP_KEY
=
OFF,
ALLOW_ROW_LOCKS
=
ON,
ALLOW_PAGE_LOCKS
=
ON)
ON
[PRIMARY]
)
ON
[PRIMARY]
GO
SET
ANSI_PADDING
OFF
GO
INSERT
[dbo].[Student]
([Id],
[Name],
[Class],
[Fees])
VALUES
(1,
N'John',
3,
15000)
GO
INSERT
[dbo].[Student]
([Id],
[Name],
[Class],
[Fees])
VALUES
(2,
N'David',
3,
15000)
GO
INSERT
[dbo].[Student]
([Id],
[Name],
[Class],
[Fees])
VALUES
(3,
N'Mark',
5,
25000)
GO
INSERT
[dbo].[Student]
([Id],
[Name],
[Class],
[Fees])
VALUES
(4,
N'Juda',
7,
30000)
GO
INSERT
[dbo].[Student]
([Id],
[Name],
[Class],
[Fees])
VALUES
(5,
N'Reuben',
9,
50000)
GO
==========================================================================
Right click on solution => Add New Item => Data => ADO.NET Entity Data Model
=> Name it MyModel.edmx => Add => Generate from Database =>
next => New Connection => Provide Server details and select Database
=> Test Connection => Rename Entity Connection => MyDatabaseEntities => next => Select your table => Finish.
=> Name it MyModel.edmx => Add => Generate from Database =>
next => New Connection => Provide Server details and select Database
=> Test Connection => Rename Entity Connection => MyDatabaseEntities => next => Select your table => Finish.
Right click on Controllers => Add Controller StudentController=> Add.
Build Solution.
public
class
StudentController
: Controller
{
//
//
GET: /Student/
public
ActionResult
List()
{
List<Student>
allStudents = new
List<Student>();
using
(MyDatabaseEntities
dc = new
MyDatabaseEntities())
{
allStudents=
dc.Students.ToList();
}
return
View(allStudents);
}
public
ActionResult
DeleteSelected(string[]
ids)
{
int[]
id = null;
if(ids
!= null)
{
id
= new
int[ids.Length];
int
j = 0;
foreach(
string
i in
ids)
{
int.TryParse(i,
out
id[j++]);
}
}
if(id!=
null
&& id.Length > 0)
{
List<Student>
AllSelected = new
List<Student>();
using
(MyDatabaseEntities
dc= new
MyDatabaseEntities())
{
AllSelected
= dc.Students.Where(a => id.Contains(a.Id)).ToList();
foreach(var
i in
AllSelected)
{
dc.Students.Remove(i);
}
dc.SaveChanges();
}
}
return
RedirectToAction("List");
}
}
==================================================================================================
Add View => List and Check Strongly typed view , model Class set to Student, Scaffold template is List => Add
@model
IEnumerable<Multi_Delete_grid_rows_using_Checkboxes_in_asp.net_MVC.Models.Student>
@{
ViewBag.Title
= "List";
var
grid = new
WebGrid(source:
Model, rowsPerPage: 10);
}
<style>
table.gridtable
{
font-family:
Verdana,
Arial,
sans-serif;
font-size:
12px;
color:
#333333;
border-width:
1px;
border-color:
#666666;
border-collapse:
collapse;
}
table.gridtable
th{
border-width:1px;
padding
: 8px;
border-style:solid;
border-color:
#666666;
background-color:#dedede;
}
table.gridtable
td
{
border-width:
1px;
padding
: 8px;
border-style:
solid;
border-color:#666666;
background-color:#ffffff;
}
</style>
<h2>List</h2>
@using
(Html.BeginForm("DeleteSelected",
"Student",
FormMethod.Post))
{
@grid.GetHtml(
tableStyle:"gridtable",
columns:
grid.Columns(
grid.Column(format:@<text><input
type="checkbox"
name="ids"
value="@item.Id"/></text>,
header: "Select"),
grid.Column("Id",
"Id"),
grid.Column("Name",
"Name"),
grid.Column("Class",
"Class"),
grid.Column("Fees",
"Fees")
)
)
<input
type="submit"
value="Delete
Selected"
/>
}
=======================================================================
Set your default page in Route config file
routes.MapRoute(
name:
"Default",
url:
"{controller}/{action}/{id}",
defaults:
new
{ controller = "Student",
action = "List",
id = UrlParameter.Optional
}
);
==================================================================================================
