The Advanced DataGrid enables advanced users to display data from any data source directly into a Data Grid. Features Include: Sorting, Filtering, Searching, and Paging.
-For DNN 2.x: 2.1.2
-For DNN 3.x: 3.1.3
-Filter: in the admin page you can specify a field to act as a filter. A drop down will be populated with Distinct values from that Field.
-Sorting: users can click on any column header to sort by that column.
-Search: Allows users to search a specified field for a value. Basically this adds a "[fieldname] Like [value]" to the WHERE clause.
-Paging- Admin can specify whether to use paging on the grid and how many records to show per page.
-Export datagrid to an Excel file.
-Parameter Substitution: SQL can include [dnn:UserID] or [dnn:PortalID] and the system will use the DNN values for the CurrentUserID or the PortalID. E.g. Select FirstName, LastName from Users where UserID = [dnn:UserID].
Please Note: Use of the Advanced DataGrid requires basic knowledge of SQL Syntax and knowledge of the data structures from which data will be pulled. Configuration of the DataGrid is not intended for non-technical users.
-Inline Editing: Allow appropriate users to edit data within the grid.
-Ability to Edit data on a specified separate page. Separate page must generated by the developer.
-View more details- Users will be able to view additional item details on a separate page.
The Advanced DataGrid is continually evolving and all Source Code is open and available. If you make improvements, please send the updated code to david at efficionconsulting.com so that changes can be incorporated into future versions.