PREREQUISITES:
* Have an installation of DotNetNuke 5 or above.
* Download OpenWebStudio.
* Purchase Dynamic Forms or use a Dynamic Forms Trial version.
* Install OpenWebStudio and Dynamic Forms onto your DotNetNuke installation.
* Create 1 page, this page will contain a Dynamic Forms module instance and an OpenWebStudio module instance.
GOAL:
* Report off of a flat SQL that contain Dynamic Form Submission information using OWS
SCENARIO:
* We need to build a form using Dynamic Forms to insert and update Books from flat table. This is going to end up being an Admin control.
GETTING STARTED ON PART 2 OF THIS TUTORIAL
GETTING STARTED
1.) Return to the Page where you started Part 1 of this tutorial, building the Dynamic Form
2.) Place an OWS instance onto this page, beneath the Dynamic Forms module
3.) Click on Administration to begin configuring your module.
![FireShot Screen Capture #004 - 'OPENWEBSTUDIOTUTORIAL' - www_datasprings_com_openwebstudiotutorial.png FireShot Screen Capture #004 - 'OPENWEBSTUDIOTUTORIAL' - www_datasprings_com_openwebstudiotutorial.png](http://www.datasprings.com/Portals/0/LiveBlog/2285/FireShot%20Screen%20Capture%20_004%20-%20'OPENWEBSTUDIOTUTORIAL'%20-%20www_datasprings_com_openwebstudiotutorial.png_thumb.png)
A new tab will be opened in your browser. This is the administration area for configuring your OWS instance.
Step 1
We will need to click the new icon, to start from scratch with a new OWS instance.
![FireShot Screen Capture #006 - 'New Configuration - OWS Admin' - www_datasprings_com_DesktopModules_OWS_Admin_aspx.png FireShot Screen Capture #006 - 'New Configuration - OWS Admin' - www_datasprings_com_DesktopModules_OWS_Admin_aspx.png](http://www.datasprings.com/Portals/0/LiveBlog/2285/FireShot%20Screen%20Capture%20_006%20-%20'New%20Configuration%20-%20OWS%20Admin'%20-%20www_datasprings_com_DesktopModules_OWS_Admin_aspx.png_thumb.png)
Now go to the “General Settings” menu tab and add all of the relevant information. Here’s an example of what I have provided:
![FireShot Screen Capture #009 - 'New Configuration - OWS Admin' - www_datasprings_com_DesktopModules_OWS_Admin_aspx#Property.png FireShot Screen Capture #009 - 'New Configuration - OWS Admin' - www_datasprings_com_DesktopModules_OWS_Admin_aspx#Property.png](http://www.datasprings.com/Portals/0/LiveBlog/2285/FireShot%20Screen%20Capture%20_009%20-%20'New%20Configuration%20-%20OWS%20Admin'%20-%20www_datasprings_com_DesktopModules_OWS_Admin_aspx_Property.png_thumb.png)
Save your general savings.
Now we’re going to setup our OWS template to use the SQL Flat table that we have built:
a.) Click on the Item “Region – OnLoad”(Just to highlight)
b.) Click on the “Actions” Menu tab.
c.) Click on the “Query” action.
![FireShot Screen Capture #010 - 'New Configuration - OWS Admin' - www_datasprings_com_DesktopModules_OWS_Admin_aspx#.png FireShot Screen Capture #010 - 'New Configuration - OWS Admin' - www_datasprings_com_DesktopModules_OWS_Admin_aspx#.png](http://www.datasprings.com/Portals/0/LiveBlog/2285/FireShot%20Screen%20Capture%20_010%20-%20'New%20Configuration%20-%20OWS%20Admin'%20-%20www_datasprings_com_DesktopModules_OWS_Admin_aspx_.png_thumb.png)
Take a breath, now here comes the more complicated configuration settings:
Configuring your Query Action:
1.) Double Click on the Query Action that you just added
1.) Provide a name for this Query
2.) Provide the SQL for this Query Action(Select * from DynamicForms_LibraryBooks)
3.) Click “Execute Query”
4.) Click “(Quick Builder)”
5.) Provide the Table Name(DynamicForms_LibraryBooks)
OPTIONAL: Check the checkbox “Include Sorting”. This is a neat feature.
6.) Check the checkbox “Grid”
7.) Check the IsKey checkbox on the far right for BookID(since this column is the Primary Key identifier)
8.) Set BookID as the IsKey for the View and Edit sections.
9.) Click the button “Generate” then click OK
10.) Now Save
![FireShot Screen Capture #011 - 'New Configuration - OWS Admin' - www_datasprings_com_DesktopModules_OWS_Admin_aspx#Property.png FireShot Screen Capture #011 - 'New Configuration - OWS Admin' - www_datasprings_com_DesktopModules_OWS_Admin_aspx#Property.png](http://www.datasprings.com/Portals/0/LiveBlog/2285/FireShot%20Screen%20Capture%20_011%20-%20'New%20Configuration%20-%20OWS%20Admin'%20-%20www_datasprings_com_DesktopModules_OWS_Admin_aspx_Property.png_thumb.png)
Now you should have a beautiful Quick Builder region. Expand the region so you can see the content and details that is being used for your OWS grid.
![FireShot Screen Capture #012 - 'New Configuration - OWS Admin' - www_datasprings_com_DesktopModules_OWS_Admin_aspx#.png FireShot Screen Capture #012 - 'New Configuration - OWS Admin' - www_datasprings_com_DesktopModules_OWS_Admin_aspx#.png](http://www.datasprings.com/Portals/0/LiveBlog/2285/FireShot%20Screen%20Capture%20_012%20-%20'New%20Configuration%20-%20OWS%20Admin'%20-%20www_datasprings_com_DesktopModules_OWS_Admin_aspx_.png_thumb.png)
Now we will save and Publish our OWS instance. Go up and click the two icons in this order:
1.) Save
2.) Publish
![FireShot Screen Capture #013 - 'New Configuration - OWS Admin' - www_datasprings_com_DesktopModules_OWS_Admin_aspx#.png FireShot Screen Capture #013 - 'New Configuration - OWS Admin' - www_datasprings_com_DesktopModules_OWS_Admin_aspx#.png](http://www.datasprings.com/Portals/0/LiveBlog/2285/FireShot%20Screen%20Capture%20_013%20-%20'New%20Configuration%20-%20OWS%20Admin'%20-%20www_datasprings_com_DesktopModules_OWS_Admin_aspx_.png_thumb.png)
We can close our OWS tab for now.
MAPPING OUR OWS INSTANCE TO THE TEMPLATE WE CREATED:
1.) Visit “Settings” from your OWS instance.
![FireShot Screen Capture #014 - 'OPENWEBSTUDIOTUTORIAL' - www_datasprings_com_openwebstudiotutorial.png FireShot Screen Capture #014 - 'OPENWEBSTUDIOTUTORIAL' - www_datasprings_com_openwebstudiotutorial.png](http://www.datasprings.com/Portals/0/LiveBlog/2285/FireShot%20Screen%20Capture%20_014%20-%20'OPENWEBSTUDIOTUTORIAL'%20-%20www_datasprings_com_openwebstudiotutorial.png_thumb.png)
2.) GO to the OWS Settings tab.
![FireShot Screen Capture #016 - 'OPENWEBSTUDIOTUTORIAL' - www_datasprings_com_openwebstudiotutorial.png FireShot Screen Capture #016 - 'OPENWEBSTUDIOTUTORIAL' - www_datasprings_com_openwebstudiotutorial.png](http://www.datasprings.com/Portals/0/LiveBlog/2285/FireShot%20Screen%20Capture%20_016%20-%20'OPENWEBSTUDIOTUTORIAL'%20-%20www_datasprings_com_openwebstudiotutorial.png_thumb.png)
This concludes part 2 of this tutorial. Now you have a page for Managing your books.
![FireShot Screen Capture #017 - 'OPENWEBSTUDIOTUTORIAL' - www_datasprings_com_openwebstudiotutorial.png FireShot Screen Capture #017 - 'OPENWEBSTUDIOTUTORIAL' - www_datasprings_com_openwebstudiotutorial.png](http://www.datasprings.com/Portals/0/LiveBlog/2285/FireShot%20Screen%20Capture%20_017%20-%20'OPENWEBSTUDIOTUTORIAL'%20-%20www_datasprings_com_openwebstudiotutorial.png_thumb.png)