Great Ideas. Always Flowing.

We are not happy until you are happy. Client satisfaction guaranteed. Whatever your needs and requirements, we have the skills and resources for the job!

Popular Posts

Tags

2008 2008 Express Add AFTER alert Alias Aliases Alter Alternating And ASC Assist BETA Blog Cancel Check ON Checkbox Checkbox Group Color Column Columns Combo Box Composite Confirm Confirm Message Control CREATE CREATE TABLE Data Data Springs Database DDL DELETE Delete Confirm Demo Demonstration DESC Direct Access DNN DotNetNuke Drop Drop Constratint Drop Down Drop Down List DS Dynamic Dynamic Blog Dynamic Forms Dynamic Registration Dynamic Views Edit Event Example Express Fade In Fade Out Field Filters FK Forms Full-Table Scan Generating Generator Generators Great Ideas Group Help HTML Increase Index Indexes Input Integrity jQuery Label Listbox Listener Message Modify My Account MySQL No NULL Often Ok ON Optimization Optimize Option Options Oracle Order By Perform Performance PK Popup PostreSQL Queries Query QuestionOptionValue Radio Button Radio Button Group References referential Round Script Search Search Filters SearchOption SearchOptionValue Select Server Snippet Sort Springs SQL SQL Driven SQL Driven Query SQL Express SQL Server SQL Server 2005 SQL Server 2008 SQL Server 2008 Express SQL Server 2008 R2 SQL Server Express SSMS Stored Stored Procedure TABLE Tables Temporary Tool Tools Tooltip Tooltips Transact-SQL Trials Triggers TSQL T-SQL Unique UPDATE Use Useful Views Widget Widgets Window Yes [userimage] 10 64 bit Ability ABS Action Active Forums Alleviate Alternating Colors Alternating Rows Analytics ARB asp.net asp.net validation AuthARB Authorize.NET Avoid Back Button Basecamp Blog Blog Posts Blogging Browser Browser Back Browser Close Browser History Browser Script Button cascading style sheet Case Char Character CharAt CharAt() Check chip levinson Click client side validation Close Browser Close Window Collection 5.0 Comment Compatibility Compatible Completion completion event Confirm Message Conform Constraints content localization Count Timer Countdown CRM css csv Cursor Custom Custom HTML Custom JavaScript Custom JavaScript File customer feedback Customize Data Data Integrity Data Springs Data Springs Blog Data Springs Collection Data Springs Development Data Springs Planning Data Springs Training Databases DataSprings Date Time JavaScript Debug Info default value Delete Demonstration DF DNN DNN Authentication DNN Blog DNN Core Profile Property dnn html module dnn modules dnn schedule error dnn schedule multiple DNN Store document document.getElementById DotNetNuke dotnetnuke 5.4.4 DotNetNuke Analytics DotNetNuke Forums DotNetNuke JavaScript DotNetNuke Modules dotnetnuke reporting dotnetnuke scheduler dotnetnuke user image Double Double Quotes DR DROP Drop Constraint DropDown Login DS dynamic Dynamic Data dynamic fields Dynamic Form Dynamic Forms dynamic forms silent post Dynamic Forms Tutorial dynamic login Dynamic PDF Form Completion Event dynamic registration dynamic registration silent post dynamic registration user image dynamic user directory dynamic views DynamicRegistration_Question DynamicRegistration_QuestionResponse email email issues Encapsulated Encapsulation Even Event Event Viewer Example Excel Execute Export Export to Excel Facebook Facebook Connect Field FieldID First FirstName Fix Foreign Key Form Form Post Formatting Forms Forum Flow Full Table Scan Fully Function Google Analytics Google Analytics Ecommerce Great Great ideas Grid guides hidden field Hide Show Rows Highrise Highrise API Hourly Services HTML HTTP Post iDeal IE IE 10 Image Image Button Include Inconsistancy Info Information Injection INSERT Integration Interactive User Import Interface internet Internet Explorer iPAD iPAD App for Highrise iPAD Highrise App Items JavaScript JavaScript hide show JS Function Layout Lead Generation Learn Left Left Quote Link LinkedIn list import Live Blog localization Log Logic Login login module login skin object Loop Mandeeps Match Message Microsoft Live Writer module configuration Modules Monthly Services Name Netherlands New News Blog NL NOT NULL oAuth2 Odd OnClick Open Web Studio opt in email OWS Part 1 Part 2 Passed payment gateway paypal Phone Number Placement Post Postback Posts Premium Integration Premium Services Premium Support Primary Key Procedure Products profile Quarterly Services Question question fields Question Loop Question Value QuestionOption Quick Quotes Recommend Recommendation Recurring Billing Redirect Referential Integrity registration Rendered Replace replace html text report views reports Resolution Resource resource files resx Retrieve Retrieving Right Right Quote Rows Ryan Bakerink Sales Force SalesForce Script Scripting Scripts Sequential Access server side validation Silent Post Single Single Quotes Single Sign On skin object Snowcovered Solution sp Springs SQL sql 2005 pivot sql default value SQL Example sql import SQL Injection sql query sql replace statement sql reports SQL Server sql server 2005 SSL SSO stored stored procedure String style sheet stylesheet Submit Submit Button Submit Image Submit Link success story Suggest Suggestion Support Syntax Table technical techwise research Temp test credit card numbers testimonial Text/HTML thumbnail image Time Timer Tip Token Topic Transaction Trial Trigger TSQL T-SQL Tutorial Twitter Types of Constraints Unique Update Highrise user user directory user profile image users online Variable View Web Based Work Around writer writing xls xlsx XML

