SQLView is a free, easy to use module that allows you to display the results of any SQL query in tabular format.
Version 3.0.2 - 2006-Aug-28
- works with DNN3 or DNN4, DNN5
Version 3.0.0 - 2005-Feb-06
- added DotNetNuke 3.0 version
Version 2.3.0 - 2004-Dec-01
- added support for paging
- pager position (top,bottom or both)
- pager type (numeric, prev/next)
- pager style
- rows per page
- added styles for header/footer text areas
- added an initial 'order by' clause setting if sorting is enabled
- fixed sorting bug if column titles contained spaces
Version 2.2.0 - 2004-Aug-21
- 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
Version 2.1.0 - 2004-Aug-08
- token replacement for PortalId, ModuleId, TabId and UserId, plus QueryString parameters
- restriction of any sql text with INSERT, DELETE, UPDATE or DROP statement (this option may be disabled with a web.config setting)
Version 2.0.0 - 2004-Jun-09
- 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