Reading XML in C# .NET

[saiprex]

Hi all,

I have XML file:

<events>
  <event>
    <date>sample date 1</date>
    <name>sample name 1</name>
  </event>
  <event>
    <date>sample date 2</date>
    <name>sample name 2</name>
  </event>
  <event>
    <date>sample date 3</date>
    <name>sample name 3</name>
  </event>
  ...
</events>
 

I am using XmlTextReader to read the XML file.

XmlTextReader reader = new XmlTextReader(FILENAME);
  while (reader.Read()) {
  ...
  }
 

I need to insert the events in the local SQL database, how would i go about looping through the events?

Thanks.

[myrrdin]

Try something like this using the XmlDocument to allow for DOM style parsing.

XmlTextReader reader = new XmlTextReader("XXX.xml");
            XmlDocument xDoc = new XmlDocument();
            xDoc.Load(reader);
            foreach (XmlNode eventNode in xDoc.ChildNodes)
            {
                // Read the EventNode's children elements
            }

Alternatively you could try using XMLSerialization to serialize the XML into a C# object.

[saiprex]

Try something like this using the XmlDocument to allow for DOM style parsing.

XmlTextReader reader = new XmlTextReader("XXX.xml");
            XmlDocument xDoc = new XmlDocument();
            xDoc.Load(reader);
            foreach (XmlNode eventNode in xDoc.ChildNodes)
            {
                // Read the EventNode's children elements
            }

Alternatively you could try using XMLSerialization to serialize the XML into a C# object.

Thanks, but i've ended up using the following code which did the trick :)

 XmlDocument doc = new XmlDocument();
            doc.Load(URLString);
            XmlElement root = doc.DocumentElement;
            XmlNodeList nodes = root.SelectNodes("//events"); 
 
            foreach (XmlNode node in nodes)
            {
                string date = node["date"].InnerText;
                string name = node["name"].InnerText;
                MessageBox.Show("Date:"+date+" Name:"+name);
            }