[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.
Re: XML, dropdown boxes, and webpages ... oh my
Think you want ASP, Guv! They got their own forum.
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?
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...
1 Attachment(s)
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>
1 Attachment(s)
Re: XML, dropdown boxes, and webpages ... oh my
something like this:
Attachment 101197
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!
