turn IQueryables into datagrids
Install-Package Mvc.JQuery.DataTables
Install-Package Mvc.JQuery.DataTables.Templates *
- turn any IQueryable into a live datagrid. Tested with:
- Linq To Objects
- Entity Framework
- Lucene.Net.Linq
- wraps the very comprehensive jquery datatables plugin. Supported features:
- Filtering (text, date or datetime range (with datepicker), number ranges, choose from dropdown, multiple values using checkboxes)
- Sorting (configurable per column)
- Paging (choose page size options, or fix them)
- Customer column rendering
- Custom positioning of filters (e.g. you could move them above the table)
- Localization
- TableTools support (PDF/Excel export)
- Attribute based configuration (optional)
- Can be run from dll
*skip this if using EmbeddedResourceVirtualPathProvider
See the test page and example project for info on how to use
http://nuget.org/packages/Mvc.JQuery.DataTables
The code here is based on code from http://code.google.com/p/datatables-asp-mvc/
Note to users
This library has been developed on an as-needed basis, so not all configuration settings from datatables are implemented yet. If you need a setting to be added, please fork the project, update the code, and update the example page to include a usage of the new setting (where this makes sense) e.g. https://github.com/mcintyre321/mvc.jquery.datatables/commit/c70f9c1f51178386e84a73ccea4495343f815012
If you have a feature request, bug, or a patch, please could you add an example page on a fork demonstrating the problem or feature. Thanks!
If you have found this project useful, please consider contributing some documentation - it's the biggest weakness!
THANKS
To https://randomuser.me/ for the image thumbnails used in the example site