R2i DotNetNuke® Forum

R2i wants you to have the opportunity to ask questions, post reviews, help others or just rant and rave about DotNetNuke® or any of the R2i Modules and Skins. Our team spends hour upon hour, day after day, working on custom DotNetNuke® modules and services; please feel free to ask us anything.
 
Can Listx Do it Dynamic Drop Downs and dynamic sql
Last Post 18 Feb 2009 10:55 PM by kschreiner111. 4 Replies.
Printer Friendly
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages Informative
brwonlineUser is Offline
New Member
New Member
Posts:7

--
03 Nov 2007 02:49 PM  
Is it possible to do the following with Listx.

1. Create 4 drop downs.
2. Create 1 grid.
3. Each drop down queries the database dependant upon the previous drop down e.g. User selects an item in drop down 1 then drop down 2 queries using the parameter selected in drop down 1( using an "action", "session" var??).
3. After all 4 drop downs have "changed" the query is ran for the grid.
4. Extra: the user would experience only the 1st drop down upon entry to the screen. Once they select an item in drop down 1, drop down 2 appears as descriped in #3. As drop down 2 is selected drop down 3 would appear and so on. If then the user after selecting something in all the drop downs and getting the result set back in the grid decides to change the selected value in drop down 2, drop down 3 would requery while drop down 4 would be visable = false ( div or panel or something).

I've started on this, however I'm not certain I can do it with Listx. Can someone let me know if what I'm asking is to do can be donw with Listx and if so, provide the flow for how to do it e.g. Use a panel or div for each dropdown with a Listx var for visiblility which recieves it population from an action based upon the onchanged event of the drop down.

<img src='desktopmodules/ntforums/images/emoticons/sick.gif' height='20' width='20' border='0' title='Sick' align='absmiddle'> Thanks


contactdpUser is Offline
Basic Member
Basic Member
Posts:475

--
03 Nov 2007 04:33 PM  
Yes that is possible....

download the QuickLinks LP and go through what we have done.

here is the Example we have done for one of our client...

http://www.microgenics.com/Default.aspx?tabid=68

Thanks,
DP


Durga Prasad(DP) | Senior Web Engineer<br>R2integrated
kschreiner111User is Offline
New Member
New Member
Posts:4

--
18 Feb 2009 10:52 PM  
test


kschreiner111User is Offline
New Member
New Member
Posts:4

--
18 Feb 2009 10:53 PM  
test

Attachment: emporor.png

kschreiner111User is Offline
New Member
New Member
Posts:4

--
18 Feb 2009 10:55 PM  
test

Attachment: emporor.zip

You are not authorized to post a reply.

Active Forums 4.1
 

New York, NY • Baltimore, MD • Vienna, VA • St. Louis, MO • Seatle, WA • 410.327.0007 • info@R2Integrated.com

Bookmark & Share Bookmark and Share