DNN Module

Data Studio is a multipurpose solution builder and data analysis application for DNN providing complete custom solutions in just a few clicks. Automating all of the boring technical grunt work so that you can focus on more important tasks.

Combine the Data Studio with OnyakTech Forms for unlimited solutions!

Data Studio Screen Shots

Major Components of Data Studio

  • Admin Control Panel simplifies the Data Studio features making it easier to use and faster to build custom solutions
  • Full CRUD Support: Full Create, Update and Delete data features with the ability to assign specific DNN Roles access to each.
  • Copy and Paste from Excel: Provides mass data bulk import and export in the Spreadsheet Display with full copy and paste between Data Studio and your favorite spreadsheet application. Select your data, press CTRL+C and then click on a cell in Data Studio and press CTRL+V to paste your data. Then click "Save" to upload your changes directly into your database. Data Studio automatically merges your data handling updates, inserts and deletes for you.
  • Data Analysis: Enable searching, grouping, filters, sorting and group expressions.
  • Data Morphing: Dynamically alter the data streamed to the client by providing filters that are used to replace text in your data sets.
  • Dynamic Placement: Keep your data hidden and attach it to the click event of any element on your web page. When the click event is triggered, Data Studio will display your data in a popup.
  • Automatic Refresh: Build an online dashboard with the Automatic Refresh feature in Data Studio providing you with seamless automated data refresh on the client using the inetervals you specify.
  • Cache Performance: Provides full support for large data sets with the new Data Cache feature.
  • Data Links: Convert standard data into hyperlinks. Includes the ability to merge multiple columns allowing you to set one column as the hyperlink text and another for the URL. Also supports images.
  • Metric Indicators: Instantly displays negative numbers in red font
  • 8 Display Types: Multiple Data Grid displays including a detachable grid, Spreadsheet, DBA mode and a Custom display with a new layout designer.
  • Data Connections Manager: Connect to any data source using existing connection strings in your web.config or new connection strings. Supports SQL Server, MS Access, Excel, CSV, AS/400, Oracle, Azure and MySQL.
  • Export Data to PDF, Excel, Word and CSV
  • Import Bulk Data from CSV with streaming performance features
  • Dynamic Query Execution Engine automatically alters the data displayed based on the user and the current action providing you with user specific data solutions.
  • Query Manager brings the power of your favorite SQL editor to the web with intellisense for table looksup. Save your scripts and execute them later on demand.
  • Row Actions: Build custom Row Actions that execute TSQL or JavaScript. Attach your custom Row Actions to new buttons in the Data Grids or execute them during CRUD operations.
  • Dashboard gives you instant access to Data Studio performance and all of the features you use most, making it very easy to tweak the settings for the ultimate data solution.
  • Skins: Includes multiple skins to style your data grids instantly
  • Custom Display Designer: The "Custom Display" is a token based data layout that accepts HTML. With a custom layout, your style is defined per row. It's a template that is merged in with the data for every row in your datasource, replacing the tokens with your data.
  • Drill Down into your data using data from the current row to feed the sub-dataset.
  • Google Maps integration provides a visual map with locations highlighted based on your data. Includes full interaction support making it easy for users to click a row to instantly view it's location on the map.
Includes Skins
Includes Professional Skins with full CSS support to customize to your site
Secure your data
Secure your data and edit access with DNN Roles
Import and Export Data
Import Data from Excel or CSV. Export your data to PDF, CSV, Excel or Word
Add, Edit and Delete Data
Optional Full Data Access allowing users to Add, Edit and Delete
Google Maps Integration
Google Maps Integration
Data Backup
Backup Your Data
SQL Builder
SQL Generator: Don't know SQL? No problem!
Easily Identify Negative Values
Easily Identify Negative Values
Load Dynamic Data
Dynamically Load Data based on the current user, portal, page and more!
Define your own layout
Create Your Own Layout. 100% freedom of design that is token based.
Define Custom Row Actions
Define your own custom actions to execute on selected data rows
Connect to any data source
Connect to Any External Data Source

Screen shots of the Data Studio on real web sites...

Load Dynamic Data
Load Dynamic Data

(Click Images to View Full Size)

Includes Members Area Access on
Includes current minor releases, members forums and support.