Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeUsing DNN Platf...Using DNN Platf...Using Modules a...Using Modules a...What module should I use to view external SQL DB data, can anybody build a custom one for meWhat module should I use to view external SQL DB data, can anybody build a custom one for me
Previous
 
Next
New Post
4/29/2013 5:49 AM
 

Hello,

I'm a long time DNN user and got stuck trying to find a proper viewer for my data tables.

I've given up DNN development a while ago, because I have never managed to delve through the intricacies of the process in a timely manner. I tend to find, buy and use the correct module for the job I need and forget about development.  

I had developed this .asp application to show my data and have been trying, to no avail, to refurbish it and export it to DNN by finding a module that could do the job. I tried the free ones (data viewers and such) and some of the paid ones but could not manage the job.

All my data in 3 SQL tables on an external DB. The data is in a one to many relation.

The first table contains Titles, subtitles and a flag that toggles the public property of each the Primary Key is the title itself

The second table is in a one to many relation with the first and contains the Title FK, a variable number of PARAGRAPH TITLES for each title and a Text (nvarcharMAX) text description, FK is the Title and primary Key is a counter (ID as Int)

The third table is in a one to many relation with the second table and contains the names of a variable number of photos associated to each title's specific Paragraph.

The ideal would be finding a Module that allows me to view a list of the available Titles, possibily with a thumbnail on the first page. This page should then be able to pass the Title parameter to a second page or an intermediate page that should view as links the available paragraphs for that specific title.

This page should then be able to pass on TWO parameters (Title and Paragraph) to the third page, which would be the details page.

The details page should be able to wiew 2 two parameter queries. The first looking something like Select Text from ParagraphTable where Title = QuerystringTitle and ParagraphTitle = QuerystringParagraphTitle

The second query should be able to extract in a repeater the names of the images associated to the text paragraph and it should look something like Select Photoname from PhotosTable where Title = QuerystringTitle and ParagraphTitle = QuerystringParagraphTitle.

Any idea which form could allow this kind of funcionality? 

Anyone willing to develop a custom form with these functionalities for us at a reasonable price?

Thanks, I appreciate any help you can give

 
New Post
4/29/2013 8:51 PM
 

Hi Edoardo,

I'm confident that you could do this in either Open Web Studio (http://www.openwebstudio.com/) or XmodPro (http://www.dnndev.com/).

 
New Post
4/30/2013 3:14 AM
 
Hi,

Custom module can be developed with your requirement.

Thanks,
Avinash Kumar
Mindfire Solutions,India
 
New Post
4/30/2013 3:44 AM
 

Wow, thanks Barry. I have purchased XMOD a while ago but never really figured out how to use it properly.

Maybe I'll ask the guys that developed it how to go about things. The fact is I already started this job about 4 or 5 times and each and every time I got stuck somewhere and had to give up because this or that funcionality was not possible. 

I guess I'll have to read through the XMOD manual... :/

 
New Post
4/30/2013 5:54 AM
 

What functionality was missing?  Your original post suggests that it's simply reading from three tables.  If you don't get anywhere with XMod/XmodPro, I might be persuaded to try to put an OWS configuration together with you :)  I used to use classic asp too, and found the transition to DotNetNuke confusing, and whilst OpenWebStudio has a steepish learning curve, I can get by now.

 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Using Modules a...Using Modules a...What module should I use to view external SQL DB data, can anybody build a custom one for meWhat module should I use to view external SQL DB data, can anybody build a custom one for me


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out