Efficion Consulting > DNN > Modules

Downloads

Advanced Datagrid 3.1.3 - Install
Advanced Datagrid 3.1.3 - Private Assembly
Advanced Datagrid 3.1.3 - Source
Advanced Datagrid 3.1.3- Source
Editable DataGrid

FAQs



What should the connection string look like when using a database other than the main DNN database? What's an example of a SQL SELECT Statement? Can the Grid display images and/or Links? Where's the Project (vbproj) file?

Version Information

Version 3.1.3
-Moved style stuff to module.css
-Moved Settings to DNN3 Settings page
-If a filter is specified and "Display All" isn't checked, the datagrid won't populate until a filter is selected.

Version 2.1.2/3.1.2
-Added Parameter Substitution for [dnn:UserID] and [dnn:PortalID]

Version 2.1.1
-Improves the help system so it works like DNN 3.
-Improved Exception Handling on populating the Filter Dropdown

Version 2.1.0
-Adds Export to Excel option (Contributed by Matt Brinkhoff)
-Minor bug fixes

Version 2.0.2.x
-Fixed Bug: First item in Filter list overwritten when Display All option checked.
-Added Online Help link and Documentation link and file
-Updated the general information about the Advanced Data Grid in various places

Version 2.0.1.x
-Style information moved to the top of the ASCX file (contributed by Richard Thurgood)
-Table added to better organize the various sections (contributed by Richard Thurgood)
-Added Sorting
-Added Page Count
-Added options for Paging Styles- numbers vs. Next/Prev

Version 2.0.0
-First release for DotNetNuke 2.0

Version 1.x
New Features-
-Search: Users can search all articles in the portal
-Archive: There's now a More Articles link that will display all Articles or, a custom
link can be input to display a particular page.
-Images: An image can be displayed for each article. Thumbnails are automatically
Generated and a MaxWidth for thumbnail size can be set.
-Uses the TextEditor Provider so that different Text Editors can be used (I'm using FTB 2.0.7)
-Adds ability to Link to External Page, Internal Page, No Link, or HTML
-Featured Articles- allows users to mark an Article as Featured and the Article List
has an option to display only featured articles

About the Advanced DataGrid

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.

Current Versions:
-For DNN 2.x: 2.1.2
-For DNN 3.x: 3.1.3

Current Features:
-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.

Coming features:
Version 2.2
-Inline Editing: Allow appropriate users to edit data within the grid.

Version 2.x
-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.

Advanced DataGrid

Neighborhood:

BarName:

BarName	Address	Phone	Neighborhood
1860's Hard Shell Café and Bar	1860 S 9th	314-231-1860	Soulard
33 Wine Bar	1913 Park Ave	231-9463	Lafayette Square
34 club			Central West End
Absolutely Goosed	3196 S. Grand	772-0400	South Grand
AJ's Nightclub	315 Chestnut	314-241-7400	Downtown Core
Arcelia's	2001 Park Ave	231-9200	Lafayette Square
Attitude's	4100 Manchester	(314) 534-3858	Vandeventer
Bar Italia Ristorante & Caffe	13 Maryland Plaza	314-361-7010	Central West End
Bar St. Louis	612 North 2nd	314-241-4550	Laclede's Landing
BB's Jazz, Blues & Soups	700 S Broadway	314-436-5222	South Broadway
Beale on Broadway	701 S. Broadway	314.621.7880	South Broadway
Big Daddy's	1000 Sidney	314-771-3066	Soulard
Black Thorn Pub	3735 Wyoming	314-776-0534	South Grand
Broadway Oyster Bar	736 S Broadway	(cell) 581-3609, bar 314-621-8811	South Broadway
Bussone's Wine & Spirits	1011 Olive	(314) 241-1083	Downtown Core
Cafe Balaban	405 North Euclid	314.361.8085	Central West End
Caleco's	101 N Broadway	(314) 421-0708	Downtown Core
Candy's/Chod's St. Louis Bar & Chili Parlor	205 N. 9th	314-621-8445	Downtown Core
Carmine's Steak House	20 South 4th Street	(314) 241-1631	Downtown Core
Carson's Sports Bar	1712 S. 9th	(314) 436-2707	Soulard
<< Back Next >>

Export to Excel [ Page 1 of 8 ]

Comments

Please post comments and questions in the Advanced Data Grid forum.

Donate!

Like my work? Help support my efforts to produce great new modules for the DNN community by making a small donation through Paypal.