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