Learn More





DNN Community Blog

The Community Blog is a personal opinion of community members and by no means the official standpoint of DNN Corp or DNN Platform. This is a place to express personal thoughts about DNNPlatform, the community and its ecosystem. Do you have useful information that you would like to share with the DNN Community in a featured article or blog? If so, please contact .

The use of the Community Blog is covered by our Community Blog Guidelines - please read before commenting or posting.

New in 2sxc 7: #7 Re-Design DNN-Events with Razor

This is a part of my series The New Features of 2sxc 7 and introduces you to using SQL-Data from DNN in the Visual Query to Re-Template / Re-Design any DNN-Module. In this case I prepared a demo using DNN Events. 

So Imagine you have DNN Events and you want to customize the output - either to

  1. Create a very special design requiring conditions (if ... else ...)
  2. Using additional functionality like Gravatars or something which the default templating doesn't provide
  3. Add additional logic like Video-Parsing, view-counting
  4. Use DNN-Events-Data in JSON for animated output in jQuery, knockoutJS or AngularJS

This Concept Works for All Modules

Remember that this is just a simple demo and will focus on DNN Events. But in general it can be used for any kind of module.

The Basic Principle

In general we always use the following pattern to visualize 3rd-party data:

  1. Request the data from SQL using the DnnSqlDataSource
  2. Optionally provide various parameters - either from the URL (to create lists showing items based on a category or similar) or from Module-Settings (so that the editor can say things like "Show all events here which I created")
  3. Visualize it using Tokens, Razor on WebAPI / JSON (and then any kind of JavaScript)

Get the Demo-App

To show all this I created a simple App for you. Download it here. It shows many functionalities like:

  1. Visual Query using the DnnSqlDataSource
  2. Using Tokens in Queries (both PortalId as well as Url-Parameters)
  3. Using editor-configuration to affect queries using the In-ValueProvider (that's where the content-editor says "Show Events of Module X"
  4. Templating the results with Tokens
  5. Details-View which automatically get shown when the word "Details" appears in the Url
  6. Accessing the list of queries in Razor

Give it a Try

Download, mess around, have fun!

With love from Switzerland,

Daniel Mettler grew up in the jungles of Indonesia and is founder and CEO of 2sic internet solutions in Switzerland and Liechtenstein, an 20-head web specialist with over 600 DNN projects since 1999. He is also chief architect of 2sxc (2SexyContent - see forge), an open source module for creating attractive content and DNN Apps.


There are currently no comments, be the first to post one.

Comment Form

Only registered users may post comments.


2sic Daniel Mettler (124)
Aderson Oliveira (15)
Alec Whittington (11)
Alex Shirley (10)
Andrew Nurse (30)
Anthony Glenwright (5)
Antonio Chagoury (28)
Ash Prasad (21)
Ben Schmidt (1)
Benjamin Hermann (25)
Benoit Sarton (9)
Beth Firebaugh (12)
Bill Walker (36)
Bob Kruger (5)
Brian Dukes (2)
Brice Snow (1)
Bruce Chapman (20)
Bryan Andrews (1)
cathal connolly (55)
Charles Nurse (163)
Chris Hammond (203)
Chris Paterra (55)
Clinton Patterson (28)
Cuong Dang (21)
Daniel Bartholomew (2)
Dave Buckner (2)
David Poindexter (3)
David Rodriguez (2)
Doug Howell (11)
Erik van Ballegoij (30)
Ernst Peter Tamminga (74)
Geoff Barlow (6)
Gifford Watkins (3)
Gilles Le Pigocher (3)
Ian Robinson (7)
Israel Martinez (17)
Jan Blomquist (2)
Jan Jonas (3)
Jaspreet Bhatia (1)
Jenni Merrifield (6)
Joe Brinkman (269)
John Mitchell (1)
Jon Henning (14)
Jonathan Sheely (4)
Jordan Coopersmith (1)
Joseph Craig (2)
Kan Ma (1)
Keivan Beigi (3)
Ken Grierson (10)
Kevin Schreiner (6)
Leigh Pointer (31)
Lorraine Young (60)
Malik Khan (1)
Matthias Schlomann (15)
Mauricio Márquez (5)
Michael Doxsey (7)
Michael Tobisch (3)
Michael Washington (202)
Mike Horton (19)
Mitchel Sellers (28)
Nathan Rover (3)
Navin V Nagiah (14)
Néstor Sánchez (31)
Nik Kalyani (14)
Peter Donker (52)
Philip Beadle (135)
Philipp Becker (4)
Richard Dumas (22)
Robert J Collins (5)
Roger Selwyn (8)
Ruben Lopez (1)
Ryan Martinez (1)
Salar Golestanian (4)
Sanjay Mehrotra (9)
Scott McCulloch (1)
Scott S (11)
Scott Wilkinson (3)
Scott Willhite (97)
Sebastian Leupold (80)
Shaun Walker (237)
Shawn Mehaffie (17)
Stefan Cullmann (12)
Stefan Kamphuis (12)
Steve Fabian (31)
Timo Breumelhof (24)
Tony Henrich (3)
Torsten Weggen (2)
Vicenç Masanas (27)
Vincent Nguyen (3)
Vitaly Kozadayev (6)
Will Morgenweck (37)
Will Strohl (163)
William Severance (5)
Try Evoq
For Free
Start Free Trial
a Demo
See Evoq Live
Need More Information?