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!

Quick login...

Or... now make it easy with Facebook Integration
Connect via Facebook

Top Sellers

Dynamic Registration 4.0

Frustrated over the lack of customization for your user's registration fields? Dynamically setup your DNN Portal with custom registration fields, layout, questions, and other core integration options......

Ultra Video Gallery 4

Ultra Video Gallery is a brother product of Ultra Media Gallery, UVG allows you to upload videos in various format and automatically encode them to flv or H264 format, you also can add videos from internet or record live videos from your webcam.

XMod Pro 2.7 - Forms and Views for Databases

Build high performance, completely customizable data-entry forms and views driven by your DNN and external databases. New built-in tools make it a snap to quickly create data entry forms, data views, and even database tables. Plus, add your own HTML, CSS, Javascript, SQL commands, stored procedures,

Smith Shopping Cart v3.88

The most advanced DotNetNuke shopping cart on the planet. Easy to use e-Commerce, Secure Shopping Cart Software and SEO friendly. B2C / B2B Ecommerce Sites.

Event Calendar and Registration 4.0

One stop solution for events calendar and events registration! FREE DOWNLOAD is available now!

DNN Modules

Forums > Product Discussion - DotNetNuke Modules > Dynamic Forms
SQL Binding to My Tables
Last Post 09-18-2012 04:56 AM by Ryan Bakerink. 9 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages Not Resolved
Steve JenkinsUser is Offline
skipping stones
skipping stones
Posts:6
Avatar

--
08-30-2012 07:38 AM
    How do I start a new form bound to tables in a remote database - not the DNN database?

    I thought from the module description on Snowcovered that this was possible???

    Also, is there a new user guide? The existing one seems to be 2 versions behind with a lot of new functionality included in those two new versions

    Thanks
    Ryan BakerinkUser is Offline
    river guide
    river guide
    Posts:1900
    Avatar

    --
    08-30-2012 08:53 AM
    Hello Steve,

    Demonstration 31 Part 2 or Part 3 goes over Initial SQL Binding:
    www.datasprings.com/formdemos

    We have been working on a new User Guide version for several of our products. It takes quite some time to test features and put together an accurate User Guide.

    Please let me know if you find useful resources here.

    Thanks,

    Ryan
    Steve JenkinsUser is Offline
    skipping stones
    skipping stones
    Posts:6
    Avatar

    --
    08-30-2012 09:18 AM
    Thanks for the quick response.

    Maybe I'm missing something from the demo, but where would I enter the connection string? Doesn't the demo instructions build the table in the default DNN database?

    Maybe I misunderstood the product description where it said "Default database provider can now be an external SQL Server or Oracle data source, allowing standard database to be overridden in specific areas such as SQL Options, and SQL default values." I inferred that to mean that I could enter a connection string and point your wizard to one of the tables in the defined database.

    Maybe I'm just confused. I'm a former IndooGrid customer who had to abandon their product due to non-support and incompatibility with DNN 6. I'm on a deadline and am getting nervous about the web-based registration process I need to build.

    Thanks for your help
    Steve JenkinsUser is Offline
    skipping stones
    skipping stones
    Posts:6
    Avatar

    --
    08-30-2012 09:25 AM
    ryan - 

    I may have found it. I didn't see the button to setup the module configuration. I'll check that out to see how it works.

    Is there a specific connection string syntax for this module? I've seen it enumerated various ways in other programs, etc.

    Thanks again!
    Ryan BakerinkUser is Offline
    river guide
    river guide
    Posts:1900
    Avatar

    --
    08-30-2012 09:31 AM
    Hello Steve,

    This connection string format would prove sufficient for an External Data Base Connection:

    Data Source=ServerIPAddress;Initial Catalog=DataBaseName;User ID=UserName;Password=ThePassword;

    Please let me know if you have any questions.

    Thanks,

    Ryan
    Steve JenkinsUser is Offline
    skipping stones
    skipping stones
    Posts:6
    Avatar

    --
    08-30-2012 10:02 AM
    Ryan - 

    thanks again for your attention.

    I entered the connections string - is there a TEST button to ensure connectivity?

    I also went to the wizard and chose the SQL Creation method. I entered a basic SELECT ALL statement and clicked the button - nothing is reflected on the screen, but I assume that the call failed because the Start Wizard button didn't activate.

    Help!!

    Thanks again. Sorry to be such a pain
    Steve JenkinsUser is Offline
    skipping stones
    skipping stones
    Posts:6
    Avatar

    --
    09-04-2012 03:30 AM
    Anybody have an idea about this? Am I missing something?

    Thanks in advance!
    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    09-05-2012 10:47 AM
    Hi Steve - A couple quick questions here...

    1. Is this other external database SQL Server or Oracle database? There is a more "Global" setting to use and reference an external connection and then there is a more specific setting (per completion event or SQL Binding).

    2. Are you trying to bind data from an existing database table, or initially get that table created to begin with / reference the stored procedures that are already there or new ones?

    The connection string should be entered similar to how it is entered within DotNetNuke Web.Config area where you see ConnectionString"ThisString" etc... If you setup another connection string in the web.config file does that then work under Host, SQL within DotNetNuke?

    Thanks,

    Chad
    Steve JenkinsUser is Offline
    skipping stones
    skipping stones
    Posts:6
    Avatar

    --
    09-14-2012 03:55 AM
    Chad - 

    I am using SQL Server 2008 R2, and I am trying to bind the forms to my own database.

    If it makes more sense to let this product build the tables from form definitions I create, that's fine - I just want the data to go into my database. I'm going to need to use the data collected in a number of ways and assume that it would be much cleaner if the data was in my database.

    How/where does this product store data by design?

    Sorry to be so dense - I just thought the process of building forms based on my database tables would be more straightforward.

    Thanks for your help

    Steve
    Ryan BakerinkUser is Offline
    river guide
    river guide
    Posts:1900
    Avatar

    --
    09-18-2012 04:56 AM
    Hello Steve,

    The process to create SQL tables for a Dynamic Form is straighforward. Dynamic Forms is a development tool and sometimes you're forced into using some development skills to completely configure specific sections of a Dynamic Form.

    Here's the best recommended way to build the SQL you need that's relevant to your Dynamic Form:

    Go to Form Completion Events-> Create a SQL Completion event and towards the bottom you'll see a number of Hyperlinks that will generate SQL for you.

    The SQL Generated is taking into account the questions on your form. It's true that sometimes there's going to be columns generated or pieces of the table that you don't want so simply remove those lines of SQL.

    So the suggested method would be to generate the SQL Script Dynamic Forms gives you relevant to the Action you're doing(INSERT, UPDATE, CREATE TABLE, DELETE) etc.. and modify the SQL to work as you need.

    By design Dynamic Forms stores to a table named DynamicForms_QuestionResponse. However this is a complicated table that maps to the DynamicForms_Question table.

    So this is why it's suggested to use a custom table and insert into this table upon form completion using a SQL Completion Event.

    Please let me know if you have any questions.

    Thanks,

    Ryan




    You are not authorized to post a reply.

    Forums > Product Discussion - DotNetNuke Modules > Dynamic Forms
     
     

    Join our mailing list...

    Get current news and events the easy way
    Subscribe Me

    Recent Blogs...

     
    Copyright 2005 - 2011 by Data Springs, Inc.
     
  • film izle
  • 720 izle
  • film
  • sinema izle
  • film makinesi
  • T�rk�e dublaj film
  • film izle
  • film izle
  • baglan film izle
  • sinema izle
  • 1080 film izle
  • film mercegi