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.

[dorinbogdan]

Welcome to TheScripts TSDN....

I'd recommend to use XPathDocument, see this article.

[saiprex]

Welcome to TheScripts TSDN....

I'd recommend to use XPathDocument, see this article.

Thanks,

I've found another thread http://www.thescripts.com/forum/thread176391.html

So my C# code is now:

            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);
            }
 

I get the following error:
System.NullReferenceException was unhandled
Message="Object reference not set to an instance of an object."

Any ideas? thanks.

[dorinbogdan]

I think that XmlNodeList is empty.
Try

XmlNodeList nodes = root.SelectNodes("//events");

[saiprex]

I think that XmlNodeList is empty.
Try

XmlNodeList nodes = root.SelectNodes("//events");

That did the trick, thanks for your help :)

[suneethakanchana]

This may works

XmlNodeList nodes = ele.SelectNodes("/events");
        foreach (XmlNode node in nodes)
        {
            string event1 = node["event"].InnerText;
            foreach (XmlNode n in node)
            {
                string name = n["date"].InnerText;
                MessageBox.Show("Event:" + name);
            }
 
            MessageBox.Show("Event:" + event1 );
 
 
        }

[MaraRoses]

@saiprex


Love u!!!!!!!!!!!!!!!!!!!!!!!! Thanks a lot just what i needed!!!!!!!!!!!!!!!!!!!!!!!