How to implement server-side search with jQuery DataTables in ASP.NET Core using this library?

Decorate your model properties with attributes like [SearchableString] or [SearchableDateTime], use the tag helper in views, and configure the DataTable AJAX call to post parameters. The library handles query building dynamically via SearchOptionsProcessor.

JqueryDataTablesServerSide vs other DataTables libraries for .NET – which is better?

JqueryDataTablesServerSide excels for ASP.NET Core with attribute-based configuration and built-in exports, reducing boilerplate. Alternatives like DataTables.Net offer more cross-platform .NET support but less integration. Choose based on your stack: this library for tight ASP.NET Core and jQuery synergy, others for flexibility.

How to export DataTables data to Excel in ASP.NET Core with this library?

Use the JqueryDataTablesExcelResult action result in your controller or page handler, passing filtered data from a service method. For AJAX POST, store parameters in session; for AJAX GET, bind them directly. Ensure models have [IncludeInReport] attributes from v4.0.0.

Can I use JqueryDataTablesServerSide with Razor Pages instead of MVC?

Yes, the library fully supports Razor Pages. The README provides examples for PageHandler methods, such as OnPostLoadTableAsync and OnGetExcelAsync, showing how to handle AJAX requests and exports seamlessly in Razor Pages.

How to handle nested models in DataTables server-side processing?

Decorate nested properties with [NestedSearchable] and [NestedSortable] attributes, and include them in your query with EntityFramework includes. The library processes nested levels dynamically, as shown in the DemoNestedLevelOne and DemoNestedLevelTwo model examples.

What are the performance benefits of using JqueryDataTablesServerSide for large datasets?

By performing sorting, filtering, and pagination at the database level via server-side processing, it reduces client-side load and network transfer. However, efficient indexing and query optimization are still required to avoid server bottlenecks with complex queries.

Open-Awesome

JqueryDataTablesServerSide

MITC#

A server-side processor for jQuery DataTables in ASP.NET Core enabling dynamic multi-column filtering, sorting, pagination, and Excel/CSV export.

GitHub

234 stars38 forks0 contributors

What is JqueryDataTablesServerSide?

JqueryDataTablesServerSide is a server-side processor library for jQuery DataTables in ASP.NET Core applications. It enables dynamic multi-column filtering, sorting, pagination, and Excel/CSV export functionality by handling data operations on the server, which improves performance and reduces client-side processing for large datasets.

Target Audience

ASP.NET Core developers building web applications with complex data tables that require server-side processing, especially those using jQuery DataTables for interactive data display and needing advanced filtering, sorting, and export capabilities.

Value Proposition

Developers choose this library because it drastically reduces the boilerplate code needed to implement server-side DataTables features, provides built-in export functionality, and offers a clean attribute-based configuration model that integrates seamlessly with ASP.NET Core's MVC and Razor Pages.

Overview

Asp.Net Core Server Side for Jquery DataTables Multiple Column Filtering and Sorting with Pagination and Excel Export

Use Cases

Best For

Implementing server-side pagination and sorting for large datasets in ASP.NET Core
Adding advanced multi-column search filters to jQuery DataTables with custom operators
Exporting filtered and sorted table data to Excel or CSV directly from the server
Simplifying DataTables integration in Razor Pages or MVC views using tag helpers
Handling nested or complex model properties in DataTables server-side processing
Reducing client-side JavaScript code for DataTables configuration and AJAX handling

Not Ideal For

Projects using modern JavaScript frameworks like React or Vue.js without jQuery
Applications requiring real-time data updates via WebSockets instead of AJAX calls
Teams that avoid decorating domain models with library-specific attributes to maintain clean architecture
Simple CRUD applications where client-side DataTables without server-side processing suffice

Pros & Cons

Pros

Attribute-Driven Configuration

Uses simple attributes like [Searchable] and [Sortable] on model properties to handle filtering and sorting, reducing manual query building as shown in the model examples with EntityProperty mapping.

Built-in Export Features

Includes JqueryDataTablesExcelResult and JqueryDataTablesCSVResult for easy Excel and CSV exports directly from server-side data, leveraging the Fingers10.ExcelExport package without extra code.

Tag Helper Simplicity

Provides <jquery-datatables> tag helpers that automatically generate table HTML with search inputs, making view setup straightforward as demonstrated in the Table HTML section with customizable CSS classes.

Nested Model Handling

Supports complex data structures with [NestedSearchable] and [NestedSortable] attributes, allowing server-side operations on nested properties up to any level without custom logic.

Cons

Mandatory Attribute Overhead

From version 4.0.0, all simple model properties must be decorated with [JqueryDataTableColumn] and [IncludeInReport] attributes, increasing configuration burden and tightly coupling models to the library.

Complex Initial Setup

Requires specific JSON serialization settings (e.g., System.Text.Json or Newtonsoft.Json) and session management in Startup.cs, which can be error-prone and adds unnecessary complexity for basic use.

jQuery and ASP.NET Core Lock-in

Tightly integrated with jQuery DataTables and ASP.NET Core, making it unsuitable for projects using other frontend frameworks or backend technologies, with no support for hybrid or client-side processing.

Frequently Asked Questions

Related Projects

AutoMapper

A convention-based object-object mapper in .NET.

Stars10,191

Forks2,409

Last commit15 days ago

Humanizer

Humanizer meets all your .NET needs for manipulating and displaying strings, enums, dates, times, timespans, numbers and quantities

Stars9,643

Forks1,051

Last commit11 days ago

AngleSharp

:angel: The ultimate angle brackets parser library parsing HTML5, MathML, SVG and CSS to construct a DOM based on the official W3C specifications.

Stars5,495

Forks590

Last commit1 month ago

markdig

A fast, powerful, CommonMark compliant, extensible Markdown processor for .NET

Stars5,239

Forks505

Last commit12 days ago

Community-curated · Updated weekly · 100% open source

Found a gem we're missing?

Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.

Submit a project Star on GitHub