ASP.NET JQuery Datatables Server Side Integration In this .Net solution, you will find a full working site using the popular JQuery datatables plugin. The solution is served 100% by data from the backend (this is, it uses datatables with its server side options). This is a nice alternative if you want to display tabular information but you want to use something different than a repeater or a gridview or other commercial (and usually expensive) .Net server components. And why is it a nice alternative?
Other than the price factor we just mentioned, sometimes using server side components makes harder to keep a clear separation of concerns between the client code and the server side stuff. Nowadays MVC is a very mature technology, but we offer this project as a nice in between solution, if you want to keep using WebForms, but you want to reduce the usage of server side components, use trusted and proved JQuery and its plugins on your project, and also, if you want to stay away from the Ajaxtoolkit, a wonderful technology that sometimes can be hard to debug, and also, its black box approach can sometimes generate very heavy traffic between calls. JQuery and its light JSON calls will make your application fast and responsive.
A simple Visual Studio solution using jQuery DataTable with Server-Side processing using .NET
Table of Contents
- Getting Started
- Releases
- Branches
- Dependencies
- External libraries
- Testing
- Pull requests
- Author
Getting Started
- Download the latest release here, or download a previous release here
- Uncompress the ZIP and open the solution with Visual Studio
- Run or Debug the solution and you'll have 1000 rows being server-side processed with jQuery DataTable plugin
- Export the filtered registers in several formats: Excel, CSV, HTML, JSON, XML and YAML
Branches
| Branches | Releases | .NET Version | Description |
|---|---|---|---|
| master | 6.0 (SDK: 6.0.302) | Development branch | |
| net-60 | 3.3.3 3.3.2 3.3.1 3.3.0 3.2.0 3.1.0 3.0.0 | 6.0 (SDK: 6.0.302) | Latest version with .NET 6.0 |
| net-50 | 2.0.0 | 5.0 (SDK: 5.0.402) | Latest version with .NET 5.0 |
| net-50-preview | 1.4.0-preview | 5.0 (SDK: 5.0.100-preview.7.20366.6) | Latest version with .NET 5.0 (info) 🧪 |
| net-core-31 | 1.3.1 1.3.0 | 3.1 (SDK: 3.1.301) | Latest version with .NET Core 3.1 |
| net-core-30 | 1.2.0 | 3.0 (SDK: 3.0.103) | Latest version with .NET Core 3.0 |
| net-core-22 | 1.1.1 1.1.0 | 2.2 (SDK: 2.2.202) | Latest version with .NET Core 2.2 |
| net-core-22-old | 1.0.0 | 2.2 (SDK: 2.2.202) | Old .NET Core 2.2 version (discontinued) |
Dependencies
- EPPlus (v6.2.3)
- Microsoft.AspNetCore.Diagnostics.EntityFrameworkCore (v6.0.7)
- Microsoft.AspNetCore.Identity.EntityFrameworkCore (v6.0.7)
- Microsoft.AspNetCore.Identity.UI (v6.0.7)
- Microsoft.AspNetCore.Mvc.NewtonsoftJson (v6.0.7)
- Microsoft.EntityFrameworkCore.SqlServer (v6.0.7)
- Microsoft.EntityFrameworkCore.Tools (v6.0.7)
- RandomGen (v1.1.6)
- Swashbuckle.AspNetCore (v6.5.0)
- Swashbuckle.AspNetCore.Swagger (v6.5.0)
- YamlDotNet (v13.1.0)
External libraries
- Bootstrap (v5.2.3)
- jQuery (v3.6.4)
- jQuery-datatable (v1.13.4)
- datetime-moment (v1.10.21)
- momentjs (v2.29.4)
Testing
This project was developed and tested using:
- Microsoft Visual Studio Enterpise 2022 (version 17.5.5) + GhostDoc Community VS Extension (v2021.2.21290) for generating XML Documentation
- Windows 11 Pro (version 21H2) (OS build 22000.1936)
