ASP.NET Core - Using jQuery DataTables Grid
Please donate 👇👇🙂
https://www.paypal.com/paypalme/sarra...
In this video , we are going to learn how to use a Client-side Grid (DataTables Grid) with ASP.NET Core MVC in a step-by-step manner.
As you know, there are no inbuilt Grids in ASP.NET Core. You need to either create your own or use third-party Grids available from the NuGet package. The best option is to use the client-side grid. In this video , I am going to use the jQuery DataTables Grid.
In this video , we are focusing on Filtering.
Steps:
- Created a database with the name “CustomerDB”.
👉 https://github.com/haythamsarawy/Usin...
- Installing the Package for Entity Framework Core from NuGet
Microsoft.EntityFrameworkCore.SqlServer
- Add a Connection String and Setting Up DbContext
After adding a reference, now add a connection string in the appsetting.json file
- Add a class that will inherit the DbContext class
- Add a new Service in Startup.cs class for injecting dependency.
- Adding Model Customer
- Adding DbSet for Customer Model in DatabaseContext class
- Getting DataTables Scripts:
http://ajax.googleapis.com/ajax/libs/...
https://cdn.datatables.net/1.10.15/js...
https://cdn.datatables.net/1.10.15/js...
- The following CSS files are used
https://cdn.datatables.net/1.10.15/cs...
https://cdn.datatables.net/responsive...
- Adding ShowGrid Action Method in DemoGrid Controller
- Adding ShowGrid View in DemoGrid Folder
- Adding DataTables Grid to ShowGrid View
- Adding DataTables Markup
- Adding DataTables Function to Create DataTables
- DataTables Options:
* Processing - Enables or disables the display of a 'processing' indicator when the table is being
processed (e.g. a sort).
* serverSide - Server-side processing - where filtering, paging, and sorting calculations are all
performed by a server.
* Filter - this option is used for enabling and disabling of the search box
* orderMulti - When ordering is enabled (ordering), by default DataTables allows users to sort
multiple columns by shift-clicking upon the header cell for each column. Although this can be
quite useful for users, it can also increase the complexity of the order, potentially increasing the
processing time of ordering the data. Therefore, this option is provided to allow this shift-click
multiple column ability Ajax - Ajax request is made to get data to DataTables.
* columnDefs - Set column definition initialisation properties.
* Columns - Set column specific initialization properties.
- Adding LoadData Action Method to DemoGrid Controller
For using OrderBy in the query, we need to install System.Linq.Dynamic package from NuGet
packages.
asp.net mvc best free grid
best grid for asp.net mvc 5
datatables grid view
datatables grid lines
datatables grid layout
datatables grid with asp.net mvc
datatables grid edit
datatables grid refresh
datatables grid example
data table grid bootstrap
grid datatable c#
grid datatable bootstrap
datatables grid buttons
binding datatable to gridview
grid datasource datatable
datatable grid filter
datatable grid in jquery
datatable grid in asp.net
datatable grid in c#
grid datatable jquery
grid view datatable javascript
datatables.net grid
datatables grid pagination
datatables grid sorting
datatable grid scrolling
asp.net gridview
asp.net gridview sorting
asp.net gridview paging
asp.net gridview column width
asp.net gridview select row
asp.net grid view
asp.net gridview add columns programmatically
asp.net gridview autogeneratecolumns
asp.net grid button
asp.net core gridview
asp.net core grid control free
asp.net core grid with paging
asp.net core grid example
asp.net core gridview example
asp.net core grid control
asp.net core grid view
asp net core gridview example
asp.net core grid free
asp.net core grid bootstrap
asp.net core best grid
grid binding in asp.net core
asp.net core grid component
asp.net core mvc grid control
asp.net core grid demo
asp.net mvc gridview
asp.net mvc gridview example
asp.net mvc grid control
asp.net mvc gridview crud
asp.net mvc gridview editable
asp.net mvc grid with paging
asp.net mvc gridview entity framework
asp.net mvc grid example
asp.net mvc grid view
asp.net mvc grid component
datatables ajax
datatables asp.net mvc
datatables bootstrap 4
datatables.net tutorial
datatables json
datatables buttons
datatables asp.net core
datatables add class to row
datatables
datatable jquery
datatable bootstrap 4
data table c#
datatable jquery ajax example
datatable ajax reload example
datatable asp.net c#
datatable api
datatable ajax json example
datatable asp.net
datatable asp.net mvc
datatable buttons
datatable filter all columns
datatable filter by column value
datatable filter by column value c#