asked on

XML / VB.NET Simple Question... 500pts!

ok... I'm a beginer when it comes to XPATH / XML. Here is my XML File:

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

<Events>
<Event>
<Name>Sweetest Day @ Domaine Nightclub</Name>
<Date>10-16-04</Date>
<NumberOfPhotos>54</NumberOfPhotos>
</Event>
<Event>
<Name>Thank You @ Sauce</Name>
<Date>10-01-04</Date>
<NumberOfPhotos>65</NumberOfPhotos>
</Event>
</Events>

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

I'm trying to just simply read the code in my VB.NET page and set it to String Vars knowing the date such as:

Dim theDate As String = "10-16-04"
Dim EventName = [XML Event Name accoicated with the value of theDate above]
Dim NumberOfPhotos = [XML Number of photos accoicated with the value of theDate above]

Can someone please tell me how to pull those values out? thanx!!

Fahad Mukhtar

Dim MyTextReader As TextReader = File.OpenText("C:\MyXML.XML")
Dim XMLString As String = MyTextReader.ReadToEnd()

Dim myXMLdocument As XmlDocument = New XmlDocument()
myXMLdocument.LoadXml(XMLString)

Dim theDate As String = "10-16-04"
Dim EventName As String = myXMLdocument.GetElementsByTagName("Name").Item(0).InnerText
Dim NumberOfPhotos As String = myXMLdocument.GetElementsByTagName("NumberOfPhotos").Item(0).InnerText

Console.WriteLine(theDate & " " & EventName & " " & NumberOfPhotos)

SOLUTION

Fahad Mukhtar

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

AmanBrar

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Moonbathing

ASKER

When I complie I get a:

Compiler Error Message: BC30002: Type 'TextReader' is not defined.

Clearly cause I have imported the TextReader class... For some reason, I can't get it to work. Can someone tell me where to put my Imports statement? and what should I Import? (if I'm using Desp solution I think it's System.IO if I'm using AmanBrar Solution then I think it's XMLDocument class)

Here is my code:

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
<%@ Control Language="VB" Debug="true" %>
<script runat="server">

sub Page_Load()

Dim MyTextReader As TextReader = File.OpenText("Events.XML")
Dim XMLString As String = MyTextReader.ReadToEnd()
Dim nList As XmlNodeList
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Where do I put the Imports statement and what do I Import?

AmanBrar

plz add the following Imports on top of your .vb page:
Imports System.IO
Imports System.Xml