TableDisplay

posted by VDWWD - 11/6/2015
VDWWD Active Since 11/7/2014
Netherlands

reviews Ask a Question



This module can display all the records from a predefined database table or external query on your website. You can select which columns to display and set the default sort order. Options like sorting, paging etc. are available. Module 35350

$0.00

Add To Cart

Description


This module can display all the records from a predefined database table or external query on your website. You can select which columns to display and set the default sort order. Options like sorting, paging etc. are available.
You can The module can also connect to an external database (MS SQL and MySQL).




Module settings

Connection string: Input the connection string to connect to an external database. If the external database is MySQL, check the corresponding checkbox first when inputting the connection string. Leave this empty to use the default DNN database. A connection string should look something like this: Data Source=192.168.0.55; Initial Catalog=DotNetNuke; User ID=DnnUser; Password=1A2b3C4d

Source table: Select the source table to export the records from. If a connection string is entered, the module will retrieve a list of tables from the external database.

Custom query: Input your custom query here. This will be used to export the data instead of a predefined source table.

Allow sorting: If enabled, users can click the column title to sort the table.

Display sort direction arrow: Shows a little arrow indicating the sort direction of the column.

Display export to Excel link: If enabled, users can click an export link to get the table data into Excel.

Use Paging: Enable this option to use paging of the rows with the selected number of items per page.

Rows per page: You can define the number of rows shown per page.





Column Display Settings

Default sort column: Select the column for the default sort order of the table.

Columns to display: Uncheck a column if you do not want it to be displayed in the table.





Which version to install


TableDisplay comes in 2 versions. Normal installation and a HostOnly installation because the module does NOT take Portal ID’s into account. This could potentially be a security risk on shared hosting solutions so when the HostOnly version is installed, only Host account users can change the settings of the module.

Live demo

Go to http://modules.vdwwd.eu for a live demo.