xml reader in asp.net c#

Question

I want to read the following xml file format:

<?xml version="1.0" encoding="ISO-8859-1"?>
<WIDECAST_DVB>
  <channel name="XXX">
    <event id="0" start_time="2015-01-27 14:00:00" duration="28800">
      <short_event_descriptor lang="alb" name="Edicion informativ">Lajme nga vendi dhe bota</short_event_descriptor>
      <extended_event_descriptor lang="alb">
        <text />
      </extended_event_descriptor>
    </event>
    <event id="1" start_time="2015-01-27 22:00:00" duration="28800">
      <short_event_descriptor lang="alb" name="Edicion informativ">Lajme nga vendi dhe bota</short_event_descriptor>
      <extended_event_descriptor lang="alb">
        <text>jchdvdgd 
        </text>
      </extended_event_descriptor>
    </event>
    <event id="2" start_time="2015-01-28 06:00:00" duration="28800">
      <short_event_descriptor lang="alb" name="Edicion informativ">Lajme nga vendi dhe bota</short_event_descriptor>
      <extended_event_descriptor lang="alb">
        <text />
      </extended_event_descriptor>
    </event>
    <event id="3" start_time="2015-01-28 14:00:00" duration="28800">
      <short_event_descriptor lang="alb" name="Edicion informativ">Lajme nga vendi dhe bota</short_event_descriptor>
      <extended_event_descriptor lang="alb">
        <text />
      </extended_event_descriptor>
    </event>
 </channel>
</WIDECAST_DVB>

I want to read this fields:

name, start_time, duration, short event descriptor_name, short event description (text within tags), extended_event_descriptor/text (text within text tag)

my class is:

 public class epg2
    {
        public epg2()
        {
            EventNumber = new List<Event>();
        }
        virtual public string channelname { get; set; }
        virtual public List<Event> EventNumber { get; set; }
        virtual public int number { get; set; }

    }
    public class Event
    {
        public Event()
        {

        }
        virtual public DateTime starttime { get; set; }
        virtual public int duration { get; set; }
        virtual public string name { get; set; }
        virtual public string shortDescription { get; set; }
        virtual public string longDescription { get; set; }

    }

You posted an XML but not a single line of code!? Have you tried to read it? For more info, read: stackoverflow.com/questions/4752796/how-to-read-xml-in-net — Kenan Zahirovic
– Kenan Zahirovic, Commented Feb 16, 2015 at 11:46

Florian Schmidinger · Accepted Answer · 2015-02-16 12:39:50Z

3

Using LinqToXML for example:

XDocument doc = XDocument.Parse(xml);

        var resultChannels =
            doc.Descendants("channel")
                .Select(
                        c =>
                            new epg2()
                            {
                                channelname = c.Attribute("name").Value,
                                EventNumber =
                                    c.Elements("event")
                                    .Select(e =>
                                    new Event()
                                    {
                                        name = e.Element("short_event_descriptor").Attribute("name").Value,
                                        starttime = DateTime.Parse(e.Attribute("start_time").Value),
                                        duration = int.Parse(e.Attribute("duration").Value),
                                        shortDescription = e.Element("short_event_descriptor").Value,
                                        longDescription = e.Element("extended_event_descriptor").Element("text").Value
                                    }).ToList()
                            }).ToList();

edited Feb 16, 2015 at 12:39

answered Feb 16, 2015 at 11:53

Florian Schmidinger

4,6822 gold badges19 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

9 Comments

Maria Agaci Over a year ago

i dont want the results to be array elements

Florian Schmidinger Over a year ago

you can iterate over this array(foreach) and get it one by one or you just do foreach(var item in doc.Descendants("event")) and get the values like in the annonymous type ininitializer

Florian Schmidinger Over a year ago

Its just one possiblility how to be able to do it.

Florian Schmidinger Over a year ago

Added example with foreach

Florian Schmidinger Over a year ago

No clue what the number in epg2 should be mapped to though

|

Collectives™ on Stack Overflow

xml reader in asp.net c#

1 Answer 1

9 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

9 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related