Close
Picture of DnnBro Sql2Table

DnnBro Sql2Table

posted by DnnBro - 11/08/2021
$0.00
$79.99
DnnBro Sql2Table
logo
Ever had the need for sending the contents of an SQL view or specific select statement to someone else? And after having sent this a couple of times you would wish they could download the data themselves? This module does just that. Specify an SQL connection and let the module display the data for you. Columns are named as you specify in the select statement. If activated the result can be downloaded as a CSV file.

The module comes with two standard skins - the DnnBro blue skin and a grey skin. If the module should adapt to your specific color scheme a custom skin can be chosen - and you can define the colors of the module (see guide for details).

The examples shown below just selects the first 20 rows from the file table in DNN - but it could be anything - the sky is the limit ;-)

For more details and documentation please refer to dnnbro.com
 

logo The trial is fully functional for 14 days after activation. If a standard license is purchased and added to your DNN installation there is no need for reconfiguration or reinstall - the code base is the same.

A license is for a DNN implementation - you are not restricted to a particular server. That means your licence will remain valid as you deploy your DNN instance to Production, Staging and Development environments which makes it easy for you to maintain your site. This only applies to cloned environments though, a new installation will require a new license.
 

 

Features
Skins The module comes with two standard skins - the DnnBro blue skin and a grey skin. If the module should adapt to your specific color scheme a custom skin can be chosen - and you can define the colors of the module (see guide for details).
Header Define your own header for the table. The header name will also be used as the filename if download the table as a CSV file.
Enable or Disable download option From the settings you can define whether the download button should be visible to the user. Determined on each use of the module in case some tables are to be downloaded and others not.
SQL Connection Determine if the builtin SQL connection from DNN should be used, a stand alone connection for this module only or a shared connection between all instances of this module across the installation. Be careful about the last one if this installation have multiple sites, as it is shared across all sites.

If stand alone or shared connection is chosen you must fill in which SQL server to connect to and provide a username and password. A button for testing the connection is available to ensure the provided information is correct.

All passwords will be saved encrypted in the database for added security.
SQL Execution Two SQL execution types are supported. Use Text for SELECT statements and StoredProcedure if you have a stored procedure to call (without parameters).

If you need to call a stored procedure with parameters you can choose the Text option and type: EXEC StoredProcedureName @Param1, @Param2, etc.
SQL Text Resizeable textbox for entering the SQL to execute
Test SQL Execution A button for testing the SQL execution is available so the settings can be tested before updating the site.

Can be relevant in a production site where you need to know whether the entered SQL will work.
Disable options in web.config If needed some of the available SqlConnectionTypes or SqlExecutionTypes can be disabled. This could be a relevant scenario in a multisite environment where the shared between all type is not desired – or if the individual site users are not allowed to use the built-in SQL connection.

To adjust which connection types and execution types are available the web.config file must be altered manually.

 

 

Blue Skin
Blue Skin

 

 

Gray Skin
Gray Skin

 

 

Settings
Settings