Step 1: Create MVC application

• “Start”, then “All Programs” and select “Microsoft Visual Studio 2015”.
• “File”, then “New” and click “Project”, then select “ASP.NET Web Application Template” and provide the Project a name as you wish and click on OK.
• Choose MVC empty application option and click OK

Step 2: Create Employee and City table

CREATE TABLE [dbo].[City](
	[CityID] [int] IDENTITY(1,1) NOT NULL,
	[CityName] [nvarchar](max) NULL,
 CONSTRAINT [PK_City] PRIMARY KEY CLUSTERED 
(
	[CityID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

CREATE TABLE [dbo].[Employee](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[CityID] [int] NOT NULL,
	[Name] [nvarchar](max) NULL,
	[Email] [nvarchar](max) NULL,
	[Salary] [decimal](18, 2) NULL,
	[BirthDate] [datetime] NULL,
	[CreatedDate] [datetime] NULL,
	[IsActive] [bit] NULL,
 CONSTRAINT [PK_Employees] 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] TEXTIMAGE_ON [PRIMARY]

Step 3: Create HomeController.cs and View

@using EmployeeManagement.Logic
@using EmployeeManagement.Helpers
@model EmployeeModel

@Html.Partial("_FilterMenu")

    
Custom Grid with Each Column Filter, Paging and Sorting | DotNettec.com 
    



    @Html.Partial("Sample3List", Model)


@section scripts{
    
    @*start Grid paging/Sorting*@
    
}

@using EmployeeManagement.Logic
@model EmployeeModel
@using PagedList.Mvc
@using EmployeeManagement.Helpers
@using EmployeeManagement.Model

@{
    int i = 0;
    int count = Model.Filters.Count() + 1;
    int id = Model.Table == null ? 0 : Model.Table.Id;
}