The newest version of SQLView is now available as a free download for registered users. Enhancements included in version 2.2.0:
- added catch word, SELECT INTO
- added optional footer which appears under the grid
- header and footer are hidden if they do not contain any text
- added OLEDB connection string option, leave empty to use the portal default
- added AccessDataProvider
SQLView is a free, easy to use module that allows you to display the results of any SQL query in tabular format.
- compatible with DotNetNuke 2.0.0+
- uses new data provider model
- specify sql query as a select from a table, view or stored procedure
- sorting ascending/descending on each column
- customizable formatting for the grid, header row, even row and odd row
- display an additional header comment
- token replacement in sql query for PortalId, TabId, ModuleId, UserId and any Query String parameter
Richard Edwards
DNNStuff Admin
www.dnnstuff.com
Home of Aggregator (Tabbed Modules) and free module SQLView