In the Flow

rss

Data Springs, Inc. - An online diary and web log from staff and customers for premium DotNetNuke resources, Data Springs Modules, and Data Springs Services.


Dynamic Forms and OpenWebStudio Integration Part 1 of 2

As a developer at Data Springs, you can imagine how many different software components we try out for our Development needs when creating solutions for clients. About 2 years ago I have found a Holy Grail development tool called OpenWebStudio(OWS). The more I work with this tool, the more I respect and invest into this development tool. For me it seems that there are endless possibilities with this module. I haven’t been let down yet. This blog post is a tutorial to getting started in OWS and integrating it with Dynamic Forms 4.0.

 

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:

* Create a report off of a flat SQL table 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 1 OF THIS TUTORIAL

You will need to go to Host-> SQL and create this table.

-------------------

Create Table DynamicForms_LibraryBooks

(

BookID int identity(1,1),

BookName nvarchar(200),

BookDesc nvarchar(2000),

BookCategory nvarchar(200),

DateAdded datetime

)

-------------------

 

Now that you have created this table, we can get started with the first part.

 

Step 1

You should have a page with a Dynamic Forms instance placed on it. Now you will need to add the following fields to the Dynamic Form:

Question Name Short Field Name Question Type Default Value Special Features
DSParam1 DSParam1 Hidden Field none Retrieve values from Querystring variable for this question
DBUpdate DBUPdate Hidden Field False Retrieve values from Querystring variable for this question
Book Name BookName Text Box none none
Book Desc BookDesc Multi Lined Text Box none Field width 200px, field height 100px
Book Category BookCategory Text Box none none

 

Here is an image of the layout:

 

FireShot capture #265 - 'OPENWEBSTUDIOTUTORIAL' - www_datasprings_com_openwebstudiotutorial

Now we must create a SQL Form Completion Event that will insert into the SQL Flat Table that we have created. Go to Form Completion Events and add a new Form Completion Event as the type Dynamic SQL Statement. This Completion Event must fire conditionally based on the value of the DBUpdate field. In order for this Form Completion to Execute we will only fire this event when DBUpdate = False. Now we need to build the insert statement. The insert statement will look very similar to the following script.

----------------------------------------------------

Insert into DynamicForms_LibraryBooks(BookName, BookDesc, BookCategory, DateAdded)

Values('$(BookName)', '$(BookDesc)', '$(BookCategory)', getDate())

--------------------------------------------------

The image below depicts the settings and such that the Dynamic SQL Statement should contain.

FireShot capture #266 - 'OPENWEBSTUDIOTUTORIAL' - www_datasprings_com_openwebstudiotutorial_ctl_edit_mid_2338_questionid_440e50df-68cf-4958-ac43-e793abf62bd4

 

Now you can insert into the DynamicForms_LibraryBooks flat table when you fill out and submit the form. So this Dynamic Form has now achieved an Insert mode for entering records into our table.

 

Step 2

Now we will need to work on the Update mode of this Dynamic Form. So we will start by going to Module Configuration –> Advanced Coding Options –> Initial SQL Rendering/ Bind. The SQL query for this SQL bind will be like the SQL query below:

---------------------------------------------------------

Select BookName, BookDesc, BookCategory from DynamicForms_LibraryBooks where BookID = '$(DSParam1)'

---------------------------------------------------------

Take a look at the settings in the image below:

FireShot capture #267 - 'OPENWEBSTUDIOTUTORIAL' - www_datasprings_com_openwebstudiotutorial_ctl_edit_mid_2338_questionid_440e50df-68cf-4958-ac43-e793abf62bd4

 

Update Settings after configuring these settings for Initial SQL Binding.

 

Now we will need to create another SQL Form Completion Event to account for the Update Mode of the Dynamic Form.

Go to Form Completion Events and add a Dynamic SQL Statement event. This event will need to Execute when DBUpdate = True.

The SQL will look like the following below:

---------------------------------------------------------

Update DynamicForms_LibraryBooks Set BookName = '$(BookName)', BookDesc = '$(BookDesc)', BookCategory = '$(BookCategory)', DateAdded = getDate() where BookID = '$(DSParam1)'

---------------------------------------------------------

The image below depicts the settings for this form completion event:

FireShot capture #268 - 'OPENWEBSTUDIOTUTORIAL' - www_datasprings_com_openwebstudiotutorial_ctl_edit_mid_2338_initial_dynamicformseventsdiv

 

Now our Insert and Update Mode are completed, the next part will be to get an OWS grid to integrate with the work that we have achieved so far.

This concludes part 1 of 3 in this Tutorial. Tutorial Part 2 will be published by Feb 21, 2012.

 

If you have any questions please leave a comment. Also please let me know if you’re interested in a particular example.

 

Thanks,

Ryan




Comments are closed.

Recent Comments

 
 

Join our mailing list...

Get current news and events the easy way
 
 
   
Subscribe Me

Recent Blogs...

 
Copyright 2005 - 2011 by Data Springs, Inc.