VS 2010 [RESOLVED] XML, dropdown boxes, and webpages ... oh my-VBForums
Results 1 to 7 of 7

Thread: [RESOLVED] XML, dropdown boxes, and webpages ... oh my

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Jul 2010
    Posts
    148

    Resolved [RESOLVED] XML, dropdown boxes, and webpages ... oh my

    I would like to develop a webpage with 2 dropdown boxes that can eventually produce another webpage containing a table of results based on the selected dropdown values. The values for the dropboxes will come from an XML file ("Events" and "Age"). The results will come from the same file.

    This request seems standard and I'm sure I read how to do it somewhere, I just can't remember. I was hoping to find a simple .Net or VBA implementation in the CodeBank that I can easily tailor to my need. So far, no luck.

    My search strings include: xml, binding, .Net, VBA, dropdown box , Query

    Any help tracking down a good example would be greatly appreciated.

  2. #2
    PowerPoster dunfiddlin's Avatar
    Join Date
    Jun 2012
    Posts
    8,242

    Re: XML, dropdown boxes, and webpages ... oh my

    Think you want ASP, Guv! They got their own forum.
    As the 6-dimensional mathematics professor said to the brain surgeon, "It ain't Rocket Science!"

    Reviews: "dunfiddlin likes his DataTables" - jmcilhinney

    Please be aware that whilst I will read private messages (one day!) I am unlikely to reply to anything that does not contain offers of cash, fame or marriage!

  3. #3

    Thread Starter
    Addicted Member
    Join Date
    Jul 2010
    Posts
    148

    Re: XML, dropdown boxes, and webpages ... oh my

    Dunfiddlin,

    Thank you for responding to my post. I was hoping to find ways to do it using VB.Net or VBA. Some examples using Windows Forms would be a decent start.

    Also, I looked at the ASP group... not much activity there. Any idea why? Is ASP.Net commonly used?

  4. #4
    eXtreme Programmer .paul.'s Avatar
    Join Date
    May 2007
    Location
    Chelmsford UK
    Posts
    21,471

    Re: XML, dropdown boxes, and webpages ... oh my

    can you post your xml file, or an example of it containing some test data?
    i'll write an example, showing how to create html pages on the fly...

  5. #5

    Thread Starter
    Addicted Member
    Join Date
    Jul 2010
    Posts
    148

    Re: XML, dropdown boxes, and webpages ... oh my

    Here is a snippet of the .xml file I put together from tables of results. My hope is to have two drop down boxes: 1 for AgeGroup and another for Event. Then I'd like to display a table that contains Athlete, Mark, and MeetName.

    I also attached the file.

    Thank you for your help!

    Code:
    <Results><AgeGroup AG="8 and  Under"><Event myname="100 m"><Format>mm:ss.00</Format><Athlete><Name>Rachael</Name><Team></Team><Meet><MeetName>TommySmithYouthInvitational-5/4/2013
    </MeetName><Mark>00:15.60</Mark></Meet></Athlete></Event></AgeGroup><AgeGroup AG="8 and Under"><Event myname="100 m"><Format>mm:ss.00</Format><Athlete><Name>Sydney</Name><Team></Team><Meet><MeetName>TommySmithYouthInvitational-5/4/2013
    </MeetName><Mark>00:16.08</Mark></Meet></Athlete></Event></AgeGroup><AgeGroup AG="8 and Under"><Event myname="100 m"><Format>mm:ss.00</Format><Athlete><Name>Sky</Name><Team></Team><Meet><MeetName>TommySmithYouthInvitational-5/4/2013
    </MeetName><Mark>00:16.23</Mark></Meet></Athlete></Event></AgeGroup><AgeGroup AG="8 and Under"><Event myname="200 m"><Format>mm:ss.00</Format><Athlete><Name>Raqayah</Name><Team></Team><Meet><MeetName>TommySmithYouthInvitational-5/4/2013
    </MeetName><Mark>00:17.66</Mark></Meet></Athlete></Event></AgeGroup><AgeGroup AG="9-10"><Event myname="100 m"><Format>mm:ss.00</Format><Athlete><Name>Issa </Name><Team></Team><Meet><MeetName>TommySmithYouthInvitational-5/4/2013
    </MeetName><Mark>00:17.67</Mark></Meet></Athlete></Event></AgeGroup><AgeGroup AG="9-10"><Event myname="200 m"><Format>mm:ss.00</Format><Athlete><Name>Teniyah </Name><Team></Team><Meet><MeetName>TommySmithYouthInvitational-5/4/2013
    </MeetName><Mark>00:17.75</Mark></Meet></Athlete></Event></AgeGroup><AgeGroup AG="9-10"><Event myname="200 m"><Format>mm:ss.00</Format><Athlete><Name>Tyniah </Name><Team></Team><Meet><MeetName>TommySmithYouthInvitational-5/4/2013
    </MeetName><Mark>00:17.84</Mark></Meet></Athlete></Event></AgeGroup><AgeGroup AG="9-10"><Event myname="100 m"><Format>mm:ss.00</Format><Athlete><Name>Skye </Name><Team></Team><Meet><MeetName>TommySmithYouthInvitational-5/4/2013
    </MeetName><Mark>00:17.91</Mark></Meet></Athlete></Event></AgeGroup><AgeGroup AG="11-12"><Event myname="100 m"><Format>mm:ss.00</Format><Athlete><Name>Shanell </Name><Team></Team><Meet><MeetName>TommySmithYouthInvitational-5/4/2013
    </MeetName><Mark>00:18.13</Mark></Meet></Athlete></Event></AgeGroup><AgeGroup AG="11-12"><Event myname="200 m"><Format>mm:ss.00</Format><Athlete><Name>Raquel </Name><Team></Team><Meet><MeetName>TommySmithYouthInvitational-5/4/2013
    </MeetName><Mark>00:18.33</Mark></Meet></Athlete></Event></AgeGroup><AgeGroup AG="11-12"><Event myname="200 m"><Format>mm:ss.00</Format><Athlete><Name>Loren </Name><Team></Team><Meet><MeetName>TommySmithYouthInvitational-5/4/2013
    </MeetName><Mark>00:18.58</Mark></Meet></Athlete></Event></AgeGroup><AgeGroup AG="11-12"><Event myname="100 m"><Format>mm:ss.00</Format><Athlete><Name>Nailah </Name><Team></Team><Meet><MeetName>TommySmithYouthInvitational-5/4/2013
    </MeetName><Mark>00:18.88</Mark></Meet></Athlete></Event></AgeGroup><AgeGroup AG="11-12"><Event myname="100 m"><Format>mm:ss.00</Format><Athlete><Name>Carmen </Name><Team></Team><Meet><MeetName>TommySmithYouthInvitational-5/4/2013
    </MeetName><Mark>00:19.39</Mark></Meet></Athlete></Event></AgeGroup><AgeGroup AG="13-14"><Event myname="100 m"><Format>mm:ss.00</Format><Athlete><Name>Iyanna </Name><Team></Team><Meet><MeetName>TommySmithYouthInvitational-5/4/2013
    </MeetName><Mark>00:19.39</Mark></Meet></Athlete></Event></AgeGroup><AgeGroup AG="13-14"><Event myname="100 m"><Format>mm:ss.00</Format><Athlete><Name>Chloe </Name><Team></Team><Meet><MeetName>TommySmithYouthInvitational-5/4/2013
    </MeetName><Mark>00:19.57</Mark></Meet></Athlete></Event></AgeGroup><AgeGroup AG="13-14"><Event myname="100 m"><Format>mm:ss.00</Format><Athlete><Name>Maya </Name><Team></Team><Meet><MeetName>TommySmithYouthInvitational-5/4/2013
    </MeetName><Mark>00:19.81</Mark></Meet></Athlete></Event></AgeGroup><AgeGroup AG="13-14"><Event myname="100 m"><Format>mm:ss.00</Format><Athlete><Name>Haley </Name><Team></Team><Meet><MeetName>TommySmithYouthInvitational-5/4/2013
    </MeetName><Mark>00:22.21</Mark></Meet></Athlete></Event></AgeGroup><AgeGroup AG="13-14"><Event myname="200 m"><Format>mm:ss.00</Format><Athlete><Name>Juliana </Name><Team></Team><Meet><MeetName>TommySmithYouthInvitational-5/4/2013
    </MeetName><Mark>00:31.87</Mark></Meet></Athlete></Event></AgeGroup><AgeGroup AG="15-16"><Event myname="200 m"><Format>mm:ss.00</Format><Athlete><Name>Natalie </Name><Team></Team><Meet><MeetName>TommySmithYouthInvitational-5/4/2013
    </MeetName><Mark>00:32.56</Mark></Meet></Athlete></Event></AgeGroup><AgeGroup AG="15-16"><Event myname="200 m"><Format>mm:ss.00</Format><Athlete><Name>Eohna </Name><Team></Team><Meet><MeetName>TommySmithYouthInvitational-5/4/2013
    </MeetName><Mark>00:33.05</Mark></Meet></Athlete></Event></AgeGroup><AgeGroup AG="9-10"><Event myname="400 m"><Format>mm:ss.00</Format><Athlete><Name>Kayla </Name><Team></Team><Meet><MeetName>TommySmithYouthInvitational-5/4/2013
    </MeetName><Mark>00:33.17</Mark></Meet></Athlete></Event></AgeGroup><AgeGroup AG="9-10"><Event myname="400 m"><Format>mm:ss.00</Format><Athlete><Name>Raven </Name><Team></Team><Meet><MeetName>TommySmithYouthInvitational-5/4/2013
    </MeetName><Mark>00:33.19</Mark></Meet></Athlete></Event></AgeGroup><AgeGroup AG="9-10"><Event myname="400 m"><Format>mm:ss.00</Format><Athlete><Name>Brooke</Name><Team></Team><Meet><MeetName>TommySmithYouthInvitational-5/4/2013
    </MeetName><Mark>00:33.47</Mark></Meet></Athlete></Event></AgeGroup><AgeGroup AG="9-10"><Event myname="800 m"><Format>mm:ss.00</Format><Athlete><Name>Tai </Name><Team></Team><Meet><MeetName>TommySmithYouthInvitational-5/4/2013
    </MeetName><Mark>00:34.86</Mark></Meet></Athlete></Event></AgeGroup><AgeGroup AG="9-10"><Event myname="800 m"><Format>mm:ss.00</Format><Athlete><Name>Kayla </Name><Team></Team><Meet><MeetName>TommySmithYouthInvitational-5/4/2013
    </MeetName><Mark>01:28.44</Mark></Meet></Athlete></Event></AgeGroup></Results>
    Attached Files Attached Files

  6. #6
    eXtreme Programmer .paul.'s Avatar
    Join Date
    May 2007
    Location
    Chelmsford UK
    Posts
    21,471

    Re: XML, dropdown boxes, and webpages ... oh my

    something like this:

    html conditional table.zip

  7. #7

    Thread Starter
    Addicted Member
    Join Date
    Jul 2010
    Posts
    148

    Re: XML, dropdown boxes, and webpages ... oh my

    You are a Gentleman and a Scholar... This is exactly what I was looking for. Thank you!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